diff options
Diffstat (limited to 'mysql-test/r/myisam_debug.result')
-rw-r--r-- | mysql-test/r/myisam_debug.result | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/mysql-test/r/myisam_debug.result b/mysql-test/r/myisam_debug.result index 36a8fe6c724..39cbd69cdb0 100644 --- a/mysql-test/r/myisam_debug.result +++ b/mysql-test/r/myisam_debug.result @@ -1,6 +1,7 @@ # # BUG#40827 - Killing insert-select to MyISAM can cause table corruption # +CONNECT insertConn, localhost, root,,; CREATE TABLE `t1` ( `id` BIGINT(20) , `id1` BIGINT(20) AUTO_INCREMENT, @@ -12,11 +13,11 @@ CREATE TABLE `t2` ( KEY (id1), KEY(id) ) ENGINE=MyISAM; INSERT INTO t2 (id) VALUES (123); -# Switch to insert Connection +connection insertConn; SET SESSION debug_dbug='+d,wait_in_enable_indexes'; # Send insert data INSERT INTO t1(id) SELECT id FROM t2; -# Switch to default Connection +connection default; # Wait for insert data to reach the debug point SELECT ID FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE = 'wait_in_enable_indexes' AND @@ -27,3 +28,4 @@ CHECK TABLE t1; Table Op Msg_type Msg_text test.t1 check status OK DROP TABLE t1,t2; +disconnect insertConn; |