| 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; |