Debian Codegraph @

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

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t2;
3 --enable_warnings
4 CREATE TABLE t2(c1 CHAR(50) NULL);
5 CREATE UNIQUE INDEX i1 ON t2(c1);
6 SHOW TABLES;
7 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
8
9
10 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
11 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
12 CREATE TABLE t2(c1 VARCHAR(50) NULL);
13 CREATE UNIQUE INDEX i1 ON t2(c1);
14 SHOW TABLES;
15 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
16
17
18 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
19 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
20 CREATE TABLE t2(c1 BINARY(50) NULL);
21 CREATE UNIQUE INDEX i1 ON t2(c1);
22 SHOW TABLES;
23 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
24
25
26 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
27 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
28 CREATE TABLE t2(c1 VARBINARY(50) NULL);
29 CREATE UNIQUE INDEX i1 ON t2(c1);
30 SHOW TABLES;
31 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
32
33
34 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
35 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
36 CREATE TABLE t2(c1 CHAR(50) NOT NULL);
37 CREATE UNIQUE INDEX i1 ON t2(c1);
38 SHOW TABLES;
39 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
40
41
42 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
43 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
44 CREATE TABLE t2(c1 VARCHAR(50) NOT NULL);
45 CREATE UNIQUE INDEX i1 ON t2(c1);
46 SHOW TABLES;
47 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
48
49
50 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
51 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
52 CREATE TABLE t2(c1 BINARY(50) NOT NULL);
53 CREATE UNIQUE INDEX i1 ON t2(c1);
54 SHOW TABLES;
55 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
56
57
58 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
59 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
60 CREATE TABLE t2(c1 VARBINARY(50) NOT NULL);
61 CREATE UNIQUE INDEX i1 ON t2(c1);
62 SHOW TABLES;
63 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
64
65
66 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" ""
67 SHOW CREATE TABLE t2; DROP TABLE t2; SHOW TABLES;
68