1
by brian
clean slate |
1 |
drop table if exists t1,t2,t3,t4,t5; |
2 |
drop database if exists mysqltest; |
|
3 |
create table t1 (b char(0)); |
|
4 |
insert into t1 values (""),(null); |
|
5 |
select * from t1; |
|
6 |
b
|
|
7 |
||
8 |
NULL
|
|
9 |
drop table if exists t1; |
|
10 |
create table t1 (b char(0) not null); |
|
11 |
create table if not exists t1 (b char(0) not null); |
|
12 |
Warnings: |
|
13 |
Note 1050 Table 't1' already exists |
|
14 |
insert into t1 values (""),(null); |
|
722.2.15
by Monty Taylor
Fixed create.test. |
15 |
ERROR 23000: Column 'b' cannot be null |
1
by brian
clean slate |
16 |
select * from t1; |
17 |
b
|
|
18 |
drop table t1; |
|
1233.2.1
by Monty Taylor
Renamed instances of HEAP engine to MEMORY. Removed the alias. |
19 |
create temporary table t1 (a int not null auto_increment,primary key (a)) engine=MEMORY; |
1
by brian
clean slate |
20 |
drop table t1; |
1233.2.1
by Monty Taylor
Renamed instances of HEAP engine to MEMORY. Removed the alias. |
21 |
create temporary table t2 engine=MEMORY select * from t1; |
2140.1.3
by Brian Aker
Merge in error message fix for just one type of error for unknown table. |
22 |
ERROR 42S02: Unknown table 'test.t1' |
1
by brian
clean slate |
23 |
create table t2 select auto+1 from t1; |
2140.1.3
by Brian Aker
Merge in error message fix for just one type of error for unknown table. |
24 |
ERROR 42S02: Unknown table 'test.t1' |
1
by brian
clean slate |
25 |
drop table if exists t1,t2; |
26 |
Warnings: |
|
27 |
Note 1051 Unknown table 't1' |
|
28 |
Note 1051 Unknown table 't2' |
|
29 |
create table t1 (b char(0) not null, index(b)); |
|
30 |
ERROR 42000: The used storage engine can't index column 'b' |
|
1233.2.1
by Monty Taylor
Renamed instances of HEAP engine to MEMORY. Removed the alias. |
31 |
create temporary table t1 (a int not null,b text) engine=MEMORY;
|
1
by brian
clean slate |
32 |
ERROR 42000: The used table type doesn't support BLOB/TEXT columns |
33 |
drop table if exists t1; |
|
34 |
Warnings: |
|
35 |
Note 1051 Unknown table 't1' |
|
1233.2.1
by Monty Taylor
Renamed instances of HEAP engine to MEMORY. Removed the alias. |
36 |
create temporary table t1 (ordid int not null auto_increment, ord varchar(50) not null, primary key (ord,ordid)) engine=MEMORY; |
1
by brian
clean slate |
37 |
ERROR 42000: Incorrect table definition; there can be only one auto column and it must be defined as a key |
38 |
create table not_existing_database.test (a int); |
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
39 |
ERROR 42000: Unknown schema 'not_existing_database' |
1
by brian
clean slate |
40 |
create table `a/a` (a int); |
41 |
show create table `a/a`; |
|
42 |
Table Create Table |
|
43 |
a/a CREATE TABLE `a/a` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
44 |
`a` INT DEFAULT NULL |
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
45 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci |
1
by brian
clean slate |
46 |
create table t1 like `a/a`; |
1547
by Brian Aker
This fixes a bug where we did a full open for a temporary table for CREATE |
47 |
show create table t1; |
48 |
Table Create Table |
|
49 |
t1 CREATE TABLE `t1` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
50 |
`a` INT DEFAULT NULL |
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
51 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci |
1547
by Brian Aker
This fixes a bug where we did a full open for a temporary table for CREATE |
52 |
show create table `t1`; |
53 |
Table Create Table |
|
54 |
t1 CREATE TABLE `t1` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
55 |
`a` INT DEFAULT NULL |
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
56 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci |
1
by brian
clean slate |
57 |
drop table `a/a`; |
58 |
drop table `t1`; |
|
59 |
create table `aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` (aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa int); |
|
60 |
ERROR 42000: Incorrect table name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' |
|
61 |
create table a (`aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` int); |
|
62 |
ERROR 42000: Identifier name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' is too long |
|
63 |
create table t1 (a datetime default now()); |
|
64 |
ERROR 42000: Invalid default value for 'a' |
|
65 |
create table t1 (a datetime on update now()); |
|
66 |
ERROR HY000: Invalid ON UPDATE clause for 'a' column |
|
67 |
create table t1 (a int default 100 auto_increment); |
|
68 |
ERROR 42000: Invalid default value for 'a' |
|
69 |
create table t1 (a varchar(5) default 'abcdef'); |
|
70 |
ERROR 42000: Invalid default value for 'a' |
|
71 |
create table t1 (a varchar(5) default 'abcde'); |
|
72 |
insert into t1 values(); |
|
73 |
select * from t1; |
|
74 |
a
|
|
75 |
abcde
|
|
76 |
alter table t1 alter column a set default 'abcdef'; |
|
77 |
ERROR 42000: Invalid default value for 'a' |
|
78 |
drop table t1; |
|
79 |
create table 1ea10 (1a20 int,1e int); |
|
80 |
insert into 1ea10 values(1,1); |
|
81 |
select 1ea10.1a20,1e+ 1e+10 from 1ea10; |
|
82 |
1a20 1e+ 1e+10 |
|
83 |
1 10000000001 |
|
84 |
drop table 1ea10; |
|
85 |
create table t1 (t1.index int); |
|
86 |
drop table t1; |
|
87 |
drop database if exists mysqltest; |
|
88 |
Warnings: |
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
89 |
Note 1008 Can't drop schema 'mysqltest'; schema doesn't exist |
1
by brian
clean slate |
90 |
create database mysqltest; |
91 |
create table mysqltest.$test1 (a$1 int, $b int, c$ int); |
|
92 |
insert into mysqltest.$test1 values (1,2,3); |
|
93 |
select a$1, $b, c$ from mysqltest.$test1; |
|
94 |
a$1 $b c$ |
|
95 |
1 2 3 |
|
96 |
create table mysqltest.test2$ (a int); |
|
97 |
drop table mysqltest.test2$; |
|
98 |
drop database mysqltest; |
|
99 |
create table `` (a int); |
|
100 |
ERROR 42000: Incorrect table name '' |
|
101 |
drop table if exists ``; |
|
102 |
ERROR 42000: Incorrect table name '' |
|
103 |
create table t1 (`` int); |
|
104 |
ERROR 42000: Incorrect column name '' |
|
105 |
create table t1 (i int, index `` (i)); |
|
106 |
ERROR 42000: Incorrect index name '' |
|
107 |
create table t1 (a int auto_increment not null primary key, B CHAR(20)); |
|
108 |
insert into t1 (b) values ("hello"),("my"),("world"); |
|
109 |
create table t2 (key (b)) select * from t1; |
|
110 |
explain select * from t2 where b="world"; |
|
111 |
id select_type table type possible_keys key key_len ref rows Extra |
|
722.2.15
by Monty Taylor
Fixed create.test. |
112 |
1 SIMPLE t2 ref B B 83 const 1 Using where |
1
by brian
clean slate |
113 |
select * from t2 where b="world"; |
114 |
a B |
|
115 |
3 world |
|
116 |
drop table t1,t2; |
|
117 |
create table t1(x varchar(50) ); |
|
118 |
create table t2 select x from t1 where 1=2; |
|
119 |
describe t1; |
|
1309.4.3
by Brian Aker
Refactor DESC to use new table. |
120 |
Field Type Null Default Default_is_NULL On_Update |
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
121 |
x VARCHAR YES YES |
1
by brian
clean slate |
122 |
describe t2; |
1309.4.3
by Brian Aker
Refactor DESC to use new table. |
123 |
Field Type Null Default Default_is_NULL On_Update |
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
124 |
x VARCHAR YES YES |
1
by brian
clean slate |
125 |
drop table t2; |
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
126 |
create table t2 select now() as a , curdate() as c , 1+1 as d , 1.0 + 1 as e , 33333333333333333 + 3 as f; |
1
by brian
clean slate |
127 |
describe t2; |
1309.4.3
by Brian Aker
Refactor DESC to use new table. |
128 |
Field Type Null Default Default_is_NULL On_Update |
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
129 |
a DATETIME YES YES |
130 |
c DATE NO NO |
|
131 |
d INTEGER NO NO |
|
132 |
e DECIMAL NO NO |
|
133 |
f BIGINT NO NO |
|
1
by brian
clean slate |
134 |
drop table t2; |
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
135 |
create table t2 select CAST("2001-12-29" AS DATE) as d, CAST("2001-12-29 20:45:11" AS DATETIME) as dt; |
1
by brian
clean slate |
136 |
describe t2; |
1309.4.3
by Brian Aker
Refactor DESC to use new table. |
137 |
Field Type Null Default Default_is_NULL On_Update |
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
138 |
d DATE YES YES |
139 |
dt DATETIME YES YES |
|
1
by brian
clean slate |
140 |
drop table t1,t2; |
722.2.15
by Monty Taylor
Fixed create.test. |
141 |
create table t1 (a int); |
1
by brian
clean slate |
142 |
create table t2 (a int) select * from t1; |
143 |
describe t1; |
|
1309.4.3
by Brian Aker
Refactor DESC to use new table. |
144 |
Field Type Null Default Default_is_NULL On_Update |
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
145 |
a INTEGER YES YES |
1
by brian
clean slate |
146 |
describe t2; |
1309.4.3
by Brian Aker
Refactor DESC to use new table. |
147 |
Field Type Null Default Default_is_NULL On_Update |
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
148 |
a INTEGER YES YES |
1
by brian
clean slate |
149 |
drop table if exists t2; |
150 |
create table t2 (a int, a float) select * from t1; |
|
151 |
ERROR 42S21: Duplicate column name 'a' |
|
152 |
drop table if exists t2; |
|
153 |
Warnings: |
|
154 |
Note 1051 Unknown table 't2' |
|
155 |
create table t2 (a int) select a as b, a+1 as b from t1; |
|
156 |
ERROR 42S21: Duplicate column name 'b' |
|
157 |
drop table if exists t2; |
|
158 |
Warnings: |
|
159 |
Note 1051 Unknown table 't2' |
|
160 |
create table t2 (b int) select a as b, a+1 as b from t1; |
|
161 |
ERROR 42S21: Duplicate column name 'b' |
|
162 |
drop table if exists t1,t2; |
|
163 |
Warnings: |
|
164 |
Note 1051 Unknown table 't2' |
|
165 |
CREATE TABLE t1 (a int not null); |
|
166 |
INSERT INTO t1 values (1),(2),(1); |
|
167 |
CREATE TABLE t2 (primary key(a)) SELECT * FROM t1; |
|
168 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY' |
|
169 |
SELECT * from t2; |
|
2140.1.3
by Brian Aker
Merge in error message fix for just one type of error for unknown table. |
170 |
ERROR 42S02: Unknown table 'test.t2' |
1
by brian
clean slate |
171 |
DROP TABLE t1; |
172 |
DROP TABLE IF EXISTS t2; |
|
173 |
Warnings: |
|
174 |
Note 1051 Unknown table 't2' |
|
175 |
create table t1 (a int not null, b int, primary key(a), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b), key (b)); |
|
176 |
show create table t1; |
|
177 |
Table Create Table |
|
178 |
t1 CREATE TABLE `t1` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
179 |
`a` INT NOT NULL, |
180 |
`b` INT DEFAULT NULL, |
|
2363.1.5
by Brian Aker
This patch fixes 798940, we will also just now add the type of index to our create statements. |
181 |
PRIMARY KEY (`a`) USING BTREE, |
182 |
KEY `b` (`b`) USING BTREE, |
|
183 |
KEY `b_2` (`b`) USING BTREE, |
|
184 |
KEY `b_3` (`b`) USING BTREE, |
|
185 |
KEY `b_4` (`b`) USING BTREE, |
|
186 |
KEY `b_5` (`b`) USING BTREE, |
|
187 |
KEY `b_6` (`b`) USING BTREE, |
|
188 |
KEY `b_7` (`b`) USING BTREE, |
|
189 |
KEY `b_8` (`b`) USING BTREE, |
|
190 |
KEY `b_9` (`b`) USING BTREE, |
|
191 |
KEY `b_10` (`b`) USING BTREE, |
|
192 |
KEY `b_11` (`b`) USING BTREE, |
|
193 |
KEY `b_12` (`b`) USING BTREE, |
|
194 |
KEY `b_13` (`b`) USING BTREE, |
|
195 |
KEY `b_14` (`b`) USING BTREE, |
|
196 |
KEY `b_15` (`b`) USING BTREE, |
|
197 |
KEY `b_16` (`b`) USING BTREE, |
|
198 |
KEY `b_17` (`b`) USING BTREE, |
|
199 |
KEY `b_18` (`b`) USING BTREE, |
|
200 |
KEY `b_19` (`b`) USING BTREE, |
|
201 |
KEY `b_20` (`b`) USING BTREE, |
|
202 |
KEY `b_21` (`b`) USING BTREE, |
|
203 |
KEY `b_22` (`b`) USING BTREE, |
|
204 |
KEY `b_23` (`b`) USING BTREE, |
|
205 |
KEY `b_24` (`b`) USING BTREE, |
|
206 |
KEY `b_25` (`b`) USING BTREE, |
|
207 |
KEY `b_26` (`b`) USING BTREE, |
|
208 |
KEY `b_27` (`b`) USING BTREE, |
|
209 |
KEY `b_28` (`b`) USING BTREE, |
|
210 |
KEY `b_29` (`b`) USING BTREE, |
|
211 |
KEY `b_30` (`b`) USING BTREE, |
|
212 |
KEY `b_31` (`b`) USING BTREE |
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
213 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci |
1
by brian
clean slate |
214 |
drop table t1; |
215 |
create table t1 select if(1,'1','0'), month("2002-08-02"); |
|
216 |
drop table t1; |
|
217 |
create table t1 select if('2002'='2002','Y','N'); |
|
218 |
select * from t1; |
|
219 |
if('2002'='2002','Y','N') |
|
220 |
Y
|
|
221 |
drop table if exists t1; |
|
1233.2.1
by Monty Taylor
Renamed instances of HEAP engine to MEMORY. Removed the alias. |
222 |
SET SESSION storage_engine="MEMORY"; |
1
by brian
clean slate |
223 |
SELECT @@storage_engine; |
224 |
@@storage_engine |
|
225 |
MEMORY
|
|
1106.3.1
by Brian Aker
Heap is now tmp only table |
226 |
CREATE TEMPORARY TABLE t1 (a int not null); |
1
by brian
clean slate |
227 |
show create table t1; |
228 |
Table Create Table |
|
1106.3.1
by Brian Aker
Heap is now tmp only table |
229 |
t1 CREATE TEMPORARY TABLE `t1` ( |
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
230 |
`a` INT NOT NULL |
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
231 |
) ENGINE=MEMORY COLLATE = utf8_general_ci |
1
by brian
clean slate |
232 |
drop table t1; |
233 |
SET SESSION storage_engine="gemini"; |
|
234 |
ERROR 42000: Unknown table engine 'gemini' |
|
235 |
SELECT @@storage_engine; |
|
236 |
@@storage_engine |
|
237 |
MEMORY
|
|
1106.3.1
by Brian Aker
Heap is now tmp only table |
238 |
CREATE TEMPORARY TABLE t1 (a int not null); |
1
by brian
clean slate |
239 |
show create table t1; |
240 |
Table Create Table |
|
1106.3.1
by Brian Aker
Heap is now tmp only table |
241 |
t1 CREATE TEMPORARY TABLE `t1` ( |
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
242 |
`a` INT NOT NULL |
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
243 |
) ENGINE=MEMORY COLLATE = utf8_general_ci |
1
by brian
clean slate |
244 |
SET SESSION storage_engine=default; |
245 |
drop table t1; |
|
246 |
create table t1 ( k1 varchar(2), k2 int, primary key(k1,k2)); |
|
247 |
insert into t1 values ("a", 1), ("b", 2); |
|
248 |
insert into t1 values ("c", NULL); |
|
249 |
ERROR 23000: Column 'k2' cannot be null |
|
250 |
insert into t1 values (NULL, 3); |
|
251 |
ERROR 23000: Column 'k1' cannot be null |
|
252 |
insert into t1 values (NULL, NULL); |
|
253 |
ERROR 23000: Column 'k1' cannot be null |
|
254 |
drop table t1; |
|
255 |
create table t1 select x'4132'; |
|
256 |
drop table t1; |
|
257 |
create table t1 select 1,2,3; |
|
258 |
create table if not exists t1 select 1,2; |
|
907.2.3
by Toru Maesaka
Updated the testcase and result file for bug:311046 fix |
259 |
ERROR HY000: Field '1' doesn't have a default value |
1
by brian
clean slate |
260 |
create table if not exists t1 select 1,2,3,4;
|
907.2.3
by Toru Maesaka
Updated the testcase and result file for bug:311046 fix |
261 |
ERROR 21S01: Column count doesn't match value count at row 1 |
1
by brian
clean slate |
262 |
create table if not exists t1 select 1; |
907.2.3
by Toru Maesaka
Updated the testcase and result file for bug:311046 fix |
263 |
ERROR HY000: Field '1' doesn't have a default value |
1
by brian
clean slate |
264 |
select * from t1;
|
265 |
1 2 3
|
|
266 |
1 2 3
|
|
267 |
drop table t1;
|
|
268 |
flush status;
|
|
269 |
create table t1 (a int not null, b int, primary key (a));
|
|
270 |
insert into t1 values (1,1);
|
|
271 |
select * from t1;
|
|
272 |
a b
|
|
273 |
1 1
|
|
274 |
create table if not exists t1 select 3 as 'a',4 as 'b'; |
|
275 |
Warnings:
|
|
276 |
Note 1050 Table 't1' already exists |
|
277 |
create table if not exists t1 select 3 as 'a',3 as 'b'; |
|
278 |
ERROR 23000: Duplicate entry '3' for key 'PRIMARY' |
|
279 |
show warnings;
|
|
280 |
Level Code Message
|
|
281 |
Note 1050 Table 't1' already exists |
|
282 |
Error 1062 Duplicate entry '3' for key 'PRIMARY' |
|
2024.1.2
by Brian Aker
Update to tests, we just want to look at our own tables, not global. |
283 |
select * from DATA_DICTIONARY.TABLE_DEFINITION_CACHE WHERE TABLE_COUNT AND TABLE_SCHEMA = SCHEMA() > 1 ORDER BY TABLE_SCHEMA, TABLE_NAME;
|
1345
by Brian Aker
Corrections. |
284 |
TABLE_SCHEMA TABLE_NAME VERSION TABLE_COUNT IS_NAME_LOCKED
|
1
by brian
clean slate |
285 |
select * from t1;
|
286 |
a b
|
|
287 |
1 1
|
|
288 |
3 4
|
|
289 |
drop table t1;
|
|
290 |
create table `t1 `(a int);
|
|
291 |
ERROR 42000: Incorrect table name 't1 ' |
|
292 |
create database `db1 `;
|
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
293 |
ERROR 42000: Incorrect schema name 'db1 ' |
1
by brian
clean slate |
294 |
create table t1(`a ` int);
|
295 |
ERROR 42000: Incorrect column name 'a ' |
|
296 |
create table t1 (a int,);
|
|
722.2.15
by Monty Taylor
Fixed create.test. |
297 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near ')' at line 1 |
1
by brian
clean slate |
298 |
create table t1 (a int,,b int);
|
722.2.15
by Monty Taylor
Fixed create.test. |
299 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'b int)' at line 1 |
1
by brian
clean slate |
300 |
create table t1 (,b int);
|
722.2.15
by Monty Taylor
Fixed create.test. |
301 |
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'b int)' at line 1 |
1
by brian
clean slate |
302 |
create table t1 (a int, key(a));
|
303 |
create table t2 (b int, foreign key(b) references t1(a), key(b));
|
|
304 |
drop table if exists t1,t2;
|
|
722.2.15
by Monty Taylor
Fixed create.test. |
305 |
ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails
|
306 |
drop table if exists t2,t1;
|
|
307 |
Warnings:
|
|
308 |
Note 1051 Unknown table 't2' |
|
1
by brian
clean slate |
309 |
create table t1(id int not null, name char(20));
|
310 |
insert into t1 values(10,'mysql'),(20,'monty- the creator'); |
|
311 |
create table t2(id int not null);
|
|
312 |
insert into t2 values(10),(20);
|
|
313 |
create table t3 like t1;
|
|
314 |
show create table t3;
|
|
315 |
Table Create Table
|
|
316 |
t3 CREATE TABLE `t3` (
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
317 |
`id` INT NOT NULL,
|
318 |
`name` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL
|
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
319 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci
|
1
by brian
clean slate |
320 |
select * from t3;
|
321 |
id name
|
|
322 |
create table if not exists t3 like t1;
|
|
323 |
Warnings:
|
|
324 |
Note 1050 Table 't3' already exists |
|
325 |
select @@warning_count;
|
|
326 |
@@warning_count
|
|
327 |
1
|
|
328 |
create temporary table t3 like t2;
|
|
329 |
show create table t3;
|
|
330 |
Table Create Table
|
|
331 |
t3 CREATE TEMPORARY TABLE `t3` (
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
332 |
`id` INT NOT NULL
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
333 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci
|
1
by brian
clean slate |
334 |
select * from t3;
|
335 |
id
|
|
336 |
drop table t3;
|
|
337 |
show create table t3;
|
|
338 |
Table Create Table
|
|
339 |
t3 CREATE TABLE `t3` (
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
340 |
`id` INT NOT NULL,
|
341 |
`name` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL
|
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
342 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci
|
1
by brian
clean slate |
343 |
select * from t3;
|
344 |
id name
|
|
345 |
drop table t2, t3;
|
|
346 |
create database mysqltest;
|
|
347 |
create table mysqltest.t3 like t1;
|
|
348 |
create temporary table t3 like mysqltest.t3;
|
|
349 |
show create table t3;
|
|
350 |
Table Create Table
|
|
351 |
t3 CREATE TEMPORARY TABLE `t3` (
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
352 |
`id` INT NOT NULL,
|
353 |
`name` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL
|
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
354 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci
|
1
by brian
clean slate |
355 |
create table t2 like t3;
|
356 |
show create table t2;
|
|
357 |
Table Create Table
|
|
358 |
t2 CREATE TABLE `t2` (
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
359 |
`id` INT NOT NULL,
|
360 |
`name` VARCHAR(20) COLLATE utf8_general_ci DEFAULT NULL
|
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
361 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci
|
1
by brian
clean slate |
362 |
select * from t2;
|
363 |
id name
|
|
364 |
create table t3 like t1;
|
|
2079.3.1
by Brian Aker
Rework the CREATE TABLE LIKE call. |
365 |
ERROR 42S01: Table 'test.t3' already exists |
1
by brian
clean slate |
366 |
create table t3 like mysqltest.t3;
|
2079.3.1
by Brian Aker
Rework the CREATE TABLE LIKE call. |
367 |
ERROR 42S01: Table 'test.t3' already exists |
1
by brian
clean slate |
368 |
create table non_existing_database.t1 like t1;
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
369 |
ERROR 42000: Unknown schema 'non_existing_database' |
2079.3.1
by Brian Aker
Rework the CREATE TABLE LIKE call. |
370 |
create table t4 like non_existing_table;
|
2140.1.3
by Brian Aker
Merge in error message fix for just one type of error for unknown table. |
371 |
ERROR 42S02: Unknown table 'test.non_existing_table' |
1
by brian
clean slate |
372 |
create temporary table t3 like t1;
|
2079.3.1
by Brian Aker
Rework the CREATE TABLE LIKE call. |
373 |
ERROR 42S01: Table 'test.#t3' already exists |
1
by brian
clean slate |
374 |
drop table t1, t2, t3;
|
375 |
drop database mysqltest;
|
|
1233.2.1
by Monty Taylor
Renamed instances of HEAP engine to MEMORY. Removed the alias. |
376 |
SET SESSION storage_engine="MEMORY";
|
1
by brian
clean slate |
377 |
SELECT @@storage_engine;
|
378 |
@@storage_engine
|
|
379 |
MEMORY
|
|
1106.3.1
by Brian Aker
Heap is now tmp only table |
380 |
CREATE TEMPORARY TABLE t1 (a int not null);
|
1
by brian
clean slate |
381 |
show create table t1;
|
382 |
Table Create Table
|
|
1106.3.1
by Brian Aker
Heap is now tmp only table |
383 |
t1 CREATE TEMPORARY TABLE `t1` (
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
384 |
`a` INT NOT NULL
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
385 |
) ENGINE=MEMORY COLLATE = utf8_general_ci
|
1
by brian
clean slate |
386 |
drop table t1;
|
387 |
SET SESSION storage_engine="gemini";
|
|
388 |
ERROR 42000: Unknown table engine 'gemini' |
|
389 |
SELECT @@storage_engine;
|
|
390 |
@@storage_engine
|
|
391 |
MEMORY
|
|
1106.3.1
by Brian Aker
Heap is now tmp only table |
392 |
CREATE TEMPORARY TABLE t1 (a int not null);
|
1
by brian
clean slate |
393 |
show create table t1;
|
394 |
Table Create Table
|
|
1106.3.1
by Brian Aker
Heap is now tmp only table |
395 |
t1 CREATE TEMPORARY TABLE `t1` (
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
396 |
`a` INT NOT NULL
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
397 |
) ENGINE=MEMORY COLLATE = utf8_general_ci
|
1
by brian
clean slate |
398 |
SET SESSION storage_engine=default;
|
399 |
drop table t1;
|
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
400 |
create table t1(a int,b int,c int,d date,e char,f datetime,h blob);
|
1
by brian
clean slate |
401 |
insert into t1(a)values(1);
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
402 |
insert into t1(a,b,c,d,e,f,h)
|
403 |
values(2,-2,2,'1825-12-14','a','2003-01-01 03:02:01','binary data'); |
|
1
by brian
clean slate |
404 |
select * from t1;
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
405 |
a b c d e f h
|
406 |
1 NULL NULL NULL NULL NULL NULL
|
|
407 |
2 -2 2 1825-12-14 a 2003-01-01 03:02:01 binary data
|
|
1
by brian
clean slate |
408 |
select a,
|
722.2.15
by Monty Taylor
Fixed create.test. |
409 |
ifnull(b,-7) as b,
|
410 |
ifnull(c,7) as c,
|
|
1
by brian
clean slate |
411 |
ifnull(d,cast('2000-01-01' as date)) as d, |
412 |
ifnull(e,cast('b' as char)) as e, |
|
413 |
ifnull(f,cast('2000-01-01' as datetime)) as f, |
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
414 |
ifnull(h,cast('yet another binary data' as binary)) as h |
1
by brian
clean slate |
415 |
from t1;
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
416 |
a b c d e f h
|
417 |
1 -7 7 2000-01-01 b 2000-01-01 00:00:00 yet another binary data
|
|
418 |
2 -2 2 1825-12-14 a 2003-01-01 03:02:01 binary data
|
|
1
by brian
clean slate |
419 |
create table t2
|
420 |
select
|
|
421 |
a,
|
|
722.2.15
by Monty Taylor
Fixed create.test. |
422 |
ifnull(b,-7) as b,
|
423 |
ifnull(c,7) as c,
|
|
1
by brian
clean slate |
424 |
ifnull(d,cast('2000-01-01' as date)) as d, |
425 |
ifnull(e,cast('b' as char)) as e, |
|
426 |
ifnull(f,cast('2000-01-01' as datetime)) as f, |
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
427 |
ifnull(h,cast('yet another binary data' as binary)) as h |
1
by brian
clean slate |
428 |
from t1;
|
429 |
explain t2;
|
|
1309.4.3
by Brian Aker
Refactor DESC to use new table. |
430 |
Field Type Null Default Default_is_NULL On_Update
|
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
431 |
a INTEGER YES YES
|
432 |
b BIGINT NO NO
|
|
433 |
c BIGINT NO NO
|
|
434 |
d DATE YES YES
|
|
435 |
e VARCHAR YES YES
|
|
436 |
f DATETIME YES YES
|
|
437 |
h BLOB YES YES
|
|
1
by brian
clean slate |
438 |
select * from t2;
|
896.5.1
by Jay Pipes
Removes the TIME column type and related time functions. |
439 |
a b c d e f h
|
440 |
1 -7 7 2000-01-01 b 2000-01-01 00:00:00 yet another binary data
|
|
441 |
2 -2 2 1825-12-14 a 2003-01-01 03:02:01 binary data
|
|
1
by brian
clean slate |
442 |
drop table t1, t2;
|
722.2.15
by Monty Taylor
Fixed create.test. |
443 |
create table t1 (a int, b int, d int, e bigint, f float(3,2), g double(4,3), h decimal(5,4), j date, k timestamp, l datetime, m enum('a','b'), o char(10)); |
1996.2.1
by Brian Aker
uuid type code. |
444 |
SHOW CREATE TABLE t1;
|
445 |
Table Create Table
|
|
446 |
t1 CREATE TABLE `t1` (
|
|
447 |
`a` INT DEFAULT NULL,
|
|
448 |
`b` INT DEFAULT NULL,
|
|
449 |
`d` INT DEFAULT NULL,
|
|
450 |
`e` BIGINT DEFAULT NULL,
|
|
451 |
`f` DOUBLE(3,2) DEFAULT NULL,
|
|
452 |
`g` DOUBLE(4,3) DEFAULT NULL,
|
|
453 |
`h` DECIMAL(5,4) DEFAULT NULL,
|
|
454 |
`j` DATE DEFAULT NULL,
|
|
455 |
`k` TIMESTAMP NULL DEFAULT NULL,
|
|
456 |
`l` DATETIME DEFAULT NULL,
|
|
457 |
`m` ENUM('a','b') DEFAULT NULL, |
|
458 |
`o` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL
|
|
459 |
) ENGINE=InnoDB COLLATE = utf8_general_ci
|
|
722.2.15
by Monty Taylor
Fixed create.test. |
460 |
create table t2 select ifnull(a,a), ifnull(b,b), ifnull(d,d), ifnull(e,e), ifnull(f,f), ifnull(g,g), ifnull(h,h), ifnull(j,j), ifnull(k,k), ifnull(l,l), ifnull(m,m), ifnull(o,o) from t1;
|
1
by brian
clean slate |
461 |
show create table t2;
|
462 |
Table Create Table
|
|
463 |
t2 CREATE TABLE `t2` (
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
464 |
`ifnull(a,a)` INT DEFAULT NULL,
|
465 |
`ifnull(b,b)` INT DEFAULT NULL,
|
|
466 |
`ifnull(d,d)` INT DEFAULT NULL,
|
|
467 |
`ifnull(e,e)` BIGINT DEFAULT NULL,
|
|
468 |
`ifnull(f,f)` DOUBLE(3,2) DEFAULT NULL,
|
|
469 |
`ifnull(g,g)` DOUBLE(4,3) DEFAULT NULL,
|
|
470 |
`ifnull(h,h)` DECIMAL(5,4) DEFAULT NULL,
|
|
471 |
`ifnull(j,j)` DATE DEFAULT NULL,
|
|
472 |
`ifnull(k,k)` TIMESTAMP NULL DEFAULT NULL,
|
|
473 |
`ifnull(l,l)` DATETIME DEFAULT NULL,
|
|
474 |
`ifnull(m,m)` VARCHAR(1) COLLATE utf8_general_ci DEFAULT NULL,
|
|
475 |
`ifnull(o,o)` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL
|
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
476 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci
|
1
by brian
clean slate |
477 |
drop table t1,t2;
|
478 |
create table t1(str varchar(10) default 'def',strnull varchar(10),intg int default '10',rel double default '3.14'); |
|
479 |
insert into t1 values ('','',0,0.0);
|
|
480 |
describe t1;
|
|
1309.4.3
by Brian Aker
Refactor DESC to use new table. |
481 |
Field Type Null Default Default_is_NULL On_Update
|
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
482 |
str VARCHAR YES def NO
|
483 |
strnull VARCHAR YES YES
|
|
484 |
intg INTEGER YES 10 NO
|
|
485 |
rel DOUBLE YES 3.14 NO
|
|
1
by brian
clean slate |
486 |
create table t2 select default(str) as str, default(strnull) as strnull, default(intg) as intg, default(rel) as rel from t1;
|
487 |
describe t2;
|
|
1309.4.3
by Brian Aker
Refactor DESC to use new table. |
488 |
Field Type Null Default Default_is_NULL On_Update
|
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
489 |
str VARCHAR YES YES
|
490 |
strnull VARCHAR YES YES
|
|
491 |
intg INTEGER YES YES
|
|
492 |
rel DOUBLE YES YES
|
|
1
by brian
clean slate |
493 |
drop table t1, t2;
|
722.2.15
by Monty Taylor
Fixed create.test. |
494 |
create table t1(name varchar(10), age int default -1);
|
1
by brian
clean slate |
495 |
describe t1;
|
1309.4.3
by Brian Aker
Refactor DESC to use new table. |
496 |
Field Type Null Default Default_is_NULL On_Update
|
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
497 |
name VARCHAR YES YES
|
498 |
age INTEGER YES -1 NO
|
|
722.2.15
by Monty Taylor
Fixed create.test. |
499 |
create table t2(name varchar(10), age int default - 1);
|
1
by brian
clean slate |
500 |
describe t2;
|
1309.4.3
by Brian Aker
Refactor DESC to use new table. |
501 |
Field Type Null Default Default_is_NULL On_Update
|
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
502 |
name VARCHAR YES YES
|
503 |
age INTEGER YES -1 NO
|
|
1
by brian
clean slate |
504 |
drop table t1, t2;
|
722.2.15
by Monty Taylor
Fixed create.test. |
505 |
create table t1(cenum enum('a')); |
506 |
create table t2(cenum enum('a','a')); |
|
507 |
ERROR HY000: Column 'cenum' has duplicated value 'a' in ENUM |
|
508 |
create table t3(cenum enum('a','A','a','c','c')); |
|
509 |
ERROR HY000: Column 'cenum' has duplicated value 'a' in ENUM |
|
510 |
drop table t1;
|
|
1
by brian
clean slate |
511 |
create database mysqltest;
|
512 |
use mysqltest;
|
|
513 |
select database();
|
|
514 |
database()
|
|
515 |
mysqltest
|
|
516 |
drop database mysqltest;
|
|
517 |
select database();
|
|
518 |
database()
|
|
519 |
NULL
|
|
520 |
use test;
|
|
521 |
CREATE TABLE t1(id varchar(10) NOT NULL PRIMARY KEY, dsc longtext);
|
|
522 |
INSERT INTO t1 VALUES ('5000000001', NULL),('5000000003', 'Test'),('5000000004', NULL); |
|
523 |
CREATE TABLE t2(id varchar(15) NOT NULL, proc varchar(100) NOT NULL, runID varchar(16) NOT NULL, start datetime NOT NULL, PRIMARY KEY (id,proc,runID,start));
|
|
524 |
INSERT INTO t2 VALUES ('5000000001', 'proc01', '20031029090650', '2003-10-29 13:38:40'),('5000000001', 'proc02', '20031029090650', '2003-10-29 13:38:51'),('5000000001', 'proc03', '20031029090650', '2003-10-29 13:38:11'),('5000000002', 'proc09', '20031024013310', '2003-10-24 01:33:11'),('5000000002', 'proc09', '20031024153537', '2003-10-24 15:36:04'),('5000000004', 'proc01', '20031024013641', '2003-10-24 01:37:29'),('5000000004', 'proc02', '20031024013641', '2003-10-24 01:37:39'); |
|
525 |
CREATE TABLE t3 SELECT t1.dsc,COUNT(DISTINCT t2.id) AS countOfRuns FROM t1 LEFT JOIN t2 ON (t1.id=t2.id) GROUP BY t1.id;
|
|
526 |
SELECT * FROM t3;
|
|
527 |
dsc countOfRuns
|
|
528 |
NULL 1
|
|
529 |
Test 0
|
|
530 |
NULL 1
|
|
531 |
drop table t1, t2, t3;
|
|
532 |
create table t1 (a int);
|
|
533 |
create table t1 select * from t1;
|
|
907.2.3
by Toru Maesaka
Updated the testcase and result file for bug:311046 fix |
534 |
ERROR HY000: You can't specify target table 't1' for update in FROM clause |
1
by brian
clean slate |
535 |
flush tables with read lock; |
536 |
unlock tables; |
|
537 |
drop table t1; |
|
538 |
create table t1(column.name int); |
|
539 |
ERROR 42000: Incorrect table name 'column' |
|
540 |
create table t1(test.column.name int); |
|
541 |
ERROR 42000: Incorrect table name 'column' |
|
542 |
create table t1(xyz.t1.name int); |
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
543 |
ERROR 42000: Incorrect schema name 'xyz' |
1
by brian
clean slate |
544 |
create table t1(t1.name int); |
545 |
create table t2(test.t2.name int); |
|
546 |
drop table t1,t2; |
|
722.2.15
by Monty Taylor
Fixed create.test. |
547 |
CREATE TABLE t1 (f1 VARCHAR(255)); |
1
by brian
clean slate |
548 |
CREATE TABLE t2 AS SELECT LEFT(f1,171) AS f2 FROM t1 UNION SELECT LEFT(f1,171) AS f2 FROM t1; |
549 |
DESC t2; |
|
1309.4.3
by Brian Aker
Refactor DESC to use new table. |
550 |
Field Type Null Default Default_is_NULL On_Update |
1660
by Brian Aker
MErge in change to do YES/NO like standard requires. |
551 |
f2 VARCHAR YES YES |
1
by brian
clean slate |
552 |
DROP TABLE t1,t2; |
553 |
CREATE TABLE t12913 (f1 ENUM ('a','b')) AS SELECT 'a' AS f1; |
|
554 |
SELECT * FROM t12913; |
|
555 |
f1
|
|
556 |
a
|
|
557 |
DROP TABLE t12913; |
|
558 |
create database mysqltest; |
|
559 |
use mysqltest; |
|
560 |
drop database mysqltest; |
|
561 |
create table test.t1 like x; |
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
562 |
ERROR 3D000: No schema selected |
1
by brian
clean slate |
563 |
drop table if exists test.t1; |
564 |
create database mysqltest; |
|
722.2.15
by Monty Taylor
Fixed create.test. |
565 |
create database if not exists mysqltest; |
1
by brian
clean slate |
566 |
Warnings: |
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
567 |
Note 1007 Can't create schema 'mysqltest'; schema exists |
1
by brian
clean slate |
568 |
show create database mysqltest;
|
569 |
Database Create Database
|
|
1273.19.28
by Brian Aker
More cleanup on ALTER SCHEMA. Hey! MySQL never had errors on half of it... |
570 |
mysqltest CREATE DATABASE `mysqltest` COLLATE = utf8_general_ci
|
1
by brian
clean slate |
571 |
drop database mysqltest;
|
572 |
use test;
|
|
573 |
create table t1 (a int);
|
|
574 |
create table if not exists t1 (a int);
|
|
575 |
Warnings:
|
|
576 |
Note 1050 Table 't1' already exists |
|
577 |
drop table t1;
|
|
578 |
create table t1 (
|
|
722.2.15
by Monty Taylor
Fixed create.test. |
579 |
a varchar(112) collate utf8_bin not null,
|
1
by brian
clean slate |
580 |
primary key (a)
|
581 |
) select 'test' as a ; |
|
582 |
show create table t1;
|
|
583 |
Table Create Table
|
|
584 |
t1 CREATE TABLE `t1` (
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
585 |
`a` VARCHAR(112) COLLATE utf8_bin NOT NULL,
|
2363.1.5
by Brian Aker
This patch fixes 798940, we will also just now add the type of index to our create statements. |
586 |
PRIMARY KEY (`a`) USING BTREE
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
587 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci
|
1
by brian
clean slate |
588 |
drop table t1;
|
589 |
CREATE TABLE t2 (
|
|
722.2.15
by Monty Taylor
Fixed create.test. |
590 |
a int default NULL
|
1
by brian
clean slate |
591 |
);
|
592 |
insert into t2 values(111);
|
|
593 |
create table t1 (
|
|
722.2.15
by Monty Taylor
Fixed create.test. |
594 |
a varchar(12) collate utf8_bin not null,
|
1
by brian
clean slate |
595 |
b int not null, primary key (a)
|
596 |
) select a, 1 as b from t2 ;
|
|
597 |
show create table t1;
|
|
598 |
Table Create Table
|
|
599 |
t1 CREATE TABLE `t1` (
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
600 |
`a` VARCHAR(12) COLLATE utf8_bin NOT NULL,
|
601 |
`b` INT NOT NULL,
|
|
2363.1.5
by Brian Aker
This patch fixes 798940, we will also just now add the type of index to our create statements. |
602 |
PRIMARY KEY (`a`) USING BTREE
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
603 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci
|
1
by brian
clean slate |
604 |
drop table t1;
|
605 |
create table t1 (
|
|
722.2.15
by Monty Taylor
Fixed create.test. |
606 |
a varchar(12) collate utf8_bin not null,
|
1
by brian
clean slate |
607 |
b int not null, primary key (a)
|
608 |
) select a, 1 as c from t2 ;
|
|
722.2.15
by Monty Taylor
Fixed create.test. |
609 |
ERROR HY000: Field 'b' doesn't have a default value |
1
by brian
clean slate |
610 |
create table t1 ( |
722.2.15
by Monty Taylor
Fixed create.test. |
611 |
a varchar(12) collate utf8_bin not null, |
1
by brian
clean slate |
612 |
b int null, primary key (a) |
613 |
) select a, 1 as c from t2 ; |
|
614 |
show create table t1; |
|
615 |
Table Create Table |
|
616 |
t1 CREATE TABLE `t1` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
617 |
`b` INT DEFAULT NULL, |
618 |
`a` VARCHAR(12) COLLATE utf8_bin NOT NULL, |
|
619 |
`c` INT NOT NULL, |
|
2363.1.5
by Brian Aker
This patch fixes 798940, we will also just now add the type of index to our create statements. |
620 |
PRIMARY KEY (`a`) USING BTREE |
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
621 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci |
722.2.15
by Monty Taylor
Fixed create.test. |
622 |
drop table t1; |
623 |
create table t1 ( |
|
624 |
a varchar(12) collate utf8_bin not null, |
|
625 |
b int not null, primary key (a) |
|
626 |
) select 'a' as a , 1 as b from t2 ; |
|
627 |
show create table t1; |
|
628 |
Table Create Table |
|
629 |
t1 CREATE TABLE `t1` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
630 |
`a` VARCHAR(12) COLLATE utf8_bin NOT NULL, |
631 |
`b` INT NOT NULL, |
|
2363.1.5
by Brian Aker
This patch fixes 798940, we will also just now add the type of index to our create statements. |
632 |
PRIMARY KEY (`a`) USING BTREE |
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
633 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci |
722.2.15
by Monty Taylor
Fixed create.test. |
634 |
drop table t1; |
635 |
create table t1 ( |
|
636 |
a varchar(12) collate utf8_bin, |
|
637 |
b int not null, primary key (a) |
|
638 |
) select 'a' as a , 1 as b from t2 ; |
|
639 |
show create table t1; |
|
640 |
Table Create Table |
|
641 |
t1 CREATE TABLE `t1` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
642 |
`a` VARCHAR(12) COLLATE utf8_bin NOT NULL, |
643 |
`b` INT NOT NULL, |
|
2363.1.5
by Brian Aker
This patch fixes 798940, we will also just now add the type of index to our create statements. |
644 |
PRIMARY KEY (`a`) USING BTREE |
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
645 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci |
1
by brian
clean slate |
646 |
drop table t1, t2; |
647 |
create table t1 ( |
|
648 |
a1 int not null, |
|
649 |
a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int |
|
650 |
);
|
|
651 |
insert into t1 values (1,1,1, 1,1,1, 1,1,1); |
|
652 |
create table t2 ( |
|
722.2.15
by Monty Taylor
Fixed create.test. |
653 |
a1 varchar(12) collate utf8_bin not null, |
1
by brian
clean slate |
654 |
a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int, |
655 |
primary key (a1) |
|
656 |
) select a1,a2,a3,a4,a5,a6,a7,a8,a9 from t1 ; |
|
657 |
drop table t2; |
|
658 |
create table t2 ( |
|
722.2.15
by Monty Taylor
Fixed create.test. |
659 |
a1 varchar(12) collate utf8_bin, |
1
by brian
clean slate |
660 |
a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int |
661 |
) select a1,a2,a3,a4,a5,a6,a7,a8,a9 from t1; |
|
662 |
drop table t1, t2; |
|
663 |
create table t1 ( |
|
664 |
a1 int, a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int |
|
665 |
);
|
|
666 |
insert into t1 values (1,1,1, 1,1,1, 1,1,1); |
|
667 |
create table t2 ( |
|
722.2.15
by Monty Taylor
Fixed create.test. |
668 |
a1 varchar(12) collate utf8_bin not null, |
1
by brian
clean slate |
669 |
a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int, |
670 |
primary key (a1) |
|
671 |
) select a1,a2,a3,a4,a5,a6,a7,a8,a9 from t1 ; |
|
672 |
drop table t2; |
|
673 |
create table t2 ( a int default 3, b int default 3) |
|
674 |
select a1,a2 from t1; |
|
675 |
show create table t2; |
|
676 |
Table Create Table |
|
677 |
t2 CREATE TABLE `t2` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
678 |
`a` INT DEFAULT '3', |
679 |
`b` INT DEFAULT '3', |
|
680 |
`a1` INT DEFAULT NULL, |
|
681 |
`a2` INT DEFAULT NULL |
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
682 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci |
1
by brian
clean slate |
683 |
drop table t1, t2; |
684 |
create table t1 select * from t2; |
|
2140.1.3
by Brian Aker
Merge in error message fix for just one type of error for unknown table. |
685 |
ERROR 42S02: Unknown table 'test.t2' |
1
by brian
clean slate |
686 |
create table t1 select * from t1; |
687 |
ERROR HY000: You can't specify target table 't1' for update in FROM clause |
|
722.2.15
by Monty Taylor
Fixed create.test. |
688 |
create table t1 select coalesce('a' collate utf8_swedish_ci,'b' collate utf8_bin); |
689 |
ERROR HY000: Illegal mix of collations (utf8_swedish_ci,EXPLICIT) and (utf8_bin,EXPLICIT) for operation 'coalesce' |
|
1
by brian
clean slate |
690 |
create table t1 (primary key(a)) select "b" as b;
|
691 |
ERROR 42000: Key column 'a' doesn't exist in table |
|
692 |
create table t1 (primary key (a)) (select 1 as a) union all (select 1 as a); |
|
693 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY' |
|
694 |
create table t1 (i int); |
|
695 |
create table if not exists t1 select 1 as i; |
|
907.2.3
by Toru Maesaka
Updated the testcase and result file for bug:311046 fix |
696 |
Warnings: |
697 |
Note 1050 Table 't1' already exists |
|
722.2.15
by Monty Taylor
Fixed create.test. |
698 |
select * from t1; |
699 |
i
|
|
907.2.3
by Toru Maesaka
Updated the testcase and result file for bug:311046 fix |
700 |
1
|
1
by brian
clean slate |
701 |
drop table t1; |
722.2.15
by Monty Taylor
Fixed create.test. |
702 |
create table t1 select coalesce('a' collate utf8_swedish_ci,'b' collate utf8_bin); |
703 |
ERROR HY000: Illegal mix of collations (utf8_swedish_ci,EXPLICIT) and (utf8_bin,EXPLICIT) for operation 'coalesce' |
|
1
by brian
clean slate |
704 |
create temporary table t1 (j int); |
705 |
create table if not exists t1 select 1; |
|
706 |
Warnings: |
|
707 |
Note 1050 Table 't1' already exists |
|
708 |
select * from t1; |
|
709 |
j
|
|
710 |
1
|
|
711 |
drop temporary table t1; |
|
712 |
select * from t1; |
|
2140.1.3
by Brian Aker
Merge in error message fix for just one type of error for unknown table. |
713 |
ERROR 42S02: Unknown table 'test.t1' |
1
by brian
clean slate |
714 |
drop table t1; |
715 |
ERROR 42S02: Unknown table 't1' |
|
716 |
create table t1 (upgrade int); |
|
717 |
drop table t1; |
|
718 |
create table t1 ( |
|
719 |
c1 int, c2 int, c3 int, c4 int, c5 int, c6 int, c7 int, c8 int, |
|
720 |
c9 int, c10 int, c11 int, c12 int, c13 int, c14 int, c15 int, c16 int, |
|
721 |
key a001_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
722 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
723 |
key a002_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
724 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
725 |
key a003_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
726 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
727 |
key a004_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
728 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
729 |
key a005_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
730 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
731 |
key a006_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
732 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
733 |
key a007_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
734 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
735 |
key a008_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
736 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
737 |
key a009_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
738 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
739 |
key a010_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
740 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
741 |
key a011_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
742 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
743 |
key a012_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
744 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
745 |
key a013_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
746 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
747 |
key a014_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
748 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
749 |
key a015_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
750 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
751 |
key a016_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
752 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
753 |
key a017_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
754 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
755 |
key a018_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
756 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
757 |
key a019_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
758 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
759 |
key a020_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
760 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
761 |
key a021_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
762 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
763 |
key a022_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
764 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
765 |
key a023_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
766 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
767 |
key a024_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
768 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
769 |
key a025_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
770 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
771 |
key a026_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
772 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
773 |
key a027_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
774 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
775 |
key a028_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
776 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
777 |
key a029_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
778 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
779 |
key a030_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
780 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
781 |
key a031_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
782 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
783 |
key a032_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
784 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
785 |
key a033_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
786 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
787 |
key a034_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
788 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
789 |
key a035_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
790 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
791 |
key a036_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
792 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
793 |
key a037_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
794 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
795 |
key a038_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
796 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
797 |
key a039_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
798 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
799 |
key a040_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
800 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
801 |
key a041_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
802 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
803 |
key a042_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
804 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
805 |
key a043_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
806 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
807 |
key a044_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
808 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
809 |
key a045_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
810 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
811 |
key a046_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
812 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
813 |
key a047_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
814 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
815 |
key a048_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
816 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
817 |
key a049_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
818 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
819 |
key a050_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
820 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
821 |
key a051_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
822 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
823 |
key a052_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
824 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
825 |
key a053_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
826 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
827 |
key a054_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
828 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
829 |
key a055_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
830 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
831 |
key a056_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
832 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
833 |
key a057_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
834 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
835 |
key a058_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
836 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
837 |
key a059_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
838 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
839 |
key a060_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
840 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
841 |
key a061_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
842 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
843 |
key a062_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
844 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
845 |
key a063_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
846 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
847 |
key a064_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
848 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16) |
|
849 |
);
|
|
850 |
show create table t1; |
|
851 |
Table Create Table |
|
852 |
t1 CREATE TABLE `t1` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
853 |
`c1` INT DEFAULT NULL, |
854 |
`c2` INT DEFAULT NULL, |
|
855 |
`c3` INT DEFAULT NULL, |
|
856 |
`c4` INT DEFAULT NULL, |
|
857 |
`c5` INT DEFAULT NULL, |
|
858 |
`c6` INT DEFAULT NULL, |
|
859 |
`c7` INT DEFAULT NULL, |
|
860 |
`c8` INT DEFAULT NULL, |
|
861 |
`c9` INT DEFAULT NULL, |
|
862 |
`c10` INT DEFAULT NULL, |
|
863 |
`c11` INT DEFAULT NULL, |
|
864 |
`c12` INT DEFAULT NULL, |
|
865 |
`c13` INT DEFAULT NULL, |
|
866 |
`c14` INT DEFAULT NULL, |
|
867 |
`c15` INT DEFAULT NULL, |
|
868 |
`c16` INT DEFAULT NULL, |
|
2363.1.5
by Brian Aker
This patch fixes 798940, we will also just now add the type of index to our create statements. |
869 |
KEY `a001_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
870 |
KEY `a002_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
871 |
KEY `a003_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
872 |
KEY `a004_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
873 |
KEY `a005_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
874 |
KEY `a006_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
875 |
KEY `a007_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
876 |
KEY `a008_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
877 |
KEY `a009_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
878 |
KEY `a010_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
879 |
KEY `a011_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
880 |
KEY `a012_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
881 |
KEY `a013_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
882 |
KEY `a014_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
883 |
KEY `a015_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
884 |
KEY `a016_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
885 |
KEY `a017_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
886 |
KEY `a018_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
887 |
KEY `a019_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
888 |
KEY `a020_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
889 |
KEY `a021_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
890 |
KEY `a022_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
891 |
KEY `a023_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
892 |
KEY `a024_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
893 |
KEY `a025_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
894 |
KEY `a026_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
895 |
KEY `a027_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
896 |
KEY `a028_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
897 |
KEY `a029_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
898 |
KEY `a030_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
899 |
KEY `a031_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
900 |
KEY `a032_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
901 |
KEY `a033_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
902 |
KEY `a034_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
903 |
KEY `a035_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
904 |
KEY `a036_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
905 |
KEY `a037_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
906 |
KEY `a038_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
907 |
KEY `a039_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
908 |
KEY `a040_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
909 |
KEY `a041_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
910 |
KEY `a042_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
911 |
KEY `a043_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
912 |
KEY `a044_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
913 |
KEY `a045_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
914 |
KEY `a046_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
915 |
KEY `a047_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
916 |
KEY `a048_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
917 |
KEY `a049_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
918 |
KEY `a050_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
919 |
KEY `a051_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
920 |
KEY `a052_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
921 |
KEY `a053_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
922 |
KEY `a054_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
923 |
KEY `a055_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
924 |
KEY `a056_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
925 |
KEY `a057_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
926 |
KEY `a058_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
927 |
KEY `a059_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
928 |
KEY `a060_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
929 |
KEY `a061_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
930 |
KEY `a062_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
931 |
KEY `a063_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
932 |
KEY `a064_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE |
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
933 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci |
1
by brian
clean slate |
934 |
flush tables; |
935 |
show create table t1; |
|
936 |
Table Create Table |
|
937 |
t1 CREATE TABLE `t1` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
938 |
`c1` INT DEFAULT NULL, |
939 |
`c2` INT DEFAULT NULL, |
|
940 |
`c3` INT DEFAULT NULL, |
|
941 |
`c4` INT DEFAULT NULL, |
|
942 |
`c5` INT DEFAULT NULL, |
|
943 |
`c6` INT DEFAULT NULL, |
|
944 |
`c7` INT DEFAULT NULL, |
|
945 |
`c8` INT DEFAULT NULL, |
|
946 |
`c9` INT DEFAULT NULL, |
|
947 |
`c10` INT DEFAULT NULL, |
|
948 |
`c11` INT DEFAULT NULL, |
|
949 |
`c12` INT DEFAULT NULL, |
|
950 |
`c13` INT DEFAULT NULL, |
|
951 |
`c14` INT DEFAULT NULL, |
|
952 |
`c15` INT DEFAULT NULL, |
|
953 |
`c16` INT DEFAULT NULL, |
|
2363.1.5
by Brian Aker
This patch fixes 798940, we will also just now add the type of index to our create statements. |
954 |
KEY `a001_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
955 |
KEY `a002_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
956 |
KEY `a003_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
957 |
KEY `a004_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
958 |
KEY `a005_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
959 |
KEY `a006_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
960 |
KEY `a007_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
961 |
KEY `a008_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
962 |
KEY `a009_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
963 |
KEY `a010_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
964 |
KEY `a011_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
965 |
KEY `a012_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
966 |
KEY `a013_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
967 |
KEY `a014_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
968 |
KEY `a015_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
969 |
KEY `a016_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
970 |
KEY `a017_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
971 |
KEY `a018_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
972 |
KEY `a019_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
973 |
KEY `a020_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
974 |
KEY `a021_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
975 |
KEY `a022_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
976 |
KEY `a023_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
977 |
KEY `a024_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
978 |
KEY `a025_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
979 |
KEY `a026_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
980 |
KEY `a027_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
981 |
KEY `a028_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
982 |
KEY `a029_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
983 |
KEY `a030_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
984 |
KEY `a031_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
985 |
KEY `a032_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
986 |
KEY `a033_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
987 |
KEY `a034_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
988 |
KEY `a035_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
989 |
KEY `a036_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
990 |
KEY `a037_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
991 |
KEY `a038_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
992 |
KEY `a039_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
993 |
KEY `a040_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
994 |
KEY `a041_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
995 |
KEY `a042_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
996 |
KEY `a043_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
997 |
KEY `a044_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
998 |
KEY `a045_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
999 |
KEY `a046_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1000 |
KEY `a047_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1001 |
KEY `a048_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1002 |
KEY `a049_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1003 |
KEY `a050_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1004 |
KEY `a051_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1005 |
KEY `a052_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1006 |
KEY `a053_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1007 |
KEY `a054_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1008 |
KEY `a055_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1009 |
KEY `a056_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1010 |
KEY `a057_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1011 |
KEY `a058_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1012 |
KEY `a059_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1013 |
KEY `a060_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1014 |
KEY `a061_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1015 |
KEY `a062_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1016 |
KEY `a063_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1017 |
KEY `a064_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE |
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
1018 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci |
1
by brian
clean slate |
1019 |
drop table t1; |
1020 |
create table t1 (c1 int, c2 int, c3 int, c4 int, c5 int, c6 int, c7 int, |
|
1021 |
c8 int, c9 int, c10 int, c11 int, c12 int, c13 int, c14 int, c15 int, c16 int); |
|
1022 |
alter table t1 |
|
1023 |
add key a001_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1024 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1025 |
add key a002_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1026 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1027 |
add key a003_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1028 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1029 |
add key a004_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1030 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1031 |
add key a005_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1032 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1033 |
add key a006_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1034 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1035 |
add key a007_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1036 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1037 |
add key a008_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1038 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1039 |
add key a009_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1040 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1041 |
add key a010_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1042 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1043 |
add key a011_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1044 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1045 |
add key a012_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1046 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1047 |
add key a013_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1048 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1049 |
add key a014_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1050 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1051 |
add key a015_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1052 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1053 |
add key a016_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1054 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1055 |
add key a017_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1056 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1057 |
add key a018_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1058 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1059 |
add key a019_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1060 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1061 |
add key a020_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1062 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1063 |
add key a021_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1064 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1065 |
add key a022_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1066 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1067 |
add key a023_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1068 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1069 |
add key a024_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1070 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1071 |
add key a025_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1072 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1073 |
add key a026_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1074 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1075 |
add key a027_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1076 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1077 |
add key a028_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1078 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1079 |
add key a029_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1080 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1081 |
add key a030_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1082 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1083 |
add key a031_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1084 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1085 |
add key a032_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1086 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1087 |
add key a033_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1088 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1089 |
add key a034_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1090 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1091 |
add key a035_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1092 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1093 |
add key a036_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1094 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1095 |
add key a037_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1096 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1097 |
add key a038_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1098 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1099 |
add key a039_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1100 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1101 |
add key a040_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1102 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1103 |
add key a041_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1104 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1105 |
add key a042_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1106 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1107 |
add key a043_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1108 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1109 |
add key a044_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1110 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1111 |
add key a045_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1112 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1113 |
add key a046_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1114 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1115 |
add key a047_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1116 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1117 |
add key a048_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1118 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1119 |
add key a049_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1120 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1121 |
add key a050_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1122 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1123 |
add key a051_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1124 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1125 |
add key a052_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1126 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1127 |
add key a053_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1128 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1129 |
add key a054_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1130 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1131 |
add key a055_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1132 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1133 |
add key a056_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1134 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1135 |
add key a057_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1136 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1137 |
add key a058_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1138 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1139 |
add key a059_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1140 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1141 |
add key a060_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1142 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1143 |
add key a061_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1144 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1145 |
add key a062_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1146 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1147 |
add key a063_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1148 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16), |
|
1149 |
add key a064_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1150 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16); |
|
1151 |
show create table t1; |
|
1152 |
Table Create Table |
|
1153 |
t1 CREATE TABLE `t1` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
1154 |
`c1` INT DEFAULT NULL, |
1155 |
`c2` INT DEFAULT NULL, |
|
1156 |
`c3` INT DEFAULT NULL, |
|
1157 |
`c4` INT DEFAULT NULL, |
|
1158 |
`c5` INT DEFAULT NULL, |
|
1159 |
`c6` INT DEFAULT NULL, |
|
1160 |
`c7` INT DEFAULT NULL, |
|
1161 |
`c8` INT DEFAULT NULL, |
|
1162 |
`c9` INT DEFAULT NULL, |
|
1163 |
`c10` INT DEFAULT NULL, |
|
1164 |
`c11` INT DEFAULT NULL, |
|
1165 |
`c12` INT DEFAULT NULL, |
|
1166 |
`c13` INT DEFAULT NULL, |
|
1167 |
`c14` INT DEFAULT NULL, |
|
1168 |
`c15` INT DEFAULT NULL, |
|
1169 |
`c16` INT DEFAULT NULL, |
|
2363.1.5
by Brian Aker
This patch fixes 798940, we will also just now add the type of index to our create statements. |
1170 |
KEY `a001_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
1171 |
KEY `a002_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1172 |
KEY `a003_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1173 |
KEY `a004_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1174 |
KEY `a005_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1175 |
KEY `a006_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1176 |
KEY `a007_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1177 |
KEY `a008_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1178 |
KEY `a009_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1179 |
KEY `a010_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1180 |
KEY `a011_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1181 |
KEY `a012_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1182 |
KEY `a013_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1183 |
KEY `a014_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1184 |
KEY `a015_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1185 |
KEY `a016_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1186 |
KEY `a017_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1187 |
KEY `a018_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1188 |
KEY `a019_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1189 |
KEY `a020_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1190 |
KEY `a021_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1191 |
KEY `a022_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1192 |
KEY `a023_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1193 |
KEY `a024_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1194 |
KEY `a025_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1195 |
KEY `a026_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1196 |
KEY `a027_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1197 |
KEY `a028_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1198 |
KEY `a029_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1199 |
KEY `a030_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1200 |
KEY `a031_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1201 |
KEY `a032_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1202 |
KEY `a033_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1203 |
KEY `a034_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1204 |
KEY `a035_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1205 |
KEY `a036_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1206 |
KEY `a037_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1207 |
KEY `a038_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1208 |
KEY `a039_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1209 |
KEY `a040_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1210 |
KEY `a041_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1211 |
KEY `a042_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1212 |
KEY `a043_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1213 |
KEY `a044_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1214 |
KEY `a045_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1215 |
KEY `a046_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1216 |
KEY `a047_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1217 |
KEY `a048_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1218 |
KEY `a049_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1219 |
KEY `a050_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1220 |
KEY `a051_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1221 |
KEY `a052_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1222 |
KEY `a053_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1223 |
KEY `a054_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1224 |
KEY `a055_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1225 |
KEY `a056_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1226 |
KEY `a057_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1227 |
KEY `a058_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1228 |
KEY `a059_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1229 |
KEY `a060_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1230 |
KEY `a061_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1231 |
KEY `a062_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1232 |
KEY `a063_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1233 |
KEY `a064_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE |
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
1234 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci |
1
by brian
clean slate |
1235 |
flush tables; |
1236 |
show create table t1; |
|
1237 |
Table Create Table |
|
1238 |
t1 CREATE TABLE `t1` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
1239 |
`c1` INT DEFAULT NULL, |
1240 |
`c2` INT DEFAULT NULL, |
|
1241 |
`c3` INT DEFAULT NULL, |
|
1242 |
`c4` INT DEFAULT NULL, |
|
1243 |
`c5` INT DEFAULT NULL, |
|
1244 |
`c6` INT DEFAULT NULL, |
|
1245 |
`c7` INT DEFAULT NULL, |
|
1246 |
`c8` INT DEFAULT NULL, |
|
1247 |
`c9` INT DEFAULT NULL, |
|
1248 |
`c10` INT DEFAULT NULL, |
|
1249 |
`c11` INT DEFAULT NULL, |
|
1250 |
`c12` INT DEFAULT NULL, |
|
1251 |
`c13` INT DEFAULT NULL, |
|
1252 |
`c14` INT DEFAULT NULL, |
|
1253 |
`c15` INT DEFAULT NULL, |
|
1254 |
`c16` INT DEFAULT NULL, |
|
2363.1.5
by Brian Aker
This patch fixes 798940, we will also just now add the type of index to our create statements. |
1255 |
KEY `a001_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
1256 |
KEY `a002_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1257 |
KEY `a003_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1258 |
KEY `a004_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1259 |
KEY `a005_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1260 |
KEY `a006_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1261 |
KEY `a007_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1262 |
KEY `a008_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1263 |
KEY `a009_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1264 |
KEY `a010_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1265 |
KEY `a011_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1266 |
KEY `a012_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1267 |
KEY `a013_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1268 |
KEY `a014_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1269 |
KEY `a015_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1270 |
KEY `a016_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1271 |
KEY `a017_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1272 |
KEY `a018_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1273 |
KEY `a019_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1274 |
KEY `a020_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1275 |
KEY `a021_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1276 |
KEY `a022_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1277 |
KEY `a023_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1278 |
KEY `a024_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1279 |
KEY `a025_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1280 |
KEY `a026_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1281 |
KEY `a027_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1282 |
KEY `a028_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1283 |
KEY `a029_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1284 |
KEY `a030_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1285 |
KEY `a031_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1286 |
KEY `a032_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1287 |
KEY `a033_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1288 |
KEY `a034_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1289 |
KEY `a035_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1290 |
KEY `a036_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1291 |
KEY `a037_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1292 |
KEY `a038_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1293 |
KEY `a039_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1294 |
KEY `a040_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1295 |
KEY `a041_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1296 |
KEY `a042_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1297 |
KEY `a043_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1298 |
KEY `a044_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1299 |
KEY `a045_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1300 |
KEY `a046_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1301 |
KEY `a047_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1302 |
KEY `a048_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1303 |
KEY `a049_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1304 |
KEY `a050_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1305 |
KEY `a051_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1306 |
KEY `a052_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1307 |
KEY `a053_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1308 |
KEY `a054_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1309 |
KEY `a055_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1310 |
KEY `a056_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1311 |
KEY `a057_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1312 |
KEY `a058_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1313 |
KEY `a059_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1314 |
KEY `a060_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1315 |
KEY `a061_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1316 |
KEY `a062_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1317 |
KEY `a063_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE, |
|
1318 |
KEY `a064_long_123456789_123456789_123456789_123456789_123456789_1234` (`c1`,`c2`,`c3`,`c4`,`c5`,`c6`,`c7`,`c8`,`c9`,`c10`,`c11`,`c12`,`c13`,`c14`,`c15`,`c16`) USING BTREE |
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
1319 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci |
1
by brian
clean slate |
1320 |
alter table t1 add key |
1321 |
a065_long_123456789_123456789_123456789_123456789_123456789_1234 ( |
|
1322 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16); |
|
1323 |
ERROR 42000: Too many keys specified; max 64 keys allowed |
|
1324 |
drop table t1; |
|
1325 |
create table t1 (c1 int, c2 int, c3 int, c4 int, c5 int, c6 int, c7 int, |
|
1326 |
c8 int, c9 int, c10 int, c11 int, c12 int, c13 int, c14 int, c15 int, |
|
1327 |
c16 int, c17 int); |
|
1328 |
alter table t1 add key i1 ( |
|
1329 |
c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16, c17); |
|
1330 |
ERROR 42000: Too many key parts specified; max 16 parts allowed |
|
1331 |
alter table t1 add key |
|
1332 |
a001_long_123456789_123456789_123456789_123456789_123456789_12345 (c1); |
|
1333 |
ERROR 42000: Identifier name 'a001_long_123456789_123456789_123456789_123456789_123456789_12345' is too long |
|
1334 |
show create table t1; |
|
1335 |
Table Create Table |
|
1336 |
t1 CREATE TABLE `t1` ( |
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
1337 |
`c1` INT DEFAULT NULL, |
1338 |
`c2` INT DEFAULT NULL, |
|
1339 |
`c3` INT DEFAULT NULL, |
|
1340 |
`c4` INT DEFAULT NULL, |
|
1341 |
`c5` INT DEFAULT NULL, |
|
1342 |
`c6` INT DEFAULT NULL, |
|
1343 |
`c7` INT DEFAULT NULL, |
|
1344 |
`c8` INT DEFAULT NULL, |
|
1345 |
`c9` INT DEFAULT NULL, |
|
1346 |
`c10` INT DEFAULT NULL, |
|
1347 |
`c11` INT DEFAULT NULL, |
|
1348 |
`c12` INT DEFAULT NULL, |
|
1349 |
`c13` INT DEFAULT NULL, |
|
1350 |
`c14` INT DEFAULT NULL, |
|
1351 |
`c15` INT DEFAULT NULL, |
|
1352 |
`c16` INT DEFAULT NULL, |
|
1353 |
`c17` INT DEFAULT NULL |
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
1354 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci |
1
by brian
clean slate |
1355 |
drop table t1; |
1356 |
||
1357 |
Bug #26104 Bug on foreign key class constructor |
|
1358 |
||
1359 |
Check that ref_columns is initalized correctly in the constructor |
|
1360 |
and semantic checks in mysql_prepare_table work. |
|
1361 |
||
1362 |
We do not need a storage engine that supports foreign keys |
|
1363 |
for this test, as the checks are purely syntax-based, and the |
|
1364 |
syntax is supported for all engines. |
|
1365 |
||
1366 |
drop table if exists t1,t2; |
|
1367 |
create table t1(a int not null, b int not null, primary key (a, b)); |
|
1368 |
create table t2(a int not null, b int not null, c int not null, primary key (a), |
|
1369 |
foreign key fk_bug26104 (b,c) references t1(a)); |
|
1370 |
ERROR 42000: Incorrect foreign key definition for 'fk_bug26104': Key reference and table reference don't match |
|
1371 |
drop table t1;
|
|
1372 |
create table t1(f1 int,f2 int);
|
|
1373 |
insert into t1 value(1,1),(1,2),(1,3),(2,1),(2,2),(2,3);
|
|
1374 |
flush status;
|
|
1375 |
create table t2 select sql_big_result f1,count(f2) from t1 group by f1;
|
|
1376 |
show status like 'handler_read%'; |
|
1377 |
Variable_name Value
|
|
722.2.15
by Monty Taylor
Fixed create.test. |
1378 |
Handler_read_first 1
|
1379 |
Handler_read_key 3
|
|
1
by brian
clean slate |
1380 |
Handler_read_next 0
|
1381 |
Handler_read_prev 0
|
|
1382 |
Handler_read_rnd 0
|
|
1561.3.11
by Joe Daly
get tests working |
1383 |
Handler_read_rnd_next 7
|
1
by brian
clean slate |
1384 |
drop table t1,t2;
|
1385 |
CREATE TABLE t1(c1 VARCHAR(33), KEY USING BTREE (c1));
|
|
1386 |
DROP TABLE t1;
|
|
1387 |
CREATE TABLE t1(c1 VARCHAR(33), KEY (c1) USING BTREE);
|
|
1388 |
DROP TABLE t1;
|
|
1106.3.1
by Brian Aker
Heap is now tmp only table |
1389 |
CREATE TEMPORARY TABLE t1(c1 VARCHAR(33), KEY USING BTREE (c1) USING HASH) ENGINE=MEMORY;
|
1
by brian
clean slate |
1390 |
DROP TABLE t1;
|
1106.3.1
by Brian Aker
Heap is now tmp only table |
1391 |
CREATE TEMPORARY TABLE t1(c1 VARCHAR(33), KEY USING HASH (c1) USING BTREE) ENGINE=MEMORY;
|
1
by brian
clean slate |
1392 |
DROP TABLE t1;
|
1393 |
End of 5.0 tests
|
|
1394 |
CREATE TABLE t1 (a int, b int);
|
|
1395 |
insert into t1 values (1,1),(1,2);
|
|
1396 |
CREATE TABLE t2 (primary key (a)) select * from t1;
|
|
1397 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY' |
|
1398 |
drop table if exists t2;
|
|
1399 |
Warnings:
|
|
1400 |
Note 1051 Unknown table 't2' |
|
1401 |
CREATE TEMPORARY TABLE t2 (primary key (a)) select * from t1;
|
|
1402 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY' |
|
1403 |
drop table if exists t2;
|
|
1404 |
Warnings:
|
|
1405 |
Note 1051 Unknown table 't2' |
|
1406 |
CREATE TEMPORARY TABLE t2 (a int, b int, primary key (a));
|
|
1407 |
CREATE TEMPORARY TABLE IF NOT EXISTS t2 (primary key (a)) select * from t1;
|
|
1408 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY' |
|
1409 |
SELECT * from t2;
|
|
1410 |
a b
|
|
1411 |
TRUNCATE table t2;
|
|
1412 |
INSERT INTO t2 select * from t1;
|
|
1413 |
ERROR 23000: Duplicate entry '1' for key 'PRIMARY' |
|
1414 |
SELECT * from t2;
|
|
1415 |
a b
|
|
1416 |
drop table t1,t2;
|
|
1417 |
CREATE DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
|
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
1418 |
ERROR 42000: Incorrect schema name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' |
1
by brian
clean slate |
1419 |
DROP DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
1420 |
ERROR 42000: Incorrect schema name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' |
1
by brian
clean slate |
1421 |
USE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
|
1843.7.6
by Brian Aker
This cleans up error messages to state "schema" instead of database. |
1422 |
ERROR 42000: Incorrect schema name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' |
1
by brian
clean slate |
1423 |
SHOW CREATE DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
|
1812.5.9
by Brian Aker
First pass on moving show create schema out. |
1424 |
Database Create Database
|
1309.1.4
by Brian Aker
Re-enabling test for OSX. |
1425 |
create database имя_базы_в_кодировке_утф8_длиной_больше_чем_45;
|
1426 |
use имя_базы_в_кодировке_утф8_длиной_больше_чем_45;
|
|
1427 |
select database();
|
|
1428 |
database()
|
|
1429 |
имя_базы_в_кодировке_утф8_длиной_больше_чем_45
|
|
1430 |
use test;
|
|
1431 |
select SCHEMA_NAME from data_dictionary.schemas
|
|
1432 |
where schema_name='имя_базы_в_кодировке_утф8_длиной_больше_чем_45'; |
|
1433 |
SCHEMA_NAME
|
|
1434 |
имя_базы_в_кодировке_утф8_длиной_больше_чем_45
|
|
1435 |
drop database имя_базы_в_кодировке_утф8_длиной_больше_чем_45;
|
|
1436 |
create table имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48
|
|
1437 |
(
|
|
1438 |
имя_поля_в_кодировке_утф8_длиной_больше_чем_45 int,
|
|
1439 |
index имя_индекса_в_кодировке_утф8_длиной_больше_чем_48 (имя_поля_в_кодировке_утф8_длиной_больше_чем_45)
|
|
1440 |
);
|
|
1441 |
select * from имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48;
|
|
1442 |
имя_поля_в_кодировке_утф8_длиной_больше_чем_45
|
|
1443 |
select TABLE_NAME from data_dictionary.tables where
|
|
1444 |
table_schema='test'; |
|
1445 |
TABLE_NAME
|
|
1446 |
имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48
|
|
1447 |
select COLUMN_NAME from data_dictionary.columns where
|
|
1448 |
table_schema='test'; |
|
1449 |
COLUMN_NAME
|
|
1450 |
имя_поля_в_кодировке_утф8_длиной_больше_чем_45
|
|
1451 |
select INDEX_NAME from data_dictionary.indexes where
|
|
1452 |
table_schema='test'; |
|
1453 |
INDEX_NAME
|
|
1454 |
имя_индекса_в_кодировке_утф8_длиной_больше_чем_48
|
|
1455 |
show create table имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48;
|
|
1456 |
Table Create Table
|
|
1457 |
имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48 CREATE TABLE `имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48` (
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
1458 |
`имя_поля_в_кодировке_утф8_длиной_больше_чем_45` INT DEFAULT NULL,
|
2363.1.5
by Brian Aker
This patch fixes 798940, we will also just now add the type of index to our create statements. |
1459 |
KEY `имя_индекса_в_кодировке_утф8_длиной_больше_чем_48` (`имя_поля_в_кодировке_утф8_длиной_больше_чем_45`) USING BTREE
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
1460 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci
|
1309.1.4
by Brian Aker
Re-enabling test for OSX. |
1461 |
drop table имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48;
|
1273.13.35
by Brian Aker
Remove processlist from old I_S. |
1462 |
create table t1 like data_dictionary.processlist;
|
2068.7.1
by Brian Aker
First pass through error correction in SE interface for drop table. |
1463 |
Got one of the listed errors
|
1273.13.35
by Brian Aker
Remove processlist from old I_S. |
1464 |
create table t1 like data_dictionary.processlist engine=innodb;
|
1
by brian
clean slate |
1465 |
show create table t1;
|
1466 |
Table Create Table
|
|
1467 |
t1 CREATE TABLE `t1` (
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
1468 |
`ID` BIGINT NOT NULL,
|
2029.1.26
by Brian Aker
Merge in work for reserved words in SQL standard. |
1469 |
`USERNAME` VARCHAR(16) NOT NULL,
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
1470 |
`HOST` VARCHAR(1025) NOT NULL,
|
1993.3.2
by Andrew Hutchings
More test case fixes |
1471 |
`DB` VARCHAR(256) DEFAULT NULL,
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
1472 |
`COMMAND` VARCHAR(16) NOT NULL,
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
1473 |
`TIME` BIGINT UNSIGNED NOT NULL,
|
1726.3.8
by Andrew Hutchings
Fix tests |
1474 |
`STATE` VARCHAR(256) DEFAULT NULL,
|
1948.2.7
by Brian Aker
Adding "HAS_GLOBAL_LOCK" to processlist. |
1475 |
`INFO` VARCHAR(100) DEFAULT NULL,
|
2023.2.3
by Brian Aker
Merge in fixes for DD to make use of BOOLEAN as a type. |
1476 |
`HAS_GLOBAL_LOCK` BOOLEAN NOT NULL
|
2293.2.1
by Joseph Daly
modify parser to work for DEFINER |
1477 |
) ENGINE=InnoDB COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER 'SYSTEM' |
1
by brian
clean slate |
1478 |
drop table t1;
|
1273.13.35
by Brian Aker
Remove processlist from old I_S. |
1479 |
create temporary table t1 like data_dictionary.processlist;
|
2068.7.1
by Brian Aker
First pass through error correction in SE interface for drop table. |
1480 |
Got one of the listed errors
|
1273.13.35
by Brian Aker
Remove processlist from old I_S. |
1481 |
create temporary table t1 like data_dictionary.processlist engine=myisam;
|
1
by brian
clean slate |
1482 |
show create table t1;
|
1483 |
Table Create Table
|
|
1484 |
t1 CREATE TEMPORARY TABLE `t1` (
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
1485 |
`ID` BIGINT NOT NULL,
|
2029.1.26
by Brian Aker
Merge in work for reserved words in SQL standard. |
1486 |
`USERNAME` VARCHAR(16) NOT NULL,
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
1487 |
`HOST` VARCHAR(1025) NOT NULL,
|
1993.3.2
by Andrew Hutchings
More test case fixes |
1488 |
`DB` VARCHAR(256) DEFAULT NULL,
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
1489 |
`COMMAND` VARCHAR(16) NOT NULL,
|
2008.2.4
by Brian Aker
Merge in additional fixes for sign, plus alter table, plus TIME on |
1490 |
`TIME` BIGINT UNSIGNED NOT NULL,
|
1726.3.8
by Andrew Hutchings
Fix tests |
1491 |
`STATE` VARCHAR(256) DEFAULT NULL,
|
1948.2.7
by Brian Aker
Adding "HAS_GLOBAL_LOCK" to processlist. |
1492 |
`INFO` VARCHAR(100) DEFAULT NULL,
|
2023.2.3
by Brian Aker
Merge in fixes for DD to make use of BOOLEAN as a type. |
1493 |
`HAS_GLOBAL_LOCK` BOOLEAN NOT NULL
|
2293.2.1
by Joseph Daly
modify parser to work for DEFINER |
1494 |
) ENGINE=MyISAM COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER 'SYSTEM' |
1
by brian
clean slate |
1495 |
drop table t1;
|
1496 |
||
1497 |
# --
|
|
1498 |
# -- Bug#21380: DEFAULT definition not always transfered by CREATE
|
|
1499 |
# -- TABLE/SELECT to the new table.
|
|
1500 |
# --
|
|
1501 |
||
1502 |
DROP TABLE IF EXISTS t1;
|
|
1503 |
DROP TABLE IF EXISTS t2;
|
|
1504 |
||
1505 |
CREATE TABLE t1(
|
|
1506 |
c1 INT DEFAULT 12 COMMENT 'column1', |
|
1507 |
c2 INT NULL COMMENT 'column2', |
|
1508 |
c3 INT NOT NULL COMMENT 'column3', |
|
722.2.15
by Monty Taylor
Fixed create.test. |
1509 |
c4 VARCHAR(255) NOT NULL DEFAULT 'a', |
1
by brian
clean slate |
1510 |
c5 VARCHAR(255) COLLATE utf8_unicode_ci NULL DEFAULT 'b', |
1511 |
c6 VARCHAR(255))
|
|
1245.3.4
by Stewart Smith
make the equals of KEY=VALUE required for CREATE TABLE options |
1512 |
COLLATE=utf8_bin;
|
1
by brian
clean slate |
1513 |
|
1514 |
SHOW CREATE TABLE t1;
|
|
1515 |
Table Create Table
|
|
1516 |
t1 CREATE TABLE `t1` (
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
1517 |
`c1` INT DEFAULT '12' COMMENT 'column1', |
1518 |
`c2` INT DEFAULT NULL COMMENT 'column2', |
|
1519 |
`c3` INT NOT NULL COMMENT 'column3', |
|
1520 |
`c4` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT 'a', |
|
1521 |
`c5` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT 'b', |
|
1522 |
`c6` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL
|
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
1523 |
) ENGINE=DEFAULT COLLATE = utf8_bin
|
1
by brian
clean slate |
1524 |
|
1525 |
CREATE TABLE t2 AS SELECT * FROM t1;
|
|
1526 |
||
1527 |
SHOW CREATE TABLE t2;
|
|
1528 |
Table Create Table
|
|
1529 |
t2 CREATE TABLE `t2` (
|
|
1743.5.2
by LinuxJedi
Alter many test cases for the new SHOW CREATE TABLE output |
1530 |
`c1` INT DEFAULT '12' COMMENT 'column1', |
1531 |
`c2` INT DEFAULT NULL COMMENT 'column2', |
|
1532 |
`c3` INT NOT NULL COMMENT 'column3', |
|
1533 |
`c4` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT 'a', |
|
1534 |
`c5` VARCHAR(255) COLLATE utf8_unicode_ci DEFAULT 'b', |
|
1535 |
`c6` VARCHAR(255) COLLATE utf8_bin DEFAULT NULL
|
|
1638.10.63
by Stewart Smith
create.result with explicit COLLATE in SHOW CREATE TABLE |
1536 |
) ENGINE=DEFAULT COLLATE = utf8_general_ci
|
1
by brian
clean slate |
1537 |
|
1538 |
DROP TABLE t2;
|
|
1539 |
||
1540 |
# -- End of test case for Bug#21380.
|
|
1541 |
||
1542 |
# --
|
|
1543 |
# -- Bug#18834: ALTER TABLE ADD INDEX on table with two timestamp fields
|
|
1544 |
# --
|
|
1545 |
||
1546 |
DROP TABLE IF EXISTS t1;
|
|
1547 |
DROP TABLE IF EXISTS t2;
|
|
1548 |
DROP TABLE IF EXISTS t3;
|
|
1549 |
||
1550 |
CREATE TABLE t1(c1 TIMESTAMP, c2 TIMESTAMP);
|
|
1551 |
||
1552 |
||
907.1.7
by Jay Pipes
Merged in remove-timezone work |
1553 |
CREATE TABLE t2(c1 TIMESTAMP, c2 TIMESTAMP NULL);
|
722.2.15
by Monty Taylor
Fixed create.test. |
1554 |
drop table t2;
|
896.4.9
by Stewart Smith
No longer write the FRM. just use proto. |
1555 |
CREATE TABLE t2(c1 TIMESTAMP, c2 TIMESTAMP DEFAULT '1982-01-29'); |
722.2.15
by Monty Taylor
Fixed create.test. |
1556 |
drop table t2;
|
1
by brian
clean slate |
1557 |
|
1558 |
CREATE TABLE t2(c1 TIMESTAMP, c2 TIMESTAMP);
|
|
722.2.15
by Monty Taylor
Fixed create.test. |
1559 |
drop table t2;
|
1
by brian
clean slate |
1560 |
|
1561 |
# -- Check that NULL column still can be created.
|
|
1562 |
CREATE TABLE t2(c1 TIMESTAMP NULL);
|
|
1563 |
||
1564 |
# -- Check ALTER TABLE.
|
|
1565 |
ALTER TABLE t1 ADD INDEX(c1);
|
|
1566 |
||
1567 |
# -- Check DATETIME.
|
|
1568 |
||
1569 |
CREATE TABLE t3(c1 DATETIME NOT NULL);
|
|
1570 |
INSERT INTO t3 VALUES (0);
|
|
873.1.7
by Jay Pipes
Fixes Field_datetime::store(NUMBER) to throw an error when invalid |
1571 |
ERROR HY000: Received an invalid datetime value '0'. |
1
by brian
clean slate |
1572 |
|
873.1.7
by Jay Pipes
Fixes Field_datetime::store(NUMBER) to throw an error when invalid |
1573 |
ALTER TABLE t3 ADD INDEX(c1); |
1
by brian
clean slate |
1574 |
|
1575 |
# -- Cleanup. |
|
1576 |
DROP TABLE t1; |
|
1577 |
DROP TABLE t2; |
|
1578 |
DROP TABLE t3; |
|
1579 |
||
1580 |
# -- End of Bug#18834. |