Debian Codegraph @

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

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