Debian Codegraph @

mysql-test/suite/parts/t/reorganize.test

raw
1 --source include/have_sequence.inc
2 --source include/have_partition.inc
3 --source include/have_debug.inc
4
5 --echo #
6 --echo # MDEV-23248 Server crashes in mi_extra /
7 --echo # ha_partition::loop_extra_alter upon REORGANIZE
8 --echo #
9
10 CREATE TABLE t1 (a INT, b INT) ENGINE=MyISAM PARTITION BY RANGE (a) SUBPARTITION BY HASH (a) SUBPARTITIONS 70 (PARTITION p1 VALUES LESS THAN (100), PARTITION p2 VALUES LESS THAN MAXVALUE);
11 INSERT INTO t1 SELECT 4, 6 FROM seq_1_to_131072;
12 UPDATE t1 SET a = 7;
13
14 set @org_debug=@@debug_dbug;
15 set @@debug_dbug="+d,debug_abort_copy_partitions";
16 --error ER_UNSUPPORTED_EXTENSION
17 ALTER TABLE t1 REORGANIZE PARTITION p1,p2 INTO (PARTITION p1 VALUES LESS THAN (5), PARTITION p2 VALUES LESS THAN MAXVALUE);
18 set @@debug_dbug=@org_debug;
19
20 DROP TABLE t1;