Debian Codegraph @

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

raw
1 --disable_warnings
2 let $ENGINE=`select variable_value from performance_schema.global_variables where variable_name='DEFAULT_STORAGE_ENGINE'`;
3 --enable_warnings
4
5 --disable_warnings
6 DROP TABLE IF EXISTS t4;
7 --enable_warnings
8 CREATE TABLE t4(c1 TINYBLOB NULL);
9 CREATE UNIQUE INDEX i1 ON t4(c1(100));
10 SHOW TABLES;
11 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
12 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
13 CREATE TABLE t4(c1 BLOB NULL);
14 CREATE UNIQUE INDEX i1 ON t4(c1(100));
15 SHOW TABLES;
16 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
17 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
18 CREATE TABLE t4(c1 MEDIUMBLOB NULL);
19 CREATE UNIQUE INDEX i1 ON t4(c1(100));
20 SHOW TABLES;
21 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
22 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
23 CREATE TABLE t4(c1 LONGBLOB NULL);
24 CREATE UNIQUE INDEX i1 ON t4(c1(100));
25 SHOW TABLES;
26 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
27 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
28 CREATE TABLE t4(c1 TINYTEXT NULL) charset latin1;
29 CREATE UNIQUE INDEX i1 ON t4(c1(100));
30 SHOW TABLES;
31 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
32 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
33 CREATE TABLE t4(c1 TEXT NULL);
34 CREATE UNIQUE INDEX i1 ON t4(c1(100));
35 SHOW TABLES;
36 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
37 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
38 CREATE TABLE t4(c1 MEDIUMTEXT NULL);
39 CREATE UNIQUE INDEX i1 ON t4(c1(100));
40 SHOW TABLES;
41 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
42 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
43 CREATE TABLE t4(c1 LONGTEXT NULL);
44 CREATE UNIQUE INDEX i1 ON t4(c1(100));
45 SHOW TABLES;
46 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
47 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
48 CREATE TABLE t4(c1 TINYBLOB NOT NULL);
49 CREATE UNIQUE INDEX i1 ON t4(c1(100));
50 SHOW TABLES;
51 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
52 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
53 CREATE TABLE t4(c1 BLOB NOT NULL);
54 CREATE UNIQUE INDEX i1 ON t4(c1(100));
55 SHOW TABLES;
56 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
57 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
58 CREATE TABLE t4(c1 MEDIUMBLOB NOT NULL);
59 CREATE UNIQUE INDEX i1 ON t4(c1(100));
60 SHOW TABLES;
61 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
62 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
63 CREATE TABLE t4(c1 LONGBLOB NOT NULL);
64 CREATE UNIQUE INDEX i1 ON t4(c1(100));
65 SHOW TABLES;
66 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
67 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
68 CREATE TABLE t4(c1 TINYTEXT NOT NULL) charset latin1;
69 CREATE UNIQUE INDEX i1 ON t4(c1(100));
70 SHOW TABLES;
71 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
72 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
73 CREATE TABLE t4(c1 TEXT NOT NULL);
74 CREATE UNIQUE INDEX i1 ON t4(c1(100));
75 SHOW TABLES;
76 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
77 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
78 CREATE TABLE t4(c1 MEDIUMTEXT NOT NULL);
79 CREATE UNIQUE INDEX i1 ON t4(c1(100));
80 SHOW TABLES;
81 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
82 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
83 CREATE TABLE t4(c1 LONGTEXT NOT NULL);
84 CREATE UNIQUE INDEX i1 ON t4(c1(100));
85 SHOW TABLES;
86 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
87 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;