1--disable_warnings
2DROP TABLE IF EXISTS t9;
3--enable_warnings
4CREATE TABLE t9(c1 BIT NOT NULL PRIMARY KEY);
5SHOW TABLES;
6let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
7--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
8 SHOW CREATE TABLE t9;
9ALTER TABLE t9 DROP PRIMARY KEY;
10SHOW TABLES;
11let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
12--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
13 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
14CREATE TABLE t9(c1 TINYINT NOT NULL PRIMARY KEY);
15SHOW TABLES;
16let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
17--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
18 SHOW CREATE TABLE t9;
19ALTER TABLE t9 DROP PRIMARY KEY;
20SHOW TABLES;
21let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
22--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
23 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
24CREATE TABLE t9(c1 SMALLINT NOT NULL PRIMARY KEY);
25SHOW TABLES;
26let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
27--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
28 SHOW CREATE TABLE t9;
29ALTER TABLE t9 DROP PRIMARY KEY;
30SHOW TABLES;
31let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
32--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
33 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
34CREATE TABLE t9(c1 MEDIUMINT NOT NULL PRIMARY KEY);
35SHOW TABLES;
36let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
37--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
38 SHOW CREATE TABLE t9;
39ALTER TABLE t9 DROP PRIMARY KEY;
40SHOW TABLES;
41let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
42--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
43 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
44CREATE TABLE t9(c1 INT NOT NULL PRIMARY KEY);
45SHOW TABLES;
46let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
47--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
48 SHOW CREATE TABLE t9;
49ALTER TABLE t9 DROP PRIMARY KEY;
50SHOW TABLES;
51let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
52--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
53 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
54CREATE TABLE t9(c1 INTEGER NOT NULL PRIMARY KEY);
55SHOW TABLES;
56let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
57--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
58 SHOW CREATE TABLE t9;
59ALTER TABLE t9 DROP PRIMARY KEY;
60SHOW TABLES;
61let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
62--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
63 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
64CREATE TABLE t9(c1 BIGINT NOT NULL PRIMARY KEY);
65SHOW TABLES;
66let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
67--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
68 SHOW CREATE TABLE t9;
69ALTER TABLE t9 DROP PRIMARY KEY;
70SHOW TABLES;
71let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
72--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
73 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
74CREATE TABLE t9(c1 REAL NOT NULL PRIMARY KEY);
75SHOW TABLES;
76let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
77--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
78 SHOW CREATE TABLE t9;
79ALTER TABLE t9 DROP PRIMARY KEY;
80SHOW TABLES;
81let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
82--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
83 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
84CREATE TABLE t9(c1 DOUBLE NOT NULL PRIMARY KEY);
85SHOW TABLES;
86let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
87--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
88 SHOW CREATE TABLE t9;
89ALTER TABLE t9 DROP PRIMARY KEY;
90SHOW TABLES;
91let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
92--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
93 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
94CREATE TABLE t9(c1 FLOAT NOT NULL PRIMARY KEY);
95SHOW TABLES;
96let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
97--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
98 SHOW CREATE TABLE t9;
99ALTER TABLE t9 DROP PRIMARY KEY;
100SHOW TABLES;
101let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
102--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
103 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
104CREATE TABLE t9(c1 DECIMAL NOT NULL PRIMARY KEY);
105SHOW TABLES;
106let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
107--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
108 SHOW CREATE TABLE t9;
109ALTER TABLE t9 DROP PRIMARY KEY;
110SHOW TABLES;
111let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
112--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
113 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
114CREATE TABLE t9(c1 NUMERIC NOT NULL PRIMARY KEY);
115SHOW TABLES;
116let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
117--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
118 SHOW CREATE TABLE t9;
119ALTER TABLE t9 DROP PRIMARY KEY;
120SHOW TABLES;
121let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
122--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
123 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
124CREATE TABLE t9(c1 DATE NOT NULL PRIMARY KEY);
125SHOW TABLES;
126let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
127--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
128 SHOW CREATE TABLE t9;
129ALTER TABLE t9 DROP PRIMARY KEY;
130SHOW TABLES;
131let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
132--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
133 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
134CREATE TABLE t9(c1 TIME NOT NULL PRIMARY KEY);
135SHOW TABLES;
136let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
137--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
138 SHOW CREATE TABLE t9;
139ALTER TABLE t9 DROP PRIMARY KEY;
140SHOW TABLES;
141let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
142--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
143 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
144CREATE TABLE t9(c1 TIMESTAMP NOT NULL PRIMARY KEY);
145SHOW TABLES;
146let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
147--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
148 SHOW CREATE TABLE t9;
149ALTER TABLE t9 DROP PRIMARY KEY;
150SHOW TABLES;
151let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
152--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
153 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
154CREATE TABLE t9(c1 YEAR NOT NULL PRIMARY KEY);
155SHOW TABLES;
156let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
157--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
158 SHOW CREATE TABLE t9;
159ALTER TABLE t9 DROP PRIMARY KEY;
160SHOW TABLES;
161let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
162--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
163 SHOW CREATE TABLE t9; DROP TABLE t9; SHOW TABLES;
164
165