diff options
Diffstat (limited to 'mysql-test/main/range_interrupted-13751.test')
| -rw-r--r-- | mysql-test/main/range_interrupted-13751.test | 14 |
1 files changed, 6 insertions, 8 deletions
diff --git a/mysql-test/main/range_interrupted-13751.test b/mysql-test/main/range_interrupted-13751.test index b0793edeb9d..939f15b2145 100644 --- a/mysql-test/main/range_interrupted-13751.test +++ b/mysql-test/main/range_interrupted-13751.test @@ -1,17 +1,15 @@ --- source include/have_debug.inc +--source include/have_debug.inc --source include/default_optimizer_switch.inc +--source include/have_sequence.inc # # MDEV-13751 Interrupted SELECT fails with 1030: 'Got error 1 "Operation not permitted" from storage engine MyISAM' # CREATE TABLE t1 (i INT AUTO_INCREMENT, c VARCHAR(1), KEY(i), KEY(c,i)) ENGINE=MyISAM; -INSERT INTO t1 (c) VALUES ('a'),('b'),('c'),('d'); -INSERT INTO t1 (c) SELECT c FROM t1; -INSERT INTO t1 (c) SELECT c FROM t1; -INSERT INTO t1 (c) SELECT c FROM t1; -INSERT INTO t1 (c) SELECT c FROM t1; -INSERT INTO t1 (c) SELECT c FROM t1; -INSERT INTO t1 (c) SELECT c FROM t1; +INSERT INTO t1 (c) select mid("abcdefgh", mod(seq,8)+1, 1) from seq_1_to_256; + +explain SELECT 1 FROM t1 AS alias1, t1 AS alias2, t1 AS alias3 +WHERE alias1.c = alias2.c OR alias1.i <= 1; set @old_dbug=@@session.debug_dbug; SET debug_dbug="+d,kill_join_init_read_record"; |