2
DROP TABLE IF EXISTS t1;
4
CREATE TABLE t1(c1 BIT NULL);
5
CREATE INDEX i1 ON t1(c1);
7
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
8
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
9
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
10
CREATE TABLE t1(c1 TINYINT NULL);
11
CREATE INDEX i1 ON t1(c1);
13
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
14
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
15
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
16
CREATE TABLE t1(c1 SMALLINT NULL);
17
CREATE INDEX i1 ON t1(c1);
19
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
20
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
21
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
22
CREATE TABLE t1(c1 MEDIUMINT NULL);
23
CREATE INDEX i1 ON t1(c1);
25
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
26
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
27
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
28
CREATE TABLE t1(c1 INT NULL);
29
CREATE INDEX i1 ON t1(c1);
31
let $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 t1; DROP TABLE t1; SHOW TABLES;
34
CREATE TABLE t1(c1 INTEGER NULL);
35
CREATE INDEX i1 ON t1(c1);
37
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
38
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
39
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
40
CREATE TABLE t1(c1 BIGINT NULL);
41
CREATE INDEX i1 ON t1(c1);
43
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
44
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
45
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
46
CREATE TABLE t1(c1 REAL NULL);
47
CREATE INDEX i1 ON t1(c1);
49
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
50
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
51
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
52
CREATE TABLE t1(c1 DOUBLE NULL);
53
CREATE INDEX i1 ON t1(c1);
55
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
56
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
57
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
58
CREATE TABLE t1(c1 FLOAT NULL);
59
CREATE INDEX i1 ON t1(c1);
61
let $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 t1; DROP TABLE t1; SHOW TABLES;
64
CREATE TABLE t1(c1 DECIMAL NULL);
65
CREATE INDEX i1 ON t1(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" ""
69
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
70
CREATE TABLE t1(c1 NUMERIC NULL);
71
CREATE INDEX i1 ON t1(c1);
73
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
74
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
75
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
76
CREATE TABLE t1(c1 DATE NULL);
77
CREATE INDEX i1 ON t1(c1);
79
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
80
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
81
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
82
CREATE TABLE t1(c1 TIME NULL);
83
CREATE INDEX i1 ON t1(c1);
85
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
86
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
87
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
88
CREATE TABLE t1(c1 TIMESTAMP NULL);
89
CREATE INDEX i1 ON t1(c1);
91
let $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 t1; DROP TABLE t1; SHOW TABLES;
94
CREATE TABLE t1(c1 YEAR NULL);
95
CREATE INDEX i1 ON t1(c1);
97
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
98
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
99
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
100
CREATE TABLE t1(c1 BIT NOT NULL);
101
CREATE INDEX i1 ON t1(c1);
103
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
104
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
105
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
106
CREATE TABLE t1(c1 TINYINT NOT NULL);
107
CREATE INDEX i1 ON t1(c1);
109
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
110
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
111
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
112
CREATE TABLE t1(c1 SMALLINT NOT NULL);
113
CREATE INDEX i1 ON t1(c1);
115
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
116
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
117
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
118
CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
119
CREATE INDEX i1 ON t1(c1);
121
let $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 t1; DROP TABLE t1; SHOW TABLES;
124
CREATE TABLE t1(c1 INT NOT NULL);
125
CREATE INDEX i1 ON t1(c1);
127
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
128
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
129
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
130
CREATE TABLE t1(c1 INTEGER NOT NULL);
131
CREATE INDEX i1 ON t1(c1);
133
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
134
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
135
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
136
CREATE TABLE t1(c1 BIGINT NOT NULL);
137
CREATE INDEX i1 ON t1(c1);
139
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
140
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
141
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
142
CREATE TABLE t1(c1 REAL NOT NULL);
143
CREATE INDEX i1 ON t1(c1);
145
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
146
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
147
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
148
CREATE TABLE t1(c1 DOUBLE NOT NULL);
149
CREATE INDEX i1 ON t1(c1);
151
let $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 t1; DROP TABLE t1; SHOW TABLES;
154
CREATE TABLE t1(c1 FLOAT NOT NULL);
155
CREATE INDEX i1 ON t1(c1);
157
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
158
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
159
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
160
CREATE TABLE t1(c1 DECIMAL NOT NULL);
161
CREATE INDEX i1 ON t1(c1);
163
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
164
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
165
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
166
CREATE TABLE t1(c1 NUMERIC NOT NULL);
167
CREATE INDEX i1 ON t1(c1);
169
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
170
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
171
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
172
CREATE TABLE t1(c1 DATE NOT NULL);
173
CREATE INDEX i1 ON t1(c1);
175
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
176
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
177
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
178
CREATE TABLE t1(c1 TIME NOT NULL);
179
CREATE INDEX i1 ON t1(c1);
181
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
182
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
183
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
184
CREATE TABLE t1(c1 TIMESTAMP NOT NULL);
185
CREATE INDEX i1 ON t1(c1);
187
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
188
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
189
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
190
CREATE TABLE t1(c1 YEAR NOT NULL);
191
CREATE INDEX i1 ON t1(c1);
193
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
194
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
195
SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;