|
2200.2.7
by Stewart Smith
add a test for ALTER TABLE with both renaming the table and another operation. |
1 |
CREATE TABLE t1 (a int primary key);
|
2 |
ALTER TABLE t1 RENAME t2, ADD COLUMN b int;
|
|
3 |
show tables;
|
|
4 |
show create table t2;
|
|
5 |
ALTER TABLE t2 ADD COLUMN c int, rename t3;
|
|
6 |
show tables;
|
|
7 |
show create table t3;
|
|
|
2200.2.8
by Stewart Smith
in test for ALTER TABLE including RENAME and others, add a test for DISABLE KEYS, RENAME as there is a special RENAME TABLE code path for this case. |
8 |
ALTER TABLE t3 DISABLE KEYS, RENAME t4;
|
9 |
show tables;
|
|
10 |
show create table t4;
|
|
|
2200.2.9
by Stewart Smith
add a utterly insane test of combination of renaming table and disable/enable keys to alter_table_rename_plus test |
11 |
ALTER TABLE t4 ENABLE KEYS, RENAME t5, DISABLE KEYS, RENAME t6, ENABLE KEYS;
|
12 |
show tables;
|
|
13 |
show create table t6;
|
|
14 |
DROP TABLE t6;
|