Debian Codegraph @

mysql-test/suite/engines/funcs/t/ta_string_drop_column.test

raw
1 --disable_warnings
2 let $ENGINE=`select variable_value from performance_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`;
3 --enable_warnings
4
5 --disable_warnings
6 DROP TABLE IF EXISTS t1;
7 --enable_warnings
8 CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 CHAR(30));
9 SHOW TABLES;
10 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
11 SHOW CREATE TABLE t1;
12 ALTER TABLE t1 DROP c2;
13 --error 1090
14 ALTER TABLE t1 DROP c1;
15 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
16 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
17 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 VARCHAR(30));
18 SHOW TABLES;
19 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
20 SHOW CREATE TABLE t1;
21 ALTER TABLE t1 DROP c2;
22 --error 1090
23 ALTER TABLE t1 DROP c1;
24 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
25 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
26 CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 BINARY(30));
27 SHOW TABLES;
28 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
29 SHOW CREATE TABLE t1;
30 ALTER TABLE t1 DROP c2;
31 --error 1090
32 ALTER TABLE t1 DROP c1;
33 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
34 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
35 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 VARBINARY(30));
36 SHOW TABLES;
37 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
38 SHOW CREATE TABLE t1;
39 ALTER TABLE t1 DROP c2;
40 --error 1090
41 ALTER TABLE t1 DROP c1;
42 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
43 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
44 CREATE TABLE t1(c1 CHAR(30) NOT NULL, c2 CHAR(30));
45 SHOW TABLES;
46 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
47 SHOW CREATE TABLE t1;
48 ALTER TABLE t1 DROP COLUMN c2;
49 --error 1090
50 ALTER TABLE t1 DROP COLUMN c1;
51 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
52 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
53 CREATE TABLE t1(c1 VARCHAR(30) NOT NULL, c2 VARCHAR(30));
54 SHOW TABLES;
55 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
56 SHOW CREATE TABLE t1;
57 ALTER TABLE t1 DROP COLUMN c2;
58 --error 1090
59 ALTER TABLE t1 DROP COLUMN c1;
60 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
61 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
62 CREATE TABLE t1(c1 BINARY(30) NOT NULL, c2 BINARY(30));
63 SHOW TABLES;
64 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
65 SHOW CREATE TABLE t1;
66 ALTER TABLE t1 DROP COLUMN c2;
67 --error 1090
68 ALTER TABLE t1 DROP COLUMN c1;
69 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
70 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
71 CREATE TABLE t1(c1 VARBINARY(30) NOT NULL, c2 VARBINARY(30));
72 SHOW TABLES;
73 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
74 SHOW CREATE TABLE t1;
75 ALTER TABLE t1 DROP COLUMN c2;
76 --error 1090
77 ALTER TABLE t1 DROP COLUMN c1;
78 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
79 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;