summaryrefslogtreecommitdiffstats
path: root/storage/oqgraph/mysql-test/oqgraph/regression_1233113.test
diff options
context:
space:
mode:
Diffstat (limited to 'storage/oqgraph/mysql-test/oqgraph/regression_1233113.test')
-rw-r--r--storage/oqgraph/mysql-test/oqgraph/regression_1233113.test40
1 files changed, 40 insertions, 0 deletions
diff --git a/storage/oqgraph/mysql-test/oqgraph/regression_1233113.test b/storage/oqgraph/mysql-test/oqgraph/regression_1233113.test
new file mode 100644
index 00000000..db53b2b3
--- /dev/null
+++ b/storage/oqgraph/mysql-test/oqgraph/regression_1233113.test
@@ -0,0 +1,40 @@
+--disable_warnings
+DROP TABLE IF EXISTS graph_base;
+DROP TABLE IF EXISTS graph;
+--enable_warnings
+
+call mtr.add_suppression("graph_base is open on delete");
+
+# Create the backing store
+CREATE TABLE graph_base (
+ from_id INT UNSIGNED NOT NULL,
+ to_id INT UNSIGNED NOT NULL,
+ PRIMARY KEY (from_id,to_id),
+ INDEX (to_id)
+ ) ENGINE=MyISAM;
+
+
+CREATE TABLE graph (
+ latch VARCHAR(32) NULL,
+ origid BIGINT UNSIGNED NULL,
+ destid BIGINT UNSIGNED NULL,
+ weight DOUBLE NULL,
+ seq BIGINT UNSIGNED NULL,
+ linkid BIGINT UNSIGNED NULL,
+ KEY (latch, origid, destid) USING HASH,
+ KEY (latch, destid, origid) USING HASH
+ ) ENGINE=OQGRAPH DATA_TABLE='graph_base' ORIGID='from_id', DESTID='to_id';
+
+
+INSERT INTO graph_base(from_id, to_id) VALUES (1,2), (2,1);
+INSERT INTO graph_base(from_id, to_id) VALUES (3,2), (2,3);
+INSERT INTO graph_base(from_id, to_id) VALUES (1,3), (3,1);
+
+# The following line crashes when MTR run with --gdb, see bug https://bugs.launchpad.net/oqgraph/+bug/1233113
+--error 1036
+update graph set origid=123;
+
+# Otherwise, MTR hangs on the next line
+DROP TABLE graph_base;
+DROP TABLE graph;
+