2
DROP TABLE IF EXISTS t8;
4
CREATE TABLE t8(c1 TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
6
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
7
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
9
ALTER TABLE t8 MODIFY c1 TINYINT NOT NULL, DROP PRIMARY KEY;
11
let $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 t8; DROP TABLE t8; SHOW TABLES;
14
CREATE TABLE t8(c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
16
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
17
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
19
ALTER TABLE t8 MODIFY c1 SMALLINT NOT NULL, DROP PRIMARY KEY;
21
let $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 t8; DROP TABLE t8; SHOW TABLES;
24
CREATE TABLE t8(c1 MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
26
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
27
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
29
ALTER TABLE t8 MODIFY c1 MEDIUMINT NOT NULL, DROP PRIMARY KEY;
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 t8; DROP TABLE t8; SHOW TABLES;
34
CREATE TABLE t8(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
36
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
37
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
39
ALTER TABLE t8 MODIFY c1 INT NOT NULL, DROP PRIMARY KEY;
41
let $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 t8; DROP TABLE t8; SHOW TABLES;
44
CREATE TABLE t8(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY);
46
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
47
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
49
ALTER TABLE t8 MODIFY c1 INTEGER NOT NULL, DROP PRIMARY KEY;
51
let $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 t8; DROP TABLE t8; SHOW TABLES;
54
CREATE TABLE t8(c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
56
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
57
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
59
ALTER TABLE t8 MODIFY c1 BIGINT NOT NULL, DROP PRIMARY KEY;
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 t8; DROP TABLE t8; SHOW TABLES;
64
CREATE TABLE t8(c1 TINYINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
66
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
67
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
69
ALTER TABLE t8 CHANGE c1 c1 TINYINT NOT NULL, DROP PRIMARY KEY;
71
let $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 t8; DROP TABLE t8; SHOW TABLES;
74
CREATE TABLE t8(c1 SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
76
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
77
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
79
ALTER TABLE t8 CHANGE c1 c1 SMALLINT NOT NULL, DROP PRIMARY KEY;
81
let $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 t8; DROP TABLE t8; SHOW TABLES;
84
CREATE TABLE t8(c1 MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
86
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
87
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
89
ALTER TABLE t8 CHANGE c1 c1 MEDIUMINT NOT NULL, DROP PRIMARY KEY;
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 t8; DROP TABLE t8; SHOW TABLES;
94
CREATE TABLE t8(c1 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
96
let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
97
--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
99
ALTER TABLE t8 CHANGE c1 c1 INT NOT NULL, DROP PRIMARY KEY;
101
let $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 t8; DROP TABLE t8; SHOW TABLES;
104
CREATE TABLE t8(c1 INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY);
106
let $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 t8;
109
ALTER TABLE t8 CHANGE c1 c1 INTEGER NOT NULL, DROP PRIMARY KEY;
111
let $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 t8; DROP TABLE t8; SHOW TABLES;
114
CREATE TABLE t8(c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY);
116
let $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 t8;
119
ALTER TABLE t8 CHANGE c1 c1 BIGINT NOT NULL, DROP PRIMARY KEY;
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 t8; DROP TABLE t8; SHOW TABLES;