diff options
Diffstat (limited to 'storage/oqgraph/mysql-test/oqgraph/regression_1233113.test')
-rw-r--r-- | storage/oqgraph/mysql-test/oqgraph/regression_1233113.test | 40 |
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; + |