| 1 |
############################################################################# |
| 2 |
# Test script to test EXPORT/IMPORT for a partitioned table in older version |
| 3 |
# having INSTANT ADD columns. |
| 4 |
# |
| 5 |
# CREATE TABLE t1 (c1 INT, c2 INT, c3 INT, c4 TEXT) row_format=COMPACT |
| 6 |
# PARTITION BY RANGE(c1 * 2) |
| 7 |
# (PARTITION p0 VALUES LESS THAN (128), |
| 8 |
# PARTITION p1 VALUES LESS THAN (256), |
| 9 |
# PARTITION p2 VALUES LESS THAN (384), |
| 10 |
# PARTITION p3 VALUES LESS THAN MAXVALUE); |
| 11 |
# INSERT INTO t1 VALUES(1, 2, 3, 'abcdefg'), (100, 200, 300, 'qwerty'), (200, 300, 400, 'asdfg'); |
| 12 |
# ALTER TABLE t1 ADD COLUMN c5 CHAR(20) default "c5_def", ALGORITHM=INSTANT; |
| 13 |
# INSERT INTO t1 VALUES(300, 400, 500, "xxxxxx", "r4c5") ; |
| 14 |
############################################################################# |
| 15 |
|
| 16 |
--source include/have_debug.inc |
| 17 |
let $is_debug=1; |
| 18 |
|
| 19 |
--source suite/innodb/t/instant_ddl_import_old_part.test |