1--disable_warnings
2DROP TABLE IF EXISTS t1;
3--enable_warnings
4CREATE TABLE t1(c1 CHAR(100) NULL);
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 t1;
9ALTER TABLE t1 MODIFY c1 CHAR(100) NOT NULL;
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 t1; DROP TABLE t1; SHOW TABLES;
14CREATE TABLE t1(c1 VARCHAR(100) NULL);
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 t1;
19ALTER TABLE t1 MODIFY c1 VARCHAR(100) NOT NULL;
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 t1; DROP TABLE t1; SHOW TABLES;
24CREATE TABLE t1(c1 BINARY(100) NULL);
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 t1;
29ALTER TABLE t1 MODIFY c1 BINARY(100) NOT NULL;
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 t1; DROP TABLE t1; SHOW TABLES;
34CREATE TABLE t1(c1 VARBINARY(100) NULL);
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 t1;
39ALTER TABLE t1 MODIFY c1 VARBINARY(100) NOT NULL;
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 t1; DROP TABLE t1; SHOW TABLES;
44CREATE TABLE t1(c1 CHAR(100) NULL);
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 t1;
49ALTER TABLE t1 CHANGE c1 c1 CHAR(100) NOT NULL;
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 t1; DROP TABLE t1; SHOW TABLES;
54CREATE TABLE t1(c1 VARCHAR(100) NULL);
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 t1;
59ALTER TABLE t1 CHANGE c1 c1 VARCHAR(100) NOT NULL;
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 t1; DROP TABLE t1; SHOW TABLES;
64CREATE TABLE t1(c1 BINARY(100) NULL);
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 t1;
69ALTER TABLE t1 CHANGE c1 c1 BINARY(100) NOT NULL;
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 t1; DROP TABLE t1; SHOW TABLES;
74CREATE TABLE t1(c1 VARBINARY(100) NULL);
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 t1;
79ALTER TABLE t1 CHANGE c1 c1 VARBINARY(100) NOT NULL;
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 t1; DROP TABLE t1; SHOW TABLES;
84
85