Debian Codegraph @

mysql-test/suite/innodb/t/instant_ddl_import_old_part_debug.test

raw
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