Debian Codegraph @

mysql-test/suite/engines/funcs/t/ta_3part_column_to_pk.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 t1;
7 SET sql_mode='NO_ENGINE_SUBSTITUTION';
8 --enable_warnings
9 CREATE TABLE t1(c1 BIT NOT NULL, c2 BIT NOT NULL, c3 BIT NOT NULL);
10 SHOW TABLES;
11 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
12 SHOW CREATE TABLE t1;
13 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
14 SHOW TABLES;
15 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
16 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
17 CREATE TABLE t1(c1 TINYINT NOT NULL, c2 TINYINT NOT NULL, c3 TINYINT NOT NULL);
18 SHOW TABLES;
19 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
20 SHOW CREATE TABLE t1;
21 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
22 SHOW TABLES;
23 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
24 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
25 CREATE TABLE t1(c1 SMALLINT NOT NULL, c2 SMALLINT NOT NULL, c3 SMALLINT NOT NULL);
26 SHOW TABLES;
27 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
28 SHOW CREATE TABLE t1;
29 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
30 SHOW TABLES;
31 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
32 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
33 CREATE TABLE t1(c1 MEDIUMINT NOT NULL, c2 MEDIUMINT NOT NULL, c3 MEDIUMINT NOT NULL);
34 SHOW TABLES;
35 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
36 SHOW CREATE TABLE t1;
37 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
38 SHOW TABLES;
39 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
40 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
41 CREATE TABLE t1(c1 INT NOT NULL, c2 INT NOT NULL, c3 INT NOT NULL);
42 SHOW TABLES;
43 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
44 SHOW CREATE TABLE t1;
45 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
46 SHOW TABLES;
47 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
48 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
49 CREATE TABLE t1(c1 INTEGER NOT NULL, c2 INTEGER NOT NULL, c3 INTEGER NOT NULL);
50 SHOW TABLES;
51 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
52 SHOW CREATE TABLE t1;
53 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
54 SHOW TABLES;
55 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
56 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
57 CREATE TABLE t1(c1 BIGINT NOT NULL, c2 BIGINT NOT NULL, c3 BIGINT NOT NULL);
58 SHOW TABLES;
59 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
60 SHOW CREATE TABLE t1;
61 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
62 SHOW TABLES;
63 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
64 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
65 CREATE TABLE t1(c1 REAL NOT NULL, c2 REAL NOT NULL, c3 REAL NOT NULL);
66 SHOW TABLES;
67 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
68 SHOW CREATE TABLE t1;
69 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
70 SHOW TABLES;
71 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
72 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
73 CREATE TABLE t1(c1 DOUBLE NOT NULL, c2 DOUBLE NOT NULL, c3 DOUBLE NOT NULL);
74 SHOW TABLES;
75 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
76 SHOW CREATE TABLE t1;
77 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
78 SHOW TABLES;
79 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
80 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
81 CREATE TABLE t1(c1 FLOAT NOT NULL, c2 FLOAT NOT NULL, c3 FLOAT NOT NULL);
82 SHOW TABLES;
83 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
84 SHOW CREATE TABLE t1;
85 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
86 SHOW TABLES;
87 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
88 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
89 CREATE TABLE t1(c1 DECIMAL NOT NULL, c2 DECIMAL NOT NULL, c3 DECIMAL NOT NULL);
90 SHOW TABLES;
91 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
92 SHOW CREATE TABLE t1;
93 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
94 SHOW TABLES;
95 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
96 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
97 CREATE TABLE t1(c1 NUMERIC NOT NULL, c2 NUMERIC NOT NULL, c3 NUMERIC NOT NULL);
98 SHOW TABLES;
99 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
100 SHOW CREATE TABLE t1;
101 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
102 SHOW TABLES;
103 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
104 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
105 CREATE TABLE t1(c1 DATE NOT NULL, c2 DATE NOT NULL, c3 DATE NOT NULL);
106 SHOW TABLES;
107 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
108 SHOW CREATE TABLE t1;
109 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
110 SHOW TABLES;
111 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
112 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
113 CREATE TABLE t1(c1 TIME NOT NULL, c2 TIME NOT NULL, c3 TIME NOT NULL);
114 SHOW TABLES;
115 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
116 SHOW CREATE TABLE t1;
117 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
118 SHOW TABLES;
119 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
120 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
121 CREATE TABLE t1(c1 TIMESTAMP NOT NULL, c2 TIMESTAMP NOT NULL, c3 TIMESTAMP NOT NULL);
122 SHOW TABLES;
123 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
124 SHOW CREATE TABLE t1;
125 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
126 SHOW TABLES;
127 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
128 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
129 CREATE TABLE t1(c1 YEAR NOT NULL, c2 YEAR NOT NULL, c3 YEAR NOT NULL);
130 SHOW TABLES;
131 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
132 SHOW CREATE TABLE t1;
133 ALTER TABLE t1 ADD PRIMARY KEY (c1,c2,c3);
134 SHOW TABLES;
135 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
136 SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
137 SET sql_mode='NO_ENGINE_SUBSTITUTION';