Drizzle

Merge lp:~drizzle-pbxt/drizzle/drizzle-pbxt-4-test-results into lp:~drizzle-trunk/drizzle/development

  1. drizzle-pbxt-4-test-results
  2. Merge into development
Proposed by Vladimir Kolesnikov
Status: Work in progress
Proposed branch: lp:~drizzle-pbxt/drizzle/drizzle-pbxt-4-test-results
Merge into: lp:~drizzle-trunk/drizzle/development
Diff against target: 78357 lines
To merge this branch: bzr merge lp:~drizzle-pbxt/drizzle/drizzle-pbxt-4-test-results
Reviewer Review Type Date Requested Status
Drizzle Developers Pending
Review via email: mp+22826@code.launchpad.net

Description of the change

pbxt-specific .result files

To post a comment you must log in.

Unmerged revisions

1440. By Vladimir Kolesnikov

added engine-specific .result files for pbxt

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'drizzled/schema_identifier.cc'
2--- drizzled/schema_identifier.cc 2010-03-31 18:01:35 +0000
3+++ drizzled/schema_identifier.cc 2010-04-05 20:27:29 +0000
4@@ -42,7 +42,7 @@
5
6 static const char hexchars[]= "0123456789abcdef";
7
8-static bool tablename_to_filename(const char *from, char *to, size_t to_length);
9+bool tablename_to_filename(const char *from, char *to, size_t to_length);
10
11 static size_t build_schema_filename(std::string &path, const char *db)
12 {
13@@ -91,7 +91,7 @@
14 RETURN
15 true if errors happen. false on success.
16 */
17-static bool tablename_to_filename(const char *from, char *to, size_t to_length)
18+bool tablename_to_filename(const char *from, char *to, size_t to_length)
19 {
20
21 size_t length= 0;
22
23=== added directory 'tests/r/pbxt'
24=== added file 'tests/r/pbxt/alter_table.result'
25--- tests/r/pbxt/alter_table.result 1970-01-01 00:00:00 +0000
26+++ tests/r/pbxt/alter_table.result 2010-04-05 20:27:29 +0000
27@@ -0,0 +1,896 @@
28+drop table if exists t1,t2;
29+drop database if exists mysqltest;
30+create table t1 (
31+col1 int not null auto_increment primary key,
32+col2 varchar(30) not null,
33+col3 varchar (20) not null,
34+col4 varchar(4) not null,
35+col5 enum('PENDING', 'ACTIVE', 'DISABLED') not null,
36+col6 int not null, to_be_deleted int);
37+insert into t1 values (2,4,3,5,"PENDING",1,7);
38+alter table t1
39+add column col4_5 varchar(20) not null after col4,
40+add column col7 varchar(30) not null after col5,
41+add column col8 datetime not null, drop column to_be_deleted,
42+change column col2 fourth varchar(30) not null after col3,
43+modify column col6 int not null first;
44+select * from t1;
45+col6 col1 col3 fourth col4 col4_5 col5 col7 col8
46+1 2 3 4 5 PENDING 0000-00-00 00:00:00
47+drop table t1;
48+create table t1 (bandID INT NOT NULL PRIMARY KEY, payoutID int NOT NULL);
49+insert into t1 (bandID,payoutID) VALUES (1,6),(2,6),(3,4),(4,9),(5,10),(6,1),(7,12),(8,12);
50+alter table t1 add column new_col int;
51+select * from t1;
52+bandID payoutID new_col
53+1 6 NULL
54+2 6 NULL
55+3 4 NULL
56+4 9 NULL
57+5 10 NULL
58+6 1 NULL
59+7 12 NULL
60+8 12 NULL
61+alter table t1;
62+select * from t1;
63+bandID payoutID new_col
64+1 6 NULL
65+2 6 NULL
66+3 4 NULL
67+4 9 NULL
68+5 10 NULL
69+6 1 NULL
70+7 12 NULL
71+8 12 NULL
72+drop table t1;
73+CREATE TABLE t1 (
74+GROUP_ID int DEFAULT '0' NOT NULL,
75+LANG_ID int DEFAULT '0' NOT NULL,
76+NAME varchar(80) DEFAULT '' NOT NULL,
77+PRIMARY KEY (GROUP_ID,LANG_ID),
78+KEY NAME (NAME));
79+ALTER TABLE t1 CHANGE NAME NAME CHAR(80) not null;
80+SHOW FULL COLUMNS FROM t1;
81+Field Type Collation Null Key Default Extra Privileges Comment
82+GROUP_ID int NULL NO PRI 0 #
83+LANG_ID int NULL NO PRI 0 #
84+NAME varchar(80) utf8_general_ci NO MUL NULL #
85+DROP TABLE t1;
86+create table t1 (n int);
87+insert into t1 values(9),(3),(12),(10);
88+alter table t1 order by n;
89+select * from t1;
90+n
91+3
92+9
93+10
94+12
95+drop table t1;
96+CREATE TEMPORARY TABLE t1 (
97+id int NOT NULL default '0',
98+category_id int NOT NULL default '0',
99+type_id int NOT NULL default '0',
100+body text NOT NULL,
101+user_id int NOT NULL default '0',
102+status enum('new','old') NOT NULL default 'new',
103+PRIMARY KEY (id)
104+) ENGINE=MyISAM;
105+ALTER TABLE t1 ORDER BY t1.id, t1.status, t1.type_id, t1.user_id, t1.body;
106+DROP TABLE t1;
107+create table t1 (i int not null auto_increment primary key);
108+insert into t1 values (null),(null),(null),(null);
109+alter table t1 drop i,add i int not null auto_increment, drop primary key, add primary key (i);
110+select * from t1;
111+i
112+1
113+2
114+3
115+4
116+drop table t1;
117+create table t1 (name char(15));
118+insert into t1 (name) values ("current");
119+create database mysqltest;
120+create table mysqltest.t1 (name char(15));
121+insert into mysqltest.t1 (name) values ("mysqltest");
122+select * from t1;
123+name
124+current
125+select * from mysqltest.t1;
126+name
127+mysqltest
128+alter table t1 rename mysqltest.t1;
129+ERROR 42S01: Table 't1' already exists
130+select * from t1;
131+name
132+current
133+select * from mysqltest.t1;
134+name
135+mysqltest
136+drop table t1;
137+drop database mysqltest;
138+create table t1 (n1 int not null, n2 int, n3 int, n4 float,
139+unique(n1),
140+key (n1, n2, n3, n4),
141+key (n2, n3, n4, n1),
142+key (n3, n4, n1, n2),
143+key (n4, n1, n2, n3) );
144+alter table t1;
145+show keys from t1;
146+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
147+t1 0 n1 1 n1 A 0 NULL NULL BTREE
148+t1 1 n1_2 1 n1 A 0 NULL NULL BTREE
149+t1 1 n1_2 2 n2 A 0 NULL NULL YES BTREE
150+t1 1 n1_2 3 n3 A 0 NULL NULL YES BTREE
151+t1 1 n1_2 4 n4 A 0 NULL NULL YES BTREE
152+t1 1 n2 1 n2 A 0 NULL NULL YES BTREE
153+t1 1 n2 2 n3 A 0 NULL NULL YES BTREE
154+t1 1 n2 3 n4 A 0 NULL NULL YES BTREE
155+t1 1 n2 4 n1 A 0 NULL NULL BTREE
156+t1 1 n3 1 n3 A 0 NULL NULL YES BTREE
157+t1 1 n3 2 n4 A 0 NULL NULL YES BTREE
158+t1 1 n3 3 n1 A 0 NULL NULL BTREE
159+t1 1 n3 4 n2 A 0 NULL NULL YES BTREE
160+t1 1 n4 1 n4 A 0 NULL NULL YES BTREE
161+t1 1 n4 2 n1 A 0 NULL NULL BTREE
162+t1 1 n4 3 n2 A 0 NULL NULL YES BTREE
163+t1 1 n4 4 n3 A 0 NULL NULL YES BTREE
164+set autocommit=0;
165+begin;
166+insert into t1 values(10,RAND()*1000,RAND()*1000,RAND());
167+insert into t1 values(9,RAND()*1000,RAND()*1000,RAND());
168+insert into t1 values(8,RAND()*1000,RAND()*1000,RAND());
169+insert into t1 values(7,RAND()*1000,RAND()*1000,RAND());
170+insert into t1 values(6,RAND()*1000,RAND()*1000,RAND());
171+insert into t1 values(5,RAND()*1000,RAND()*1000,RAND());
172+insert into t1 values(4,RAND()*1000,RAND()*1000,RAND());
173+insert into t1 values(3,RAND()*1000,RAND()*1000,RAND());
174+insert into t1 values(2,RAND()*1000,RAND()*1000,RAND());
175+insert into t1 values(1,RAND()*1000,RAND()*1000,RAND());
176+commit;
177+set autocommit=1;
178+alter table t1 enable keys;
179+Warnings:
180+Note 1031 Table storage engine for 't1' doesn't have this option
181+show keys from t1;
182+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
183+t1 0 n1 1 n1 A 10 NULL NULL BTREE
184+t1 1 n1_2 1 n1 A 10 NULL NULL BTREE
185+t1 1 n1_2 2 n2 A 10 NULL NULL YES BTREE
186+t1 1 n1_2 3 n3 A 10 NULL NULL YES BTREE
187+t1 1 n1_2 4 n4 A 10 NULL NULL YES BTREE
188+t1 1 n2 1 n2 A 10 NULL NULL YES BTREE
189+t1 1 n2 2 n3 A 10 NULL NULL YES BTREE
190+t1 1 n2 3 n4 A 10 NULL NULL YES BTREE
191+t1 1 n2 4 n1 A 10 NULL NULL BTREE
192+t1 1 n3 1 n3 A 10 NULL NULL YES BTREE
193+t1 1 n3 2 n4 A 10 NULL NULL YES BTREE
194+t1 1 n3 3 n1 A 10 NULL NULL BTREE
195+t1 1 n3 4 n2 A 10 NULL NULL YES BTREE
196+t1 1 n4 1 n4 A 10 NULL NULL YES BTREE
197+t1 1 n4 2 n1 A 10 NULL NULL BTREE
198+t1 1 n4 3 n2 A 10 NULL NULL YES BTREE
199+t1 1 n4 4 n3 A 10 NULL NULL YES BTREE
200+drop table t1;
201+create table t1 (i int not null auto_increment primary key);
202+alter table t1 rename t2;
203+alter table t2 rename t1, add c char(10) comment "no comment";
204+show columns from t1;
205+Field Type Null Key Default Extra
206+i int NO PRI NULL auto_increment
207+c varchar(10) YES NULL
208+drop table t1;
209+create table t1 (a int, b int);
210+set autocommit=0;
211+begin;
212+insert into t1 values(1,100), (2,100), (3, 100);
213+insert into t1 values(1,99), (2,99), (3, 99);
214+insert into t1 values(1,98), (2,98), (3, 98);
215+insert into t1 values(1,97), (2,97), (3, 97);
216+insert into t1 values(1,96), (2,96), (3, 96);
217+insert into t1 values(1,95), (2,95), (3, 95);
218+insert into t1 values(1,94), (2,94), (3, 94);
219+insert into t1 values(1,93), (2,93), (3, 93);
220+insert into t1 values(1,92), (2,92), (3, 92);
221+insert into t1 values(1,91), (2,91), (3, 91);
222+insert into t1 values(1,90), (2,90), (3, 90);
223+insert into t1 values(1,89), (2,89), (3, 89);
224+insert into t1 values(1,88), (2,88), (3, 88);
225+insert into t1 values(1,87), (2,87), (3, 87);
226+insert into t1 values(1,86), (2,86), (3, 86);
227+insert into t1 values(1,85), (2,85), (3, 85);
228+insert into t1 values(1,84), (2,84), (3, 84);
229+insert into t1 values(1,83), (2,83), (3, 83);
230+insert into t1 values(1,82), (2,82), (3, 82);
231+insert into t1 values(1,81), (2,81), (3, 81);
232+insert into t1 values(1,80), (2,80), (3, 80);
233+insert into t1 values(1,79), (2,79), (3, 79);
234+insert into t1 values(1,78), (2,78), (3, 78);
235+insert into t1 values(1,77), (2,77), (3, 77);
236+insert into t1 values(1,76), (2,76), (3, 76);
237+insert into t1 values(1,75), (2,75), (3, 75);
238+insert into t1 values(1,74), (2,74), (3, 74);
239+insert into t1 values(1,73), (2,73), (3, 73);
240+insert into t1 values(1,72), (2,72), (3, 72);
241+insert into t1 values(1,71), (2,71), (3, 71);
242+insert into t1 values(1,70), (2,70), (3, 70);
243+insert into t1 values(1,69), (2,69), (3, 69);
244+insert into t1 values(1,68), (2,68), (3, 68);
245+insert into t1 values(1,67), (2,67), (3, 67);
246+insert into t1 values(1,66), (2,66), (3, 66);
247+insert into t1 values(1,65), (2,65), (3, 65);
248+insert into t1 values(1,64), (2,64), (3, 64);
249+insert into t1 values(1,63), (2,63), (3, 63);
250+insert into t1 values(1,62), (2,62), (3, 62);
251+insert into t1 values(1,61), (2,61), (3, 61);
252+insert into t1 values(1,60), (2,60), (3, 60);
253+insert into t1 values(1,59), (2,59), (3, 59);
254+insert into t1 values(1,58), (2,58), (3, 58);
255+insert into t1 values(1,57), (2,57), (3, 57);
256+insert into t1 values(1,56), (2,56), (3, 56);
257+insert into t1 values(1,55), (2,55), (3, 55);
258+insert into t1 values(1,54), (2,54), (3, 54);
259+insert into t1 values(1,53), (2,53), (3, 53);
260+insert into t1 values(1,52), (2,52), (3, 52);
261+insert into t1 values(1,51), (2,51), (3, 51);
262+insert into t1 values(1,50), (2,50), (3, 50);
263+insert into t1 values(1,49), (2,49), (3, 49);
264+insert into t1 values(1,48), (2,48), (3, 48);
265+insert into t1 values(1,47), (2,47), (3, 47);
266+insert into t1 values(1,46), (2,46), (3, 46);
267+insert into t1 values(1,45), (2,45), (3, 45);
268+insert into t1 values(1,44), (2,44), (3, 44);
269+insert into t1 values(1,43), (2,43), (3, 43);
270+insert into t1 values(1,42), (2,42), (3, 42);
271+insert into t1 values(1,41), (2,41), (3, 41);
272+insert into t1 values(1,40), (2,40), (3, 40);
273+insert into t1 values(1,39), (2,39), (3, 39);
274+insert into t1 values(1,38), (2,38), (3, 38);
275+insert into t1 values(1,37), (2,37), (3, 37);
276+insert into t1 values(1,36), (2,36), (3, 36);
277+insert into t1 values(1,35), (2,35), (3, 35);
278+insert into t1 values(1,34), (2,34), (3, 34);
279+insert into t1 values(1,33), (2,33), (3, 33);
280+insert into t1 values(1,32), (2,32), (3, 32);
281+insert into t1 values(1,31), (2,31), (3, 31);
282+insert into t1 values(1,30), (2,30), (3, 30);
283+insert into t1 values(1,29), (2,29), (3, 29);
284+insert into t1 values(1,28), (2,28), (3, 28);
285+insert into t1 values(1,27), (2,27), (3, 27);
286+insert into t1 values(1,26), (2,26), (3, 26);
287+insert into t1 values(1,25), (2,25), (3, 25);
288+insert into t1 values(1,24), (2,24), (3, 24);
289+insert into t1 values(1,23), (2,23), (3, 23);
290+insert into t1 values(1,22), (2,22), (3, 22);
291+insert into t1 values(1,21), (2,21), (3, 21);
292+insert into t1 values(1,20), (2,20), (3, 20);
293+insert into t1 values(1,19), (2,19), (3, 19);
294+insert into t1 values(1,18), (2,18), (3, 18);
295+insert into t1 values(1,17), (2,17), (3, 17);
296+insert into t1 values(1,16), (2,16), (3, 16);
297+insert into t1 values(1,15), (2,15), (3, 15);
298+insert into t1 values(1,14), (2,14), (3, 14);
299+insert into t1 values(1,13), (2,13), (3, 13);
300+insert into t1 values(1,12), (2,12), (3, 12);
301+insert into t1 values(1,11), (2,11), (3, 11);
302+insert into t1 values(1,10), (2,10), (3, 10);
303+insert into t1 values(1,9), (2,9), (3, 9);
304+insert into t1 values(1,8), (2,8), (3, 8);
305+insert into t1 values(1,7), (2,7), (3, 7);
306+insert into t1 values(1,6), (2,6), (3, 6);
307+insert into t1 values(1,5), (2,5), (3, 5);
308+insert into t1 values(1,4), (2,4), (3, 4);
309+insert into t1 values(1,3), (2,3), (3, 3);
310+insert into t1 values(1,2), (2,2), (3, 2);
311+insert into t1 values(1,1), (2,1), (3, 1);
312+commit;
313+set autocommit=1;
314+alter table t1 add unique (a,b), add key (b);
315+show keys from t1;
316+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
317+t1 0 a 1 a A 300 NULL NULL YES BTREE
318+t1 0 a 2 b A 300 NULL NULL YES BTREE
319+t1 1 b 1 b A 300 NULL NULL YES BTREE
320+analyze table t1;
321+Table Op Msg_type Msg_text
322+test.t1 analyze status OK
323+show keys from t1;
324+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
325+t1 0 a 1 a A 300 NULL NULL YES BTREE
326+t1 0 a 2 b A 300 NULL NULL YES BTREE
327+t1 1 b 1 b A 300 NULL NULL YES BTREE
328+drop table t1;
329+CREATE TEMPORARY TABLE t1 (
330+Host varchar(16) binary NOT NULL default '',
331+User varchar(16) binary NOT NULL default '',
332+PRIMARY KEY (Host,User),
333+KEY (Host)
334+) ENGINE=MyISAM;
335+ALTER TABLE t1 DISABLE KEYS;
336+SHOW INDEX FROM t1;
337+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
338+t1 0 PRIMARY 1 Host A NULL NULL NULL BTREE
339+t1 0 PRIMARY 2 User A 0 NULL NULL BTREE
340+t1 1 Host 1 Host A NULL NULL NULL BTREE disabled
341+INSERT INTO t1 VALUES ('localhost','root'),('localhost','');
342+SHOW INDEX FROM t1;
343+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
344+t1 0 PRIMARY 1 Host A NULL NULL NULL BTREE
345+t1 0 PRIMARY 2 User A 2 NULL NULL BTREE
346+t1 1 Host 1 Host A NULL NULL NULL BTREE disabled
347+ALTER TABLE t1 ENABLE KEYS;
348+SHOW INDEX FROM t1;
349+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
350+t1 0 PRIMARY 1 Host A NULL NULL NULL BTREE
351+t1 0 PRIMARY 2 User A 2 NULL NULL BTREE
352+t1 1 Host 1 Host A NULL NULL NULL BTREE
353+CHECK TABLES t1;
354+Table Op Msg_type Msg_text
355+test.t1 check status OK
356+ALTER TABLE t1 RENAME t2;
357+select * from t2;
358+Host User
359+localhost
360+localhost root
361+DROP TABLE t2;
362+create table t1 (a int);
363+alter table t1 rename to ``;
364+ERROR 42000: Incorrect table name ''
365+rename table t1 to ``;
366+ERROR 42000: Incorrect table name ''
367+drop table t1;
368+drop table if exists t1;
369+Warnings:
370+Note 1051 Unknown table 't1'
371+create TEMPORARY table t1 ( a varchar(10) not null primary key ) engine=myisam;
372+flush tables;
373+alter table t1 modify a varchar(10);
374+flush tables;
375+alter table t1 modify a varchar(10) not null;
376+drop table if exists t1;
377+create TEMPORARY table t1 (a int, b int, c int, d int, e int, f int, g int, h int,i int, primary key (a,b,c,d,e,f,g,i,h)) engine=MyISAM;
378+insert into t1 (a,b,c,d,e,f,g,h,i) values(1,1,1,1,1,1,1,1,1);
379+show table status like 't1';
380+Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
381+alter table t1 modify a int;
382+show table status like 't1';
383+Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
384+drop table t1;
385+create TEMPORARY table t1 (a int not null default 0, b int not null default 0, c int not null default 0, d int not null default 0, e int not null default 0, f int not null default 0, g int not null default 0, h int not null default 0,i int not null default 0, primary key (a,b,c,d,e,f,g,i,h)) engine=MyISAM;
386+insert into t1 (a) values(1);
387+show table status like 't1';
388+Name Engine Version Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Check_time Collation Checksum Create_options Comment
389+drop table t1;
390+CREATE TABLE t1 (a int PRIMARY KEY, b INT UNIQUE);
391+ALTER TABLE t1 DROP PRIMARY KEY;
392+SHOW CREATE TABLE t1;
393+Table Create Table
394+t1 CREATE TABLE `t1` (
395+ `a` int NOT NULL,
396+ `b` int DEFAULT NULL,
397+ UNIQUE KEY `b` (`b`)
398+) ENGINE=DEFAULT
399+ALTER TABLE t1 DROP PRIMARY KEY;
400+ERROR 42000: Can't DROP 'PRIMARY'; check that column/key exists
401+DROP TABLE t1;
402+create table t1 (a int, b int, key(a));
403+insert into t1 values (1,1), (2,2);
404+alter table t1 drop key no_such_key;
405+ERROR 42000: Can't DROP 'no_such_key'; check that column/key exists
406+alter table t1 drop key a;
407+drop table t1;
408+CREATE TEMPORARY TABLE T12207(a int) ENGINE=MYISAM;
409+ALTER TABLE T12207 DISCARD TABLESPACE;
410+ERROR HY000: Table storage engine for 'T12207' doesn't have this option
411+DROP TABLE T12207;
412+create table t1 ( a timestamp );
413+alter table t1 add unique ( a(1) );
414+ERROR HY000: Incorrect prefix key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique prefix keys
415+drop table t1;
416+drop table if exists t1;
417+create table t1 (a int, key(a));
418+show indexes from t1;
419+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
420+t1 1 a 1 a A 0 NULL NULL YES BTREE
421+"this used not to disable the index"
422+alter table t1 modify a int;
423+show indexes from t1;
424+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
425+t1 1 a 1 a A 0 NULL NULL YES BTREE
426+alter table t1 enable keys;
427+Warnings:
428+Note 1031 Table storage engine for 't1' doesn't have this option
429+show indexes from t1;
430+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
431+t1 1 a 1 a A 0 NULL NULL YES BTREE
432+alter table t1 modify a bigint;
433+show indexes from t1;
434+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
435+t1 1 a 1 a A 0 NULL NULL YES BTREE
436+alter table t1 enable keys;
437+Warnings:
438+Note 1031 Table storage engine for 't1' doesn't have this option
439+show indexes from t1;
440+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
441+t1 1 a 1 a A 0 NULL NULL YES BTREE
442+alter table t1 add b char(10);
443+show indexes from t1;
444+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
445+t1 1 a 1 a A 0 NULL NULL YES BTREE
446+alter table t1 add c decimal(10,2);
447+show indexes from t1;
448+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
449+t1 1 a 1 a A 0 NULL NULL YES BTREE
450+"this however did"
451+alter table t1;
452+show indexes from t1;
453+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
454+t1 1 a 1 a A 0 NULL NULL YES BTREE
455+desc t1;
456+Field Type Null Key Default Extra
457+a bigint YES MUL NULL
458+b varchar(10) YES NULL
459+c decimal(10,2) YES NULL
460+alter table t1 add d decimal(15,5);
461+"The key should still be disabled"
462+show indexes from t1;
463+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
464+t1 1 a 1 a A 0 NULL NULL YES BTREE
465+drop table t1;
466+"Now will test with one unique index"
467+create table t1(a int, b char(10), unique(a));
468+show indexes from t1;
469+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
470+t1 0 a 1 a A 0 NULL NULL YES BTREE
471+alter table t1;
472+show indexes from t1;
473+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
474+t1 0 a 1 a A 0 NULL NULL YES BTREE
475+alter table t1 enable keys;
476+Warnings:
477+Note 1031 Table storage engine for 't1' doesn't have this option
478+"If no copy on noop change, this won't touch the data file"
479+"Unique index, no change"
480+alter table t1 modify a int;
481+show indexes from t1;
482+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
483+t1 0 a 1 a A 0 NULL NULL YES BTREE
484+"Change the type implying data copy"
485+"Unique index, no change"
486+alter table t1 modify a bigint;
487+show indexes from t1;
488+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
489+t1 0 a 1 a A 0 NULL NULL YES BTREE
490+alter table t1 modify a bigint;
491+show indexes from t1;
492+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
493+t1 0 a 1 a A 0 NULL NULL YES BTREE
494+alter table t1 modify a int;
495+show indexes from t1;
496+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
497+t1 0 a 1 a A 0 NULL NULL YES BTREE
498+drop table t1;
499+"Now will test with one unique and one non-unique index"
500+create table t1(a int, b char(10), unique(a), key(b));
501+show indexes from t1;
502+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
503+t1 0 a 1 a A 0 NULL NULL YES BTREE
504+t1 1 b 1 b A 0 NULL NULL YES BTREE
505+alter table t1;
506+show indexes from t1;
507+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
508+t1 0 a 1 a A 0 NULL NULL YES BTREE
509+t1 1 b 1 b A 0 NULL NULL YES BTREE
510+alter table t1 enable keys;
511+Warnings:
512+Note 1031 Table storage engine for 't1' doesn't have this option
513+"If no copy on noop change, this won't touch the data file"
514+"The non-unique index will be disabled"
515+alter table t1 modify a int;
516+show indexes from t1;
517+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
518+t1 0 a 1 a A 0 NULL NULL YES BTREE
519+t1 1 b 1 b A 0 NULL NULL YES BTREE
520+alter table t1 enable keys;
521+Warnings:
522+Note 1031 Table storage engine for 't1' doesn't have this option
523+show indexes from t1;
524+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
525+t1 0 a 1 a A 0 NULL NULL YES BTREE
526+t1 1 b 1 b A 0 NULL NULL YES BTREE
527+"Change the type implying data copy"
528+"The non-unique index will be disabled"
529+alter table t1 modify a bigint;
530+show indexes from t1;
531+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
532+t1 0 a 1 a A 0 NULL NULL YES BTREE
533+t1 1 b 1 b A 0 NULL NULL YES BTREE
534+"Change again the type, but leave the indexes as_is"
535+alter table t1 modify a int;
536+show indexes from t1;
537+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
538+t1 0 a 1 a A 0 NULL NULL YES BTREE
539+t1 1 b 1 b A 0 NULL NULL YES BTREE
540+"Try the same. When data is no copied on similar tables, this is noop"
541+alter table t1 modify a int;
542+show indexes from t1;
543+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
544+t1 0 a 1 a A 0 NULL NULL YES BTREE
545+t1 1 b 1 b A 0 NULL NULL YES BTREE
546+drop table t1;
547+create database mysqltest;
548+create table t1 (c1 int);
549+alter table t1 rename mysqltest.t1;
550+drop table t1;
551+ERROR 42S02: Unknown table 't1'
552+alter table mysqltest.t1 rename t1;
553+drop table t1;
554+create table t1 (c1 int);
555+use mysqltest;
556+drop database mysqltest;
557+alter table test.t1 rename t1;
558+ERROR 3D000: No database selected
559+alter table test.t1 rename test.t1;
560+use test;
561+drop table t1;
562+CREATE TABLE t1(a INT) ROW_FORMAT=FIXED;
563+CREATE INDEX i1 ON t1(a);
564+SHOW CREATE TABLE t1;
565+Table Create Table
566+t1 CREATE TABLE `t1` (
567+ `a` int DEFAULT NULL,
568+ KEY `i1` (`a`)
569+) ENGINE=DEFAULT ROW_FORMAT=FIXED
570+DROP INDEX i1 ON t1;
571+SHOW CREATE TABLE t1;
572+Table Create Table
573+t1 CREATE TABLE `t1` (
574+ `a` int DEFAULT NULL
575+) ENGINE=DEFAULT ROW_FORMAT=FIXED
576+DROP TABLE t1;
577+DROP TABLE IF EXISTS bug24219;
578+DROP TABLE IF EXISTS bug24219_2;
579+CREATE TABLE bug24219 (a INT, INDEX(a));
580+SHOW INDEX FROM bug24219;
581+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
582+bug24219 1 a 1 a A 0 NULL NULL YES BTREE
583+ALTER TABLE bug24219 RENAME TO bug24219_2, DISABLE KEYS;
584+Warnings:
585+Note 1031 Table storage engine for 'bug24219' doesn't have this option
586+SHOW INDEX FROM bug24219_2;
587+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
588+bug24219_2 1 a 1 a A 0 NULL NULL YES BTREE
589+DROP TABLE bug24219_2;
590+drop table if exists table_24562;
591+create table table_24562(
592+section int,
593+subsection int,
594+title varchar(50));
595+insert into table_24562 values
596+(1, 0, "Introduction"),
597+(1, 1, "Authors"),
598+(1, 2, "Acknowledgements"),
599+(2, 0, "Basics"),
600+(2, 1, "Syntax"),
601+(2, 2, "Client"),
602+(2, 3, "Server"),
603+(3, 0, "Intermediate"),
604+(3, 1, "Complex queries"),
605+(3, 2, "Stored Procedures"),
606+(3, 3, "Stored Functions"),
607+(4, 0, "Advanced"),
608+(4, 1, "Replication"),
609+(4, 2, "Load balancing"),
610+(4, 3, "High availability"),
611+(5, 0, "Conclusion");
612+select * from table_24562;
613+section subsection title
614+1 0 Introduction
615+1 1 Authors
616+1 2 Acknowledgements
617+2 0 Basics
618+2 1 Syntax
619+2 2 Client
620+2 3 Server
621+3 0 Intermediate
622+3 1 Complex queries
623+3 2 Stored Procedures
624+3 3 Stored Functions
625+4 0 Advanced
626+4 1 Replication
627+4 2 Load balancing
628+4 3 High availability
629+5 0 Conclusion
630+alter table table_24562 add column reviewer varchar(20),
631+order by title;
632+select * from table_24562;
633+section subsection title reviewer
634+1 2 Acknowledgements NULL
635+4 0 Advanced NULL
636+1 1 Authors NULL
637+2 0 Basics NULL
638+2 2 Client NULL
639+3 1 Complex queries NULL
640+5 0 Conclusion NULL
641+4 3 High availability NULL
642+3 0 Intermediate NULL
643+1 0 Introduction NULL
644+4 2 Load balancing NULL
645+4 1 Replication NULL
646+2 3 Server NULL
647+3 3 Stored Functions NULL
648+3 2 Stored Procedures NULL
649+2 1 Syntax NULL
650+update table_24562 set reviewer="Me" where section=2;
651+update table_24562 set reviewer="You" where section=3;
652+alter table table_24562
653+order by section ASC, subsection DESC;
654+select * from table_24562;
655+section subsection title reviewer
656+1 2 Acknowledgements NULL
657+1 1 Authors NULL
658+1 0 Introduction NULL
659+2 3 Server Me
660+2 2 Client Me
661+2 1 Syntax Me
662+2 0 Basics Me
663+3 3 Stored Functions You
664+3 2 Stored Procedures You
665+3 1 Complex queries You
666+3 0 Intermediate You
667+4 3 High availability NULL
668+4 2 Load balancing NULL
669+4 1 Replication NULL
670+4 0 Advanced NULL
671+5 0 Conclusion NULL
672+alter table table_24562
673+order by table_24562.subsection ASC, table_24562.section DESC;
674+select * from table_24562;
675+section subsection title reviewer
676+5 0 Conclusion NULL
677+4 0 Advanced NULL
678+3 0 Intermediate You
679+2 0 Basics Me
680+1 0 Introduction NULL
681+4 1 Replication NULL
682+3 1 Complex queries You
683+2 1 Syntax Me
684+1 1 Authors NULL
685+4 2 Load balancing NULL
686+3 2 Stored Procedures You
687+2 2 Client Me
688+1 2 Acknowledgements NULL
689+4 3 High availability NULL
690+3 3 Stored Functions You
691+2 3 Server Me
692+alter table table_24562 order by 12;
693+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 '12' at line 1
694+alter table table_24562 order by (section + 12);
695+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 '(section + 12)' at line 1
696+alter table table_24562 order by length(title);
697+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 '(title)' at line 1
698+alter table table_24562 order by no_such_col;
699+ERROR 42S22: Unknown column 'no_such_col' in 'order clause'
700+drop table table_24562;
701+create table t1 (mycol int not null);
702+alter table t1 alter column mycol set default 0;
703+desc t1;
704+Field Type Null Key Default Extra
705+mycol int NO 0
706+drop table t1;
707+create TEMPORARY table t1(id int primary key auto_increment) engine=heap;
708+insert into t1 values (null);
709+insert into t1 values (null);
710+select * from t1;
711+id
712+1
713+2
714+alter table t1 auto_increment = 50;
715+alter table t1 engine = myisam;
716+insert into t1 values (null);
717+select * from t1;
718+id
719+1
720+2
721+50
722+alter table t1 engine = heap;
723+insert into t1 values (null);
724+select * from t1;
725+id
726+1
727+2
728+50
729+51
730+drop table t1;
731+create table t1 (v varchar(32));
732+insert into t1 values ('def'),('abc'),('hij'),('3r4f');
733+select * from t1;
734+v
735+def
736+abc
737+hij
738+3r4f
739+alter table t1 change v v2 varchar(32);
740+select * from t1;
741+v2
742+def
743+abc
744+hij
745+3r4f
746+alter table t1 change v2 v varchar(64);
747+select * from t1;
748+v
749+def
750+abc
751+hij
752+3r4f
753+update t1 set v = 'lmn' where v = 'hij';
754+select * from t1;
755+v
756+def
757+abc
758+3r4f
759+lmn
760+alter table t1 add i int auto_increment not null primary key first;
761+select * from t1;
762+i v
763+1 def
764+2 abc
765+3 3r4f
766+4 lmn
767+update t1 set i=5 where i=3;
768+select * from t1;
769+i v
770+1 def
771+2 abc
772+4 lmn
773+5 3r4f
774+alter table t1 change i i bigint;
775+select * from t1;
776+i v
777+1 def
778+2 abc
779+4 lmn
780+5 3r4f
781+alter table t1 add unique key (i, v);
782+select * from t1 where i between 2 and 4 and v in ('def','3r4f','lmn');
783+i v
784+4 lmn
785+drop table t1;
786+create TEMPORARY table t1 (t varchar(255) default null, key t (t(80))) engine=myisam;
787+alter table t1 change t t text;
788+drop table t1;
789+CREATE TABLE t1 (s CHAR(8) BINARY);
790+INSERT INTO t1 VALUES ('test');
791+SELECT LENGTH(s) FROM t1;
792+LENGTH(s)
793+4
794+ALTER TABLE t1 MODIFY s CHAR(10) BINARY;
795+SELECT LENGTH(s) FROM t1;
796+LENGTH(s)
797+4
798+DROP TABLE t1;
799+CREATE TABLE t1 (s varbinary(8));
800+INSERT INTO t1 VALUES ('test');
801+SELECT LENGTH(s) FROM t1;
802+LENGTH(s)
803+4
804+SELECT HEX(s) FROM t1;
805+HEX(s)
806+74657374
807+ALTER TABLE t1 MODIFY s varbinary(10);
808+SELECT HEX(s) FROM t1;
809+HEX(s)
810+74657374
811+SELECT LENGTH(s) FROM t1;
812+LENGTH(s)
813+4
814+DROP TABLE t1;
815+CREATE TABLE t1 (v VARCHAR(3), b INT);
816+INSERT INTO t1 VALUES ('abc', 5);
817+SELECT * FROM t1;
818+v b
819+abc 5
820+ALTER TABLE t1 MODIFY COLUMN v VARCHAR(4);
821+SELECT * FROM t1;
822+v b
823+abc 5
824+DROP TABLE t1;
825+End of 5.0 tests
826+DROP TABLE IF EXISTS `t+1`, `t+2`;
827+CREATE TABLE `t+1` (c1 INT);
828+ALTER TABLE `t+1` RENAME `t+2`;
829+CREATE TABLE `t+1` (c1 INT);
830+ALTER TABLE `t+1` RENAME `t+2`;
831+ERROR 42S01: Table 't+2' already exists
832+DROP TABLE `t+1`, `t+2`;
833+CREATE TEMPORARY TABLE `tt+1` (c1 INT);
834+ALTER TABLE `tt+1` RENAME `tt+2`;
835+CREATE TEMPORARY TABLE `tt+1` (c1 INT);
836+ALTER TABLE `tt+1` RENAME `tt+2`;
837+ERROR 42S01: Table 'tt+2' already exists
838+SHOW CREATE TABLE `tt+1`;
839+Table Create Table
840+tt+1 CREATE TEMPORARY TABLE `tt+1` (
841+ `c1` int DEFAULT NULL
842+) ENGINE=DEFAULT
843+SHOW CREATE TABLE `tt+2`;
844+Table Create Table
845+tt+2 CREATE TEMPORARY TABLE `tt+2` (
846+ `c1` int DEFAULT NULL
847+) ENGINE=DEFAULT
848+DROP TABLE `tt+1`, `tt+2`;
849+CREATE TEMPORARY TABLE `#sql1` (c1 INT);
850+CREATE TEMPORARY TABLE `@0023sql2` (c1 INT);
851+SHOW TABLES;
852+Tables_in_test
853+ALTER TABLE `#sql1` RENAME `@0023sql1`;
854+ALTER TABLE `@0023sql2` RENAME `#sql2`;
855+SHOW TABLES;
856+Tables_in_test
857+INSERT INTO `#sql2` VALUES (1);
858+INSERT INTO `@0023sql1` VALUES (2);
859+SHOW CREATE TABLE `#sql2`;
860+Table Create Table
861+#sql2 CREATE TEMPORARY TABLE `#sql2` (
862+ `c1` int DEFAULT NULL
863+) ENGINE=DEFAULT
864+SHOW CREATE TABLE `@0023sql1`;
865+Table Create Table
866+@0023sql1 CREATE TEMPORARY TABLE `@0023sql1` (
867+ `c1` int DEFAULT NULL
868+) ENGINE=DEFAULT
869+DROP TABLE `#sql2`, `@0023sql1`;
870+DROP TABLE IF EXISTS t1;
871+DROP TABLE IF EXISTS t2;
872+CREATE TABLE t1 (
873+int_field INTEGER NOT NULL,
874+char_field CHAR(10),
875+INDEX(`int_field`)
876+);
877+DESCRIBE t1;
878+Field Type Null Key Default Extra
879+int_field int NO MUL NULL
880+char_field varchar(10) YES NULL
881+SHOW INDEXES FROM t1;
882+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
883+t1 1 int_field 1 int_field A 0 NULL NULL BTREE
884+INSERT INTO t1 VALUES (1, "edno"), (1, "edno"), (2, "dve"), (3, "tri"), (5, "pet");
885+"Non-copy data change - new frm, but old data and index files"
886+ALTER TABLE t1 CHANGE int_field unsigned_int_field INTEGER NOT NULL, RENAME t2;
887+SELECT * FROM t1 ORDER BY int_field;
888+ERROR 42S02: Table 'test.t1' doesn't exist
889+SELECT * FROM t2 ORDER BY unsigned_int_field;
890+unsigned_int_field char_field
891+1 edno
892+1 edno
893+2 dve
894+3 tri
895+5 pet
896+DESCRIBE t2;
897+Field Type Null Key Default Extra
898+unsigned_int_field int NO MUL NULL
899+char_field varchar(10) YES NULL
900+DESCRIBE t2;
901+Field Type Null Key Default Extra
902+unsigned_int_field int NO MUL NULL
903+char_field varchar(10) YES NULL
904+ALTER TABLE t2 MODIFY unsigned_int_field BIGINT NOT NULL;
905+DESCRIBE t2;
906+Field Type Null Key Default Extra
907+unsigned_int_field bigint NO MUL NULL
908+char_field varchar(10) YES NULL
909+DROP TABLE t2;
910+CREATE TABLE t1 (f1 INT, f2 INT, f3 INT);
911+INSERT INTO t1 VALUES (1, 2, NULL);
912+SELECT * FROM t1;
913+f1 f2 f3
914+1 2 NULL
915+ALTER TABLE t1 MODIFY COLUMN f3 INT AFTER f1;
916+SELECT * FROM t1;
917+f1 f3 f2
918+1 NULL 2
919+ALTER TABLE t1 MODIFY COLUMN f3 INT AFTER f2;
920+SELECT * FROM t1;
921+f1 f2 f3
922+1 2 NULL
923+DROP TABLE t1;
924
925=== added file 'tests/r/pbxt/auto_increment.result'
926--- tests/r/pbxt/auto_increment.result 1970-01-01 00:00:00 +0000
927+++ tests/r/pbxt/auto_increment.result 2010-04-05 20:27:29 +0000
928@@ -0,0 +1,361 @@
929+drop table if exists t1;
930+drop table if exists t2;
931+SET SQL_WARNINGS=1;
932+create TEMPORARY table t1 (a int not null auto_increment,b int, primary key (a)) engine=myisam auto_increment=3;
933+insert into t1 values (1,1),(NULL,3),(NULL,4);
934+delete from t1 where a=4;
935+insert into t1 values (NULL,5),(NULL,6);
936+select * from t1;
937+a b
938+1 1
939+3 3
940+5 5
941+6 6
942+delete from t1 where a=6;
943+replace t1 values (3,1);
944+ALTER TABLE t1 add c int;
945+replace t1 values (3,3,3);
946+insert into t1 values (NULL,7,7);
947+update t1 set a=8,b=b+1,c=c+1 where a=7;
948+insert into t1 values (NULL,9,9);
949+select * from t1;
950+a b c
951+1 1 NULL
952+3 3 3
953+5 5 NULL
954+8 8 8
955+9 9 9
956+drop table t1;
957+create table t1 (
958+skey int NOT NULL auto_increment PRIMARY KEY,
959+sval char(20)
960+);
961+insert into t1 values (NULL, "hello");
962+insert into t1 values (NULL, "hey");
963+select * from t1;
964+skey sval
965+1 hello
966+2 hey
967+select _rowid,t1._rowid,skey,sval from t1;
968+_rowid _rowid skey sval
969+1 1 1 hello
970+2 2 2 hey
971+drop table t1;
972+create table t1 (a int not null primary key auto_increment);
973+insert into t1 values (0);
974+update t1 set a=0;
975+select * from t1;
976+a
977+0
978+check table t1;
979+Table Op Msg_type Msg_text
980+test.t1 check status OK
981+drop table t1;
982+create table t1 (a int not null auto_increment primary key);
983+insert into t1 values (NULL);
984+insert into t1 values (-1);
985+select last_insert_id();
986+last_insert_id()
987+1
988+insert into t1 values (NULL);
989+select * from t1;
990+a
991+-1
992+1
993+2
994+drop table t1;
995+create temporary table t1 (a int not null auto_increment primary key) /*!40102 engine=heap */;
996+insert into t1 values (NULL);
997+insert into t1 values (-1);
998+select last_insert_id();
999+last_insert_id()
1000+1
1001+insert into t1 values (NULL);
1002+select * from t1;
1003+a
1004+1
1005+-1
1006+2
1007+drop table t1;
1008+create table t1 (i int not null auto_increment, key (i));
1009+insert into t1 set i = 254;
1010+insert into t1 set i = null;
1011+select last_insert_id();
1012+last_insert_id()
1013+255
1014+insert into t1 set i = null;
1015+select last_insert_id();
1016+last_insert_id()
1017+256
1018+drop table t1;
1019+create table t1 (i int not null auto_increment primary key, b int, unique (b));
1020+insert into t1 values (NULL, 10);
1021+select last_insert_id();
1022+last_insert_id()
1023+1
1024+insert into t1 values (NULL, 15);
1025+select last_insert_id();
1026+last_insert_id()
1027+2
1028+insert into t1 values (NULL, 10);
1029+ERROR 23000: Duplicate entry '10' for key 'b'
1030+select last_insert_id();
1031+last_insert_id()
1032+2
1033+drop table t1;
1034+create table t1(a int auto_increment,b int null,primary key(a));
1035+insert into t1(a,b)values(NULL,1);
1036+insert into t1(a,b)values(200,2);
1037+insert into t1(a,b)values(0,3);
1038+insert into t1(b)values(4);
1039+insert into t1(b)values(5);
1040+insert into t1(b)values(6);
1041+insert into t1(b)values(7);
1042+select * from t1 order by b;
1043+a b
1044+1 1
1045+200 2
1046+0 3
1047+201 4
1048+202 5
1049+203 6
1050+204 7
1051+alter table t1 modify b int;
1052+select * from t1 order by b;
1053+a b
1054+1 1
1055+200 2
1056+0 3
1057+201 4
1058+202 5
1059+203 6
1060+204 7
1061+create table t2 (a int);
1062+insert t2 values (1),(2);
1063+alter table t2 add b int auto_increment primary key;
1064+select * from t2;
1065+a b
1066+1 1
1067+2 2
1068+drop table t2;
1069+delete from t1 where a=0;
1070+update t1 set a=0 where b=5;
1071+select * from t1 order by b;
1072+a b
1073+1 1
1074+200 2
1075+201 4
1076+0 5
1077+203 6
1078+204 7
1079+delete from t1 where a=0;
1080+update t1 set a=NULL where b=6;
1081+ERROR 23000: Column 'a' cannot be null
1082+update t1 set a=300 where b=7;
1083+insert into t1(a,b)values(NULL,8);
1084+insert into t1(a,b)values(400,9);
1085+insert into t1(a,b)values(0,10);
1086+insert into t1(b)values(11);
1087+insert into t1(b)values(12);
1088+insert into t1(b)values(13);
1089+insert into t1(b)values(14);
1090+select * from t1 order by b;
1091+a b
1092+1 1
1093+200 2
1094+201 4
1095+203 6
1096+300 7
1097+301 8
1098+400 9
1099+0 10
1100+401 11
1101+402 12
1102+403 13
1103+404 14
1104+delete from t1 where a=0;
1105+update t1 set a=0 where b=12;
1106+select * from t1 order by b;
1107+a b
1108+1 1
1109+200 2
1110+201 4
1111+203 6
1112+300 7
1113+301 8
1114+400 9
1115+401 11
1116+0 12
1117+403 13
1118+404 14
1119+delete from t1 where a=0;
1120+update t1 set a=NULL where b=13;
1121+ERROR 23000: Column 'a' cannot be null
1122+update t1 set a=500 where b=14;
1123+select * from t1 order by b;
1124+a b
1125+1 1
1126+200 2
1127+201 4
1128+203 6
1129+300 7
1130+301 8
1131+400 9
1132+401 11
1133+403 13
1134+500 14
1135+drop table t1;
1136+create table t1 (a bigint);
1137+insert into t1 values (1), (2), (3), (NULL), (NULL);
1138+alter table t1 modify a bigint not null auto_increment primary key;
1139+select * from t1;
1140+a
1141+1
1142+2
1143+3
1144+4
1145+5
1146+drop table t1;
1147+create table t1 (a bigint);
1148+insert into t1 values (1), (2), (3), (0), (0);
1149+alter table t1 modify a bigint not null auto_increment primary key;
1150+ERROR 23000: ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '0' for key 'PRIMARY'
1151+select * from t1;
1152+a
1153+1
1154+2
1155+3
1156+0
1157+0
1158+drop table t1;
1159+create table t1 (a bigint);
1160+insert into t1 values (0), (1), (2), (3);
1161+alter table t1 modify a bigint not null auto_increment primary key;
1162+select * from t1;
1163+a
1164+0
1165+1
1166+2
1167+3
1168+drop table t1;
1169+create table t1 (a int auto_increment primary key , b int null);
1170+insert into t1 values (0,1),(1,2),(2,3);
1171+select * from t1;
1172+a b
1173+0 1
1174+1 2
1175+2 3
1176+alter table t1 modify b varchar(255);
1177+insert into t1 values (0,4);
1178+ERROR 23000: Duplicate entry '0' for key 'PRIMARY'
1179+select * from t1;
1180+a b
1181+0 1
1182+1 2
1183+2 3
1184+drop table t1;
1185+CREATE TABLE t1 ( a INT AUTO_INCREMENT, b BLOB, PRIMARY KEY (a,b(10)));
1186+INSERT INTO t1 (b) VALUES ('aaaa');
1187+CHECK TABLE t1;
1188+Table Op Msg_type Msg_text
1189+test.t1 check status OK
1190+INSERT INTO t1 (b) VALUES ('');
1191+CHECK TABLE t1;
1192+Table Op Msg_type Msg_text
1193+test.t1 check status OK
1194+INSERT INTO t1 (b) VALUES ('bbbb');
1195+CHECK TABLE t1;
1196+Table Op Msg_type Msg_text
1197+test.t1 check status OK
1198+DROP TABLE IF EXISTS t1;
1199+CREATE TABLE t1 (
1200+t1_name VARCHAR(255) DEFAULT NULL,
1201+t1_id INT not null AUTO_INCREMENT,
1202+KEY (t1_name),
1203+PRIMARY KEY (t1_id)
1204+) AUTO_INCREMENT = 1000;
1205+INSERT INTO t1 (t1_name) VALUES('MySQL');
1206+INSERT INTO t1 (t1_name) VALUES('MySQL');
1207+INSERT INTO t1 (t1_name) VALUES('MySQL');
1208+SELECT * from t1;
1209+t1_name t1_id
1210+MySQL 1000
1211+MySQL 1001
1212+MySQL 1002
1213+SHOW CREATE TABLE `t1`;
1214+Table Create Table
1215+t1 CREATE TABLE `t1` (
1216+ `t1_name` varchar(255) DEFAULT NULL,
1217+ `t1_id` int NOT NULL AUTO_INCREMENT,
1218+ PRIMARY KEY (`t1_id`),
1219+ KEY `t1_name` (`t1_name`)
1220+) ENGINE=PBXT
1221+DROP TABLE `t1`;
1222+create table t1(a int not null auto_increment primary key);
1223+create table t2(a int not null auto_increment primary key, t1a int);
1224+insert into t1 values(NULL);
1225+insert into t2 values (NULL, LAST_INSERT_ID()), (NULL, LAST_INSERT_ID());
1226+insert into t1 values (NULL);
1227+insert into t2 values (NULL, LAST_INSERT_ID()), (NULL, LAST_INSERT_ID()),
1228+(NULL, LAST_INSERT_ID());
1229+insert into t1 values (NULL);
1230+insert into t2 values (NULL, LAST_INSERT_ID()), (NULL, LAST_INSERT_ID()),
1231+(NULL, LAST_INSERT_ID()), (NULL, LAST_INSERT_ID());
1232+select * from t2;
1233+a t1a
1234+1 1
1235+2 1
1236+3 2
1237+4 2
1238+5 2
1239+6 3
1240+7 3
1241+8 3
1242+9 3
1243+drop table t1, t2;
1244+End of 4.1 tests
1245+CREATE TABLE t1 ( `a` int NOT NULL auto_increment, `b` int default NULL,PRIMARY KEY (`a`),UNIQUE KEY `b` (`b`));
1246+insert into t1 (b) values (1);
1247+replace into t1 (b) values (2), (1), (3);
1248+select * from t1;
1249+a b
1250+2 2
1251+3 1
1252+4 3
1253+truncate table t1;
1254+insert into t1 (b) values (1);
1255+replace into t1 (b) values (2);
1256+replace into t1 (b) values (1);
1257+replace into t1 (b) values (3);
1258+select * from t1;
1259+a b
1260+2 2
1261+3 1
1262+4 3
1263+drop table t1;
1264+create table t1 (rowid int not null auto_increment, val int not null,primary
1265+key (rowid), unique(val));
1266+replace into t1 (val) values ('1'),('2');
1267+replace into t1 (val) values ('1'),('2');
1268+insert into t1 (val) values ('1'),('2');
1269+ERROR 23000: Duplicate entry '1' for key 'val'
1270+select * from t1;
1271+rowid val
1272+3 1
1273+4 2
1274+drop table t1;
1275+CREATE TABLE t1 (t1 INT PRIMARY KEY, t2 INT);
1276+INSERT INTO t1 VALUES(0, 0);
1277+INSERT INTO t1 VALUES(1, 1);
1278+ALTER TABLE t1 CHANGE t1 t1 INT auto_increment;
1279+INSERT INTO t1 VALUES(0,0);
1280+ERROR 23000: Duplicate entry '0' for key 'PRIMARY'
1281+DROP TABLE t1;
1282+create table t1 (a int primary key auto_increment, b int, c int, d timestamp default current_timestamp, unique(b),unique(c));
1283+insert into t1 values(null,1,1,now());
1284+insert into t1 values(null,0,0,null);
1285+replace into t1 values(null,1,0,null);
1286+select last_insert_id();
1287+last_insert_id()
1288+3
1289+drop table t1;
1290
1291=== added file 'tests/r/pbxt/create.result'
1292--- tests/r/pbxt/create.result 1970-01-01 00:00:00 +0000
1293+++ tests/r/pbxt/create.result 2010-04-05 20:27:29 +0000
1294@@ -0,0 +1,1555 @@
1295+drop table if exists t1,t2,t3,t4,t5;
1296+drop database if exists mysqltest;
1297+create table t1 (b char(0));
1298+insert into t1 values (""),(null);
1299+select * from t1;
1300+b
1301+
1302+NULL
1303+drop table if exists t1;
1304+create table t1 (b char(0) not null);
1305+create table if not exists t1 (b char(0) not null);
1306+Warnings:
1307+Note 1050 Table 't1' already exists
1308+insert into t1 values (""),(null);
1309+ERROR 23000: Column 'b' cannot be null
1310+select * from t1;
1311+b
1312+drop table t1;
1313+create temporary table t1 (a int not null auto_increment,primary key (a)) engine=heap;
1314+drop table t1;
1315+create temporary table t2 engine=heap select * from t1;
1316+ERROR 42S02: Table 'test.t1' doesn't exist
1317+create table t2 select auto+1 from t1;
1318+ERROR 42S02: Table 'test.t1' doesn't exist
1319+drop table if exists t1,t2;
1320+Warnings:
1321+Note 1051 Unknown table 't1'
1322+Note 1051 Unknown table 't2'
1323+create table t1 (b char(0) not null, index(b));
1324+ERROR 42000: The used storage engine can't index column 'b'
1325+create temporary table t1 (a int not null,b text) engine=heap;
1326+ERROR 42000: The used table type doesn't support BLOB/TEXT columns
1327+drop table if exists t1;
1328+Warnings:
1329+Note 1051 Unknown table 't1'
1330+create temporary table t1 (ordid int not null auto_increment, ord varchar(50) not null, primary key (ord,ordid)) engine=heap;
1331+ERROR 42000: Incorrect table definition; there can be only one auto column and it must be defined as a key
1332+create table not_existing_database.test (a int);
1333+ERROR 42000: Unknown database 'not_existing_database'
1334+create table `a/a` (a int);
1335+show create table `a/a`;
1336+Table Create Table
1337+a/a CREATE TABLE `a/a` (
1338+ `a` int DEFAULT NULL
1339+) ENGINE=DEFAULT
1340+create table t1 like `a/a`;
1341+drop table `a/a`;
1342+drop table `t1`;
1343+create table `aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` (aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa int);
1344+ERROR 42000: Incorrect table name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
1345+create table a (`aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` int);
1346+ERROR 42000: Identifier name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' is too long
1347+create table t1 (a datetime default now());
1348+ERROR 42000: Invalid default value for 'a'
1349+create table t1 (a datetime on update now());
1350+ERROR HY000: Invalid ON UPDATE clause for 'a' column
1351+create table t1 (a int default 100 auto_increment);
1352+ERROR 42000: Invalid default value for 'a'
1353+create table t1 (a varchar(5) default 'abcdef');
1354+ERROR 42000: Invalid default value for 'a'
1355+create table t1 (a varchar(5) default 'abcde');
1356+insert into t1 values();
1357+select * from t1;
1358+a
1359+abcde
1360+alter table t1 alter column a set default 'abcdef';
1361+ERROR 42000: Invalid default value for 'a'
1362+drop table t1;
1363+create table 1ea10 (1a20 int,1e int);
1364+insert into 1ea10 values(1,1);
1365+select 1ea10.1a20,1e+ 1e+10 from 1ea10;
1366+1a20 1e+ 1e+10
1367+1 10000000001
1368+drop table 1ea10;
1369+create table t1 (t1.index int);
1370+drop table t1;
1371+drop database if exists mysqltest;
1372+Warnings:
1373+Note 1008 Can't drop database 'mysqltest'; database doesn't exist
1374+create database mysqltest;
1375+create table mysqltest.$test1 (a$1 int, $b int, c$ int);
1376+insert into mysqltest.$test1 values (1,2,3);
1377+select a$1, $b, c$ from mysqltest.$test1;
1378+a$1 $b c$
1379+1 2 3
1380+create table mysqltest.test2$ (a int);
1381+drop table mysqltest.test2$;
1382+drop database mysqltest;
1383+create table `` (a int);
1384+ERROR 42000: Incorrect table name ''
1385+drop table if exists ``;
1386+ERROR 42000: Incorrect table name ''
1387+create table t1 (`` int);
1388+ERROR 42000: Incorrect column name ''
1389+create table t1 (i int, index `` (i));
1390+ERROR 42000: Incorrect index name ''
1391+create table t1 (a int auto_increment not null primary key, B CHAR(20));
1392+insert into t1 (b) values ("hello"),("my"),("world");
1393+create table t2 (key (b)) select * from t1;
1394+explain select * from t2 where b="world";
1395+id select_type table type possible_keys key key_len ref rows Extra
1396+1 SIMPLE t2 ref B B 83 const 1 Using where
1397+select * from t2 where b="world";
1398+a B
1399+3 world
1400+drop table t1,t2;
1401+create table t1(x varchar(50) );
1402+create table t2 select x from t1 where 1=2;
1403+describe t1;
1404+Field Type Null Key Default Extra
1405+x varchar(50) YES NULL
1406+describe t2;
1407+Field Type Null Key Default Extra
1408+x varchar(50) YES NULL
1409+drop table t2;
1410+create table t2 select now() as a , curdate() as c , 1+1 as d , 1.0 + 1 as e , 33333333333333333 + 3 as f;
1411+describe t2;
1412+Field Type Null Key Default Extra
1413+a datetime YES NULL
1414+c date NO NULL
1415+d int NO NULL
1416+e decimal(3,1) NO NULL
1417+f bigint NO NULL
1418+drop table t2;
1419+create table t2 select CAST("2001-12-29" AS DATE) as d, CAST("2001-12-29 20:45:11" AS DATETIME) as dt;
1420+describe t2;
1421+Field Type Null Key Default Extra
1422+d date YES NULL
1423+dt datetime YES NULL
1424+drop table t1,t2;
1425+create table t1 (a int);
1426+create table t2 (a int) select * from t1;
1427+describe t1;
1428+Field Type Null Key Default Extra
1429+a int YES NULL
1430+describe t2;
1431+Field Type Null Key Default Extra
1432+a int YES NULL
1433+drop table if exists t2;
1434+create table t2 (a int, a float) select * from t1;
1435+ERROR 42S21: Duplicate column name 'a'
1436+drop table if exists t2;
1437+Warnings:
1438+Note 1051 Unknown table 't2'
1439+create table t2 (a int) select a as b, a+1 as b from t1;
1440+ERROR 42S21: Duplicate column name 'b'
1441+drop table if exists t2;
1442+Warnings:
1443+Note 1051 Unknown table 't2'
1444+create table t2 (b int) select a as b, a+1 as b from t1;
1445+ERROR 42S21: Duplicate column name 'b'
1446+drop table if exists t1,t2;
1447+Warnings:
1448+Note 1051 Unknown table 't2'
1449+CREATE TABLE t1 (a int not null);
1450+INSERT INTO t1 values (1),(2),(1);
1451+CREATE TABLE t2 (primary key(a)) SELECT * FROM t1;
1452+ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
1453+SELECT * from t2;
1454+ERROR 42S02: Table 'test.t2' doesn't exist
1455+DROP TABLE t1;
1456+DROP TABLE IF EXISTS t2;
1457+Warnings:
1458+Note 1051 Unknown table 't2'
1459+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));
1460+show create table t1;
1461+Table Create Table
1462+t1 CREATE TABLE `t1` (
1463+ `a` int NOT NULL,
1464+ `b` int DEFAULT NULL,
1465+ PRIMARY KEY (`a`),
1466+ KEY `b` (`b`),
1467+ KEY `b_2` (`b`),
1468+ KEY `b_3` (`b`),
1469+ KEY `b_4` (`b`),
1470+ KEY `b_5` (`b`),
1471+ KEY `b_6` (`b`),
1472+ KEY `b_7` (`b`),
1473+ KEY `b_8` (`b`),
1474+ KEY `b_9` (`b`),
1475+ KEY `b_10` (`b`),
1476+ KEY `b_11` (`b`),
1477+ KEY `b_12` (`b`),
1478+ KEY `b_13` (`b`),
1479+ KEY `b_14` (`b`),
1480+ KEY `b_15` (`b`),
1481+ KEY `b_16` (`b`),
1482+ KEY `b_17` (`b`),
1483+ KEY `b_18` (`b`),
1484+ KEY `b_19` (`b`),
1485+ KEY `b_20` (`b`),
1486+ KEY `b_21` (`b`),
1487+ KEY `b_22` (`b`),
1488+ KEY `b_23` (`b`),
1489+ KEY `b_24` (`b`),
1490+ KEY `b_25` (`b`),
1491+ KEY `b_26` (`b`),
1492+ KEY `b_27` (`b`),
1493+ KEY `b_28` (`b`),
1494+ KEY `b_29` (`b`),
1495+ KEY `b_30` (`b`),
1496+ KEY `b_31` (`b`)
1497+) ENGINE=DEFAULT
1498+drop table t1;
1499+create table t1 select if(1,'1','0'), month("2002-08-02");
1500+drop table t1;
1501+create table t1 select if('2002'='2002','Y','N');
1502+select * from t1;
1503+if('2002'='2002','Y','N')
1504+Y
1505+drop table if exists t1;
1506+SET SESSION storage_engine="heap";
1507+SELECT @@storage_engine;
1508+@@storage_engine
1509+MEMORY
1510+CREATE TEMPORARY TABLE t1 (a int not null);
1511+show create table t1;
1512+Table Create Table
1513+t1 CREATE TEMPORARY TABLE `t1` (
1514+ `a` int NOT NULL
1515+) ENGINE=MEMORY
1516+drop table t1;
1517+SET SESSION storage_engine="gemini";
1518+ERROR 42000: Unknown table engine 'gemini'
1519+SELECT @@storage_engine;
1520+@@storage_engine
1521+MEMORY
1522+CREATE TEMPORARY TABLE t1 (a int not null);
1523+show create table t1;
1524+Table Create Table
1525+t1 CREATE TEMPORARY TABLE `t1` (
1526+ `a` int NOT NULL
1527+) ENGINE=MEMORY
1528+SET SESSION storage_engine=default;
1529+drop table t1;
1530+create table t1 ( k1 varchar(2), k2 int, primary key(k1,k2));
1531+insert into t1 values ("a", 1), ("b", 2);
1532+insert into t1 values ("c", NULL);
1533+ERROR 23000: Column 'k2' cannot be null
1534+insert into t1 values (NULL, 3);
1535+ERROR 23000: Column 'k1' cannot be null
1536+insert into t1 values (NULL, NULL);
1537+ERROR 23000: Column 'k1' cannot be null
1538+drop table t1;
1539+create table t1 select x'4132';
1540+drop table t1;
1541+create table t1 select 1,2,3;
1542+create table if not exists t1 select 1,2;
1543+ERROR HY000: Field '1' doesn't have a default value
1544+create table if not exists t1 select 1,2,3,4;
1545+ERROR 21S01: Column count doesn't match value count at row 1
1546+create table if not exists t1 select 1;
1547+ERROR HY000: Field '1' doesn't have a default value
1548+select * from t1;
1549+1 2 3
1550+1 2 3
1551+drop table t1;
1552+flush status;
1553+create table t1 (a int not null, b int, primary key (a));
1554+insert into t1 values (1,1);
1555+select * from t1;
1556+a b
1557+1 1
1558+create table if not exists t1 select 3 as 'a',4 as 'b';
1559+Warnings:
1560+Note 1050 Table 't1' already exists
1561+create table if not exists t1 select 3 as 'a',3 as 'b';
1562+ERROR 23000: Duplicate entry '3' for key 'PRIMARY'
1563+show warnings;
1564+Level Code Message
1565+Note 1050 Table 't1' already exists
1566+Error 1062 Duplicate entry '3' for key 'PRIMARY'
1567+show status like "Opened_tables";
1568+Variable_name Value
1569+Opened_tables 3
1570+select * from t1;
1571+a b
1572+1 1
1573+3 4
1574+drop table t1;
1575+create table `t1 `(a int);
1576+ERROR 42000: Incorrect table name 't1 '
1577+create database `db1 `;
1578+ERROR 42000: Incorrect database name 'db1 '
1579+create table t1(`a ` int);
1580+ERROR 42000: Incorrect column name 'a '
1581+create table t1 (a int,);
1582+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
1583+create table t1 (a int,,b int);
1584+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
1585+create table t1 (,b int);
1586+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
1587+create table t1 (a int, key(a));
1588+create table t2 (b int, foreign key(b) references t1(a), key(b));
1589+drop table if exists t1,t2;
1590+ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails
1591+drop table if exists t2,t1;
1592+Warnings:
1593+Note 1051 Unknown table 't2'
1594+create table t1(id int not null, name char(20));
1595+insert into t1 values(10,'mysql'),(20,'monty- the creator');
1596+create table t2(id int not null);
1597+insert into t2 values(10),(20);
1598+create table t3 like t1;
1599+show create table t3;
1600+Table Create Table
1601+t3 CREATE TABLE `t3` (
1602+ `id` int NOT NULL,
1603+ `name` varchar(20) DEFAULT NULL
1604+) ENGINE=DEFAULT
1605+select * from t3;
1606+id name
1607+create table if not exists t3 like t1;
1608+Warnings:
1609+Note 1050 Table 't3' already exists
1610+select @@warning_count;
1611+@@warning_count
1612+1
1613+create temporary table t3 like t2;
1614+show create table t3;
1615+Table Create Table
1616+t3 CREATE TEMPORARY TABLE `t3` (
1617+ `id` int NOT NULL
1618+) ENGINE=DEFAULT
1619+select * from t3;
1620+id
1621+drop table t3;
1622+show create table t3;
1623+Table Create Table
1624+t3 CREATE TABLE `t3` (
1625+ `id` int NOT NULL,
1626+ `name` varchar(20) DEFAULT NULL
1627+) ENGINE=DEFAULT
1628+select * from t3;
1629+id name
1630+drop table t2, t3;
1631+create database mysqltest;
1632+create table mysqltest.t3 like t1;
1633+create temporary table t3 like mysqltest.t3;
1634+show create table t3;
1635+Table Create Table
1636+t3 CREATE TEMPORARY TABLE `t3` (
1637+ `id` int NOT NULL,
1638+ `name` varchar(20) DEFAULT NULL
1639+) ENGINE=DEFAULT
1640+create table t2 like t3;
1641+show create table t2;
1642+Table Create Table
1643+t2 CREATE TABLE `t2` (
1644+ `id` int NOT NULL,
1645+ `name` varchar(20) DEFAULT NULL
1646+) ENGINE=DEFAULT
1647+select * from t2;
1648+id name
1649+create table t3 like t1;
1650+create table t3 like mysqltest.t3;
1651+ERROR 42S01: Table 't3' already exists
1652+create table non_existing_database.t1 like t1;
1653+ERROR 42000: Unknown database 'non_existing_database'
1654+create table t3 like non_existing_table;
1655+ERROR 42S02: Table 'test.non_existing_table' doesn't exist
1656+create temporary table t3 like t1;
1657+ERROR 42S01: Table 't3' already exists
1658+drop table t1, t2, t3;
1659+drop table t3;
1660+drop database mysqltest;
1661+SET SESSION storage_engine="heap";
1662+SELECT @@storage_engine;
1663+@@storage_engine
1664+MEMORY
1665+CREATE TEMPORARY TABLE t1 (a int not null);
1666+show create table t1;
1667+Table Create Table
1668+t1 CREATE TEMPORARY TABLE `t1` (
1669+ `a` int NOT NULL
1670+) ENGINE=MEMORY
1671+drop table t1;
1672+SET SESSION storage_engine="gemini";
1673+ERROR 42000: Unknown table engine 'gemini'
1674+SELECT @@storage_engine;
1675+@@storage_engine
1676+MEMORY
1677+CREATE TEMPORARY TABLE t1 (a int not null);
1678+show create table t1;
1679+Table Create Table
1680+t1 CREATE TEMPORARY TABLE `t1` (
1681+ `a` int NOT NULL
1682+) ENGINE=MEMORY
1683+SET SESSION storage_engine=default;
1684+drop table t1;
1685+create table t1(a int,b int,c int,d date,e char,f datetime,h blob);
1686+insert into t1(a)values(1);
1687+insert into t1(a,b,c,d,e,f,h)
1688+values(2,-2,2,'1825-12-14','a','2003-01-01 03:02:01','binary data');
1689+select * from t1;
1690+a b c d e f h
1691+1 NULL NULL NULL NULL NULL NULL
1692+2 -2 2 1825-12-14 a 2003-01-01 03:02:01 binary data
1693+select a,
1694+ifnull(b,-7) as b,
1695+ifnull(c,7) as c,
1696+ifnull(d,cast('2000-01-01' as date)) as d,
1697+ifnull(e,cast('b' as char)) as e,
1698+ifnull(f,cast('2000-01-01' as datetime)) as f,
1699+ifnull(h,cast('yet another binary data' as binary)) as h
1700+from t1;
1701+a b c d e f h
1702+1 -7 7 2000-01-01 b 2000-01-01 00:00:00 yet another binary data
1703+2 -2 2 1825-12-14 a 2003-01-01 03:02:01 binary data
1704+create table t2
1705+select
1706+a,
1707+ifnull(b,-7) as b,
1708+ifnull(c,7) as c,
1709+ifnull(d,cast('2000-01-01' as date)) as d,
1710+ifnull(e,cast('b' as char)) as e,
1711+ifnull(f,cast('2000-01-01' as datetime)) as f,
1712+ifnull(h,cast('yet another binary data' as binary)) as h
1713+from t1;
1714+explain t2;
1715+Field Type Null Key Default Extra
1716+a int YES NULL
1717+b bigint NO NULL
1718+c bigint NO NULL
1719+d date YES NULL
1720+e varchar(1) YES NULL
1721+f datetime YES NULL
1722+h blob YES NULL
1723+select * from t2;
1724+a b c d e f h
1725+1 -7 7 2000-01-01 b 2000-01-01 00:00:00 yet another binary data
1726+2 -2 2 1825-12-14 a 2003-01-01 03:02:01 binary data
1727+drop table t1, t2;
1728+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));
1729+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;
1730+show create table t2;
1731+Table Create Table
1732+t2 CREATE TABLE `t2` (
1733+ `ifnull(a,a)` int DEFAULT NULL,
1734+ `ifnull(b,b)` int DEFAULT NULL,
1735+ `ifnull(d,d)` int DEFAULT NULL,
1736+ `ifnull(e,e)` bigint DEFAULT NULL,
1737+ `ifnull(f,f)` double(3,2) DEFAULT NULL,
1738+ `ifnull(g,g)` double(4,3) DEFAULT NULL,
1739+ `ifnull(h,h)` decimal(5,4) DEFAULT NULL,
1740+ `ifnull(j,j)` date DEFAULT NULL,
1741+ `ifnull(k,k)` timestamp NULL DEFAULT NULL,
1742+ `ifnull(l,l)` datetime DEFAULT NULL,
1743+ `ifnull(m,m)` varchar(1) DEFAULT NULL,
1744+ `ifnull(o,o)` varchar(10) DEFAULT NULL
1745+) ENGINE=DEFAULT
1746+drop table t1,t2;
1747+create table t1(str varchar(10) default 'def',strnull varchar(10),intg int default '10',rel double default '3.14');
1748+insert into t1 values ('','',0,0.0);
1749+describe t1;
1750+Field Type Null Key Default Extra
1751+str varchar(10) YES def
1752+strnull varchar(10) YES NULL
1753+intg int YES 10
1754+rel double YES 3.14
1755+create table t2 select default(str) as str, default(strnull) as strnull, default(intg) as intg, default(rel) as rel from t1;
1756+describe t2;
1757+Field Type Null Key Default Extra
1758+str varchar(10) YES NULL
1759+strnull varchar(10) YES NULL
1760+intg int YES NULL
1761+rel double YES NULL
1762+drop table t1, t2;
1763+create table t1(name varchar(10), age int default -1);
1764+describe t1;
1765+Field Type Null Key Default Extra
1766+name varchar(10) YES NULL
1767+age int YES -1
1768+create table t2(name varchar(10), age int default - 1);
1769+describe t2;
1770+Field Type Null Key Default Extra
1771+name varchar(10) YES NULL
1772+age int YES -1
1773+drop table t1, t2;
1774+create table t1(cenum enum('a'));
1775+create table t2(cenum enum('a','a'));
1776+ERROR HY000: Column 'cenum' has duplicated value 'a' in ENUM
1777+create table t3(cenum enum('a','A','a','c','c'));
1778+ERROR HY000: Column 'cenum' has duplicated value 'a' in ENUM
1779+drop table t1;
1780+create database mysqltest;
1781+use mysqltest;
1782+select database();
1783+database()
1784+mysqltest
1785+drop database mysqltest;
1786+select database();
1787+database()
1788+NULL
1789+use test;
1790+CREATE TABLE t1(id varchar(10) NOT NULL PRIMARY KEY, dsc longtext);
1791+INSERT INTO t1 VALUES ('5000000001', NULL),('5000000003', 'Test'),('5000000004', NULL);
1792+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));
1793+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');
1794+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;
1795+SELECT * FROM t3;
1796+dsc countOfRuns
1797+NULL 1
1798+Test 0
1799+NULL 1
1800+drop table t1, t2, t3;
1801+create table t1 (a int);
1802+create table t1 select * from t1;
1803+ERROR HY000: You can't specify target table 't1' for update in FROM clause
1804+flush tables with read lock;
1805+unlock tables;
1806+drop table t1;
1807+create table t1(column.name int);
1808+ERROR 42000: Incorrect table name 'column'
1809+create table t1(test.column.name int);
1810+ERROR 42000: Incorrect table name 'column'
1811+create table t1(xyz.t1.name int);
1812+ERROR 42000: Incorrect database name 'xyz'
1813+create table t1(t1.name int);
1814+create table t2(test.t2.name int);
1815+drop table t1,t2;
1816+CREATE TABLE t1 (f1 VARCHAR(255));
1817+CREATE TABLE t2 AS SELECT LEFT(f1,171) AS f2 FROM t1 UNION SELECT LEFT(f1,171) AS f2 FROM t1;
1818+DESC t2;
1819+Field Type Null Key Default Extra
1820+f2 varchar(171) YES NULL
1821+DROP TABLE t1,t2;
1822+CREATE TABLE t12913 (f1 ENUM ('a','b')) AS SELECT 'a' AS f1;
1823+SELECT * FROM t12913;
1824+f1
1825+a
1826+DROP TABLE t12913;
1827+create database mysqltest;
1828+use mysqltest;
1829+drop database mysqltest;
1830+create table test.t1 like x;
1831+ERROR 3D000: No database selected
1832+drop table if exists test.t1;
1833+create database mysqltest;
1834+create database if not exists mysqltest;
1835+Warnings:
1836+Note 1007 Can't create database 'mysqltest'; database exists
1837+show create database mysqltest;
1838+Database Create Database
1839+mysqltest CREATE DATABASE `mysqltest`
1840+drop database mysqltest;
1841+use test;
1842+create table t1 (a int);
1843+create table if not exists t1 (a int);
1844+Warnings:
1845+Note 1050 Table 't1' already exists
1846+drop table t1;
1847+create table t1 (
1848+a varchar(112) collate utf8_bin not null,
1849+primary key (a)
1850+) select 'test' as a ;
1851+show create table t1;
1852+Table Create Table
1853+t1 CREATE TABLE `t1` (
1854+ `a` varchar(112) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
1855+ PRIMARY KEY (`a`)
1856+) ENGINE=DEFAULT
1857+drop table t1;
1858+CREATE TABLE t2 (
1859+a int default NULL
1860+);
1861+insert into t2 values(111);
1862+create table t1 (
1863+a varchar(12) collate utf8_bin not null,
1864+b int not null, primary key (a)
1865+) select a, 1 as b from t2 ;
1866+show create table t1;
1867+Table Create Table
1868+t1 CREATE TABLE `t1` (
1869+ `a` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
1870+ `b` int NOT NULL,
1871+ PRIMARY KEY (`a`)
1872+) ENGINE=DEFAULT
1873+drop table t1;
1874+create table t1 (
1875+a varchar(12) collate utf8_bin not null,
1876+b int not null, primary key (a)
1877+) select a, 1 as c from t2 ;
1878+ERROR HY000: Field 'b' doesn't have a default value
1879+create table t1 (
1880+a varchar(12) collate utf8_bin not null,
1881+b int null, primary key (a)
1882+) select a, 1 as c from t2 ;
1883+show create table t1;
1884+Table Create Table
1885+t1 CREATE TABLE `t1` (
1886+ `b` int DEFAULT NULL,
1887+ `a` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
1888+ `c` int NOT NULL,
1889+ PRIMARY KEY (`a`)
1890+) ENGINE=DEFAULT
1891+drop table t1;
1892+create table t1 (
1893+a varchar(12) collate utf8_bin not null,
1894+b int not null, primary key (a)
1895+) select 'a' as a , 1 as b from t2 ;
1896+show create table t1;
1897+Table Create Table
1898+t1 CREATE TABLE `t1` (
1899+ `a` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
1900+ `b` int NOT NULL,
1901+ PRIMARY KEY (`a`)
1902+) ENGINE=DEFAULT
1903+drop table t1;
1904+create table t1 (
1905+a varchar(12) collate utf8_bin,
1906+b int not null, primary key (a)
1907+) select 'a' as a , 1 as b from t2 ;
1908+show create table t1;
1909+Table Create Table
1910+t1 CREATE TABLE `t1` (
1911+ `a` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
1912+ `b` int NOT NULL,
1913+ PRIMARY KEY (`a`)
1914+) ENGINE=DEFAULT
1915+drop table t1, t2;
1916+create table t1 (
1917+a1 int not null,
1918+a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int
1919+);
1920+insert into t1 values (1,1,1, 1,1,1, 1,1,1);
1921+create table t2 (
1922+a1 varchar(12) collate utf8_bin not null,
1923+a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int,
1924+primary key (a1)
1925+) select a1,a2,a3,a4,a5,a6,a7,a8,a9 from t1 ;
1926+drop table t2;
1927+create table t2 (
1928+a1 varchar(12) collate utf8_bin,
1929+a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int
1930+) select a1,a2,a3,a4,a5,a6,a7,a8,a9 from t1;
1931+drop table t1, t2;
1932+create table t1 (
1933+a1 int, a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int
1934+);
1935+insert into t1 values (1,1,1, 1,1,1, 1,1,1);
1936+create table t2 (
1937+a1 varchar(12) collate utf8_bin not null,
1938+a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int,
1939+primary key (a1)
1940+) select a1,a2,a3,a4,a5,a6,a7,a8,a9 from t1 ;
1941+drop table t2;
1942+create table t2 ( a int default 3, b int default 3)
1943+select a1,a2 from t1;
1944+show create table t2;
1945+Table Create Table
1946+t2 CREATE TABLE `t2` (
1947+ `a` int DEFAULT '3',
1948+ `b` int DEFAULT '3',
1949+ `a1` int DEFAULT NULL,
1950+ `a2` int DEFAULT NULL
1951+) ENGINE=DEFAULT
1952+drop table t1, t2;
1953+create table t1 select * from t2;
1954+ERROR 42S02: Table 'test.t2' doesn't exist
1955+create table t1 select * from t1;
1956+ERROR HY000: You can't specify target table 't1' for update in FROM clause
1957+create table t1 select coalesce('a' collate utf8_swedish_ci,'b' collate utf8_bin);
1958+ERROR HY000: Illegal mix of collations (utf8_swedish_ci,EXPLICIT) and (utf8_bin,EXPLICIT) for operation 'coalesce'
1959+create table t1 (primary key(a)) select "b" as b;
1960+ERROR 42000: Key column 'a' doesn't exist in table
1961+create table t1 (primary key (a)) (select 1 as a) union all (select 1 as a);
1962+ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
1963+create table t1 (i int);
1964+create table if not exists t1 select 1 as i;
1965+Warnings:
1966+Note 1050 Table 't1' already exists
1967+select * from t1;
1968+i
1969+1
1970+drop table t1;
1971+create table t1 select coalesce('a' collate utf8_swedish_ci,'b' collate utf8_bin);
1972+ERROR HY000: Illegal mix of collations (utf8_swedish_ci,EXPLICIT) and (utf8_bin,EXPLICIT) for operation 'coalesce'
1973+create temporary table t1 (j int);
1974+create table if not exists t1 select 1;
1975+Warnings:
1976+Note 1050 Table 't1' already exists
1977+select * from t1;
1978+j
1979+1
1980+drop temporary table t1;
1981+select * from t1;
1982+ERROR 42S02: Table 'test.t1' doesn't exist
1983+drop table t1;
1984+ERROR 42S02: Unknown table 't1'
1985+create table t1 (upgrade int);
1986+drop table t1;
1987+create table t1 (
1988+c1 int, c2 int, c3 int, c4 int, c5 int, c6 int, c7 int, c8 int,
1989+c9 int, c10 int, c11 int, c12 int, c13 int, c14 int, c15 int, c16 int,
1990+key a001_long_123456789_123456789_123456789_123456789_123456789_1234 (
1991+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
1992+key a002_long_123456789_123456789_123456789_123456789_123456789_1234 (
1993+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
1994+key a003_long_123456789_123456789_123456789_123456789_123456789_1234 (
1995+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
1996+key a004_long_123456789_123456789_123456789_123456789_123456789_1234 (
1997+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
1998+key a005_long_123456789_123456789_123456789_123456789_123456789_1234 (
1999+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2000+key a006_long_123456789_123456789_123456789_123456789_123456789_1234 (
2001+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2002+key a007_long_123456789_123456789_123456789_123456789_123456789_1234 (
2003+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2004+key a008_long_123456789_123456789_123456789_123456789_123456789_1234 (
2005+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2006+key a009_long_123456789_123456789_123456789_123456789_123456789_1234 (
2007+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2008+key a010_long_123456789_123456789_123456789_123456789_123456789_1234 (
2009+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2010+key a011_long_123456789_123456789_123456789_123456789_123456789_1234 (
2011+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2012+key a012_long_123456789_123456789_123456789_123456789_123456789_1234 (
2013+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2014+key a013_long_123456789_123456789_123456789_123456789_123456789_1234 (
2015+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2016+key a014_long_123456789_123456789_123456789_123456789_123456789_1234 (
2017+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2018+key a015_long_123456789_123456789_123456789_123456789_123456789_1234 (
2019+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2020+key a016_long_123456789_123456789_123456789_123456789_123456789_1234 (
2021+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2022+key a017_long_123456789_123456789_123456789_123456789_123456789_1234 (
2023+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2024+key a018_long_123456789_123456789_123456789_123456789_123456789_1234 (
2025+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2026+key a019_long_123456789_123456789_123456789_123456789_123456789_1234 (
2027+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2028+key a020_long_123456789_123456789_123456789_123456789_123456789_1234 (
2029+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2030+key a021_long_123456789_123456789_123456789_123456789_123456789_1234 (
2031+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2032+key a022_long_123456789_123456789_123456789_123456789_123456789_1234 (
2033+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2034+key a023_long_123456789_123456789_123456789_123456789_123456789_1234 (
2035+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2036+key a024_long_123456789_123456789_123456789_123456789_123456789_1234 (
2037+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2038+key a025_long_123456789_123456789_123456789_123456789_123456789_1234 (
2039+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2040+key a026_long_123456789_123456789_123456789_123456789_123456789_1234 (
2041+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2042+key a027_long_123456789_123456789_123456789_123456789_123456789_1234 (
2043+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2044+key a028_long_123456789_123456789_123456789_123456789_123456789_1234 (
2045+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2046+key a029_long_123456789_123456789_123456789_123456789_123456789_1234 (
2047+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2048+key a030_long_123456789_123456789_123456789_123456789_123456789_1234 (
2049+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2050+key a031_long_123456789_123456789_123456789_123456789_123456789_1234 (
2051+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2052+key a032_long_123456789_123456789_123456789_123456789_123456789_1234 (
2053+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2054+key a033_long_123456789_123456789_123456789_123456789_123456789_1234 (
2055+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2056+key a034_long_123456789_123456789_123456789_123456789_123456789_1234 (
2057+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2058+key a035_long_123456789_123456789_123456789_123456789_123456789_1234 (
2059+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2060+key a036_long_123456789_123456789_123456789_123456789_123456789_1234 (
2061+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2062+key a037_long_123456789_123456789_123456789_123456789_123456789_1234 (
2063+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2064+key a038_long_123456789_123456789_123456789_123456789_123456789_1234 (
2065+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2066+key a039_long_123456789_123456789_123456789_123456789_123456789_1234 (
2067+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2068+key a040_long_123456789_123456789_123456789_123456789_123456789_1234 (
2069+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2070+key a041_long_123456789_123456789_123456789_123456789_123456789_1234 (
2071+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2072+key a042_long_123456789_123456789_123456789_123456789_123456789_1234 (
2073+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2074+key a043_long_123456789_123456789_123456789_123456789_123456789_1234 (
2075+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2076+key a044_long_123456789_123456789_123456789_123456789_123456789_1234 (
2077+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2078+key a045_long_123456789_123456789_123456789_123456789_123456789_1234 (
2079+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2080+key a046_long_123456789_123456789_123456789_123456789_123456789_1234 (
2081+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2082+key a047_long_123456789_123456789_123456789_123456789_123456789_1234 (
2083+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2084+key a048_long_123456789_123456789_123456789_123456789_123456789_1234 (
2085+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2086+key a049_long_123456789_123456789_123456789_123456789_123456789_1234 (
2087+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2088+key a050_long_123456789_123456789_123456789_123456789_123456789_1234 (
2089+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2090+key a051_long_123456789_123456789_123456789_123456789_123456789_1234 (
2091+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2092+key a052_long_123456789_123456789_123456789_123456789_123456789_1234 (
2093+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2094+key a053_long_123456789_123456789_123456789_123456789_123456789_1234 (
2095+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2096+key a054_long_123456789_123456789_123456789_123456789_123456789_1234 (
2097+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2098+key a055_long_123456789_123456789_123456789_123456789_123456789_1234 (
2099+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2100+key a056_long_123456789_123456789_123456789_123456789_123456789_1234 (
2101+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2102+key a057_long_123456789_123456789_123456789_123456789_123456789_1234 (
2103+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2104+key a058_long_123456789_123456789_123456789_123456789_123456789_1234 (
2105+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2106+key a059_long_123456789_123456789_123456789_123456789_123456789_1234 (
2107+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2108+key a060_long_123456789_123456789_123456789_123456789_123456789_1234 (
2109+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2110+key a061_long_123456789_123456789_123456789_123456789_123456789_1234 (
2111+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2112+key a062_long_123456789_123456789_123456789_123456789_123456789_1234 (
2113+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2114+key a063_long_123456789_123456789_123456789_123456789_123456789_1234 (
2115+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2116+key a064_long_123456789_123456789_123456789_123456789_123456789_1234 (
2117+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16)
2118+);
2119+show create table t1;
2120+Table Create Table
2121+t1 CREATE TABLE `t1` (
2122+ `c1` int DEFAULT NULL,
2123+ `c2` int DEFAULT NULL,
2124+ `c3` int DEFAULT NULL,
2125+ `c4` int DEFAULT NULL,
2126+ `c5` int DEFAULT NULL,
2127+ `c6` int DEFAULT NULL,
2128+ `c7` int DEFAULT NULL,
2129+ `c8` int DEFAULT NULL,
2130+ `c9` int DEFAULT NULL,
2131+ `c10` int DEFAULT NULL,
2132+ `c11` int DEFAULT NULL,
2133+ `c12` int DEFAULT NULL,
2134+ `c13` int DEFAULT NULL,
2135+ `c14` int DEFAULT NULL,
2136+ `c15` int DEFAULT NULL,
2137+ `c16` int DEFAULT NULL,
2138+ 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`),
2139+ 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`),
2140+ 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`),
2141+ 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`),
2142+ 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`),
2143+ 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`),
2144+ 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`),
2145+ 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`),
2146+ 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`),
2147+ 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`),
2148+ 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`),
2149+ 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`),
2150+ 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`),
2151+ 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`),
2152+ 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`),
2153+ 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`),
2154+ 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`),
2155+ 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`),
2156+ 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`),
2157+ 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`),
2158+ 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`),
2159+ 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`),
2160+ 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`),
2161+ 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`),
2162+ 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`),
2163+ 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`),
2164+ 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`),
2165+ 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`),
2166+ 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`),
2167+ 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`),
2168+ 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`),
2169+ 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`),
2170+ 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`),
2171+ 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`),
2172+ 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`),
2173+ 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`),
2174+ 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`),
2175+ 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`),
2176+ 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`),
2177+ 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`),
2178+ 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`),
2179+ 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`),
2180+ 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`),
2181+ 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`),
2182+ 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`),
2183+ 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`),
2184+ 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`),
2185+ 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`),
2186+ 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`),
2187+ 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`),
2188+ 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`),
2189+ 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`),
2190+ 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`),
2191+ 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`),
2192+ 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`),
2193+ 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`),
2194+ 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`),
2195+ 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`),
2196+ 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`),
2197+ 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`),
2198+ 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`),
2199+ 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`),
2200+ 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`),
2201+ 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`)
2202+) ENGINE=DEFAULT
2203+flush tables;
2204+show create table t1;
2205+Table Create Table
2206+t1 CREATE TABLE `t1` (
2207+ `c1` int DEFAULT NULL,
2208+ `c2` int DEFAULT NULL,
2209+ `c3` int DEFAULT NULL,
2210+ `c4` int DEFAULT NULL,
2211+ `c5` int DEFAULT NULL,
2212+ `c6` int DEFAULT NULL,
2213+ `c7` int DEFAULT NULL,
2214+ `c8` int DEFAULT NULL,
2215+ `c9` int DEFAULT NULL,
2216+ `c10` int DEFAULT NULL,
2217+ `c11` int DEFAULT NULL,
2218+ `c12` int DEFAULT NULL,
2219+ `c13` int DEFAULT NULL,
2220+ `c14` int DEFAULT NULL,
2221+ `c15` int DEFAULT NULL,
2222+ `c16` int DEFAULT NULL,
2223+ 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`),
2224+ 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`),
2225+ 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`),
2226+ 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`),
2227+ 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`),
2228+ 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`),
2229+ 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`),
2230+ 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`),
2231+ 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`),
2232+ 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`),
2233+ 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`),
2234+ 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`),
2235+ 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`),
2236+ 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`),
2237+ 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`),
2238+ 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`),
2239+ 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`),
2240+ 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`),
2241+ 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`),
2242+ 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`),
2243+ 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`),
2244+ 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`),
2245+ 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`),
2246+ 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`),
2247+ 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`),
2248+ 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`),
2249+ 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`),
2250+ 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`),
2251+ 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`),
2252+ 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`),
2253+ 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`),
2254+ 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`),
2255+ 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`),
2256+ 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`),
2257+ 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`),
2258+ 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`),
2259+ 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`),
2260+ 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`),
2261+ 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`),
2262+ 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`),
2263+ 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`),
2264+ 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`),
2265+ 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`),
2266+ 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`),
2267+ 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`),
2268+ 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`),
2269+ 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`),
2270+ 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`),
2271+ 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`),
2272+ 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`),
2273+ 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`),
2274+ 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`),
2275+ 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`),
2276+ 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`),
2277+ 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`),
2278+ 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`),
2279+ 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`),
2280+ 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`),
2281+ 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`),
2282+ 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`),
2283+ 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`),
2284+ 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`),
2285+ 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`),
2286+ 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`)
2287+) ENGINE=DEFAULT
2288+drop table t1;
2289+create table t1 (c1 int, c2 int, c3 int, c4 int, c5 int, c6 int, c7 int,
2290+c8 int, c9 int, c10 int, c11 int, c12 int, c13 int, c14 int, c15 int, c16 int);
2291+alter table t1
2292+add key a001_long_123456789_123456789_123456789_123456789_123456789_1234 (
2293+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2294+add key a002_long_123456789_123456789_123456789_123456789_123456789_1234 (
2295+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2296+add key a003_long_123456789_123456789_123456789_123456789_123456789_1234 (
2297+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2298+add key a004_long_123456789_123456789_123456789_123456789_123456789_1234 (
2299+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2300+add key a005_long_123456789_123456789_123456789_123456789_123456789_1234 (
2301+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2302+add key a006_long_123456789_123456789_123456789_123456789_123456789_1234 (
2303+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2304+add key a007_long_123456789_123456789_123456789_123456789_123456789_1234 (
2305+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2306+add key a008_long_123456789_123456789_123456789_123456789_123456789_1234 (
2307+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2308+add key a009_long_123456789_123456789_123456789_123456789_123456789_1234 (
2309+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2310+add key a010_long_123456789_123456789_123456789_123456789_123456789_1234 (
2311+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2312+add key a011_long_123456789_123456789_123456789_123456789_123456789_1234 (
2313+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2314+add key a012_long_123456789_123456789_123456789_123456789_123456789_1234 (
2315+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2316+add key a013_long_123456789_123456789_123456789_123456789_123456789_1234 (
2317+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2318+add key a014_long_123456789_123456789_123456789_123456789_123456789_1234 (
2319+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2320+add key a015_long_123456789_123456789_123456789_123456789_123456789_1234 (
2321+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2322+add key a016_long_123456789_123456789_123456789_123456789_123456789_1234 (
2323+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2324+add key a017_long_123456789_123456789_123456789_123456789_123456789_1234 (
2325+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2326+add key a018_long_123456789_123456789_123456789_123456789_123456789_1234 (
2327+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2328+add key a019_long_123456789_123456789_123456789_123456789_123456789_1234 (
2329+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2330+add key a020_long_123456789_123456789_123456789_123456789_123456789_1234 (
2331+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2332+add key a021_long_123456789_123456789_123456789_123456789_123456789_1234 (
2333+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2334+add key a022_long_123456789_123456789_123456789_123456789_123456789_1234 (
2335+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2336+add key a023_long_123456789_123456789_123456789_123456789_123456789_1234 (
2337+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2338+add key a024_long_123456789_123456789_123456789_123456789_123456789_1234 (
2339+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2340+add key a025_long_123456789_123456789_123456789_123456789_123456789_1234 (
2341+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2342+add key a026_long_123456789_123456789_123456789_123456789_123456789_1234 (
2343+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2344+add key a027_long_123456789_123456789_123456789_123456789_123456789_1234 (
2345+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2346+add key a028_long_123456789_123456789_123456789_123456789_123456789_1234 (
2347+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2348+add key a029_long_123456789_123456789_123456789_123456789_123456789_1234 (
2349+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2350+add key a030_long_123456789_123456789_123456789_123456789_123456789_1234 (
2351+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2352+add key a031_long_123456789_123456789_123456789_123456789_123456789_1234 (
2353+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2354+add key a032_long_123456789_123456789_123456789_123456789_123456789_1234 (
2355+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2356+add key a033_long_123456789_123456789_123456789_123456789_123456789_1234 (
2357+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2358+add key a034_long_123456789_123456789_123456789_123456789_123456789_1234 (
2359+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2360+add key a035_long_123456789_123456789_123456789_123456789_123456789_1234 (
2361+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2362+add key a036_long_123456789_123456789_123456789_123456789_123456789_1234 (
2363+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2364+add key a037_long_123456789_123456789_123456789_123456789_123456789_1234 (
2365+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2366+add key a038_long_123456789_123456789_123456789_123456789_123456789_1234 (
2367+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2368+add key a039_long_123456789_123456789_123456789_123456789_123456789_1234 (
2369+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2370+add key a040_long_123456789_123456789_123456789_123456789_123456789_1234 (
2371+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2372+add key a041_long_123456789_123456789_123456789_123456789_123456789_1234 (
2373+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2374+add key a042_long_123456789_123456789_123456789_123456789_123456789_1234 (
2375+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2376+add key a043_long_123456789_123456789_123456789_123456789_123456789_1234 (
2377+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2378+add key a044_long_123456789_123456789_123456789_123456789_123456789_1234 (
2379+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2380+add key a045_long_123456789_123456789_123456789_123456789_123456789_1234 (
2381+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2382+add key a046_long_123456789_123456789_123456789_123456789_123456789_1234 (
2383+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2384+add key a047_long_123456789_123456789_123456789_123456789_123456789_1234 (
2385+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2386+add key a048_long_123456789_123456789_123456789_123456789_123456789_1234 (
2387+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2388+add key a049_long_123456789_123456789_123456789_123456789_123456789_1234 (
2389+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2390+add key a050_long_123456789_123456789_123456789_123456789_123456789_1234 (
2391+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2392+add key a051_long_123456789_123456789_123456789_123456789_123456789_1234 (
2393+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2394+add key a052_long_123456789_123456789_123456789_123456789_123456789_1234 (
2395+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2396+add key a053_long_123456789_123456789_123456789_123456789_123456789_1234 (
2397+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2398+add key a054_long_123456789_123456789_123456789_123456789_123456789_1234 (
2399+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2400+add key a055_long_123456789_123456789_123456789_123456789_123456789_1234 (
2401+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2402+add key a056_long_123456789_123456789_123456789_123456789_123456789_1234 (
2403+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2404+add key a057_long_123456789_123456789_123456789_123456789_123456789_1234 (
2405+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2406+add key a058_long_123456789_123456789_123456789_123456789_123456789_1234 (
2407+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2408+add key a059_long_123456789_123456789_123456789_123456789_123456789_1234 (
2409+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2410+add key a060_long_123456789_123456789_123456789_123456789_123456789_1234 (
2411+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2412+add key a061_long_123456789_123456789_123456789_123456789_123456789_1234 (
2413+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2414+add key a062_long_123456789_123456789_123456789_123456789_123456789_1234 (
2415+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2416+add key a063_long_123456789_123456789_123456789_123456789_123456789_1234 (
2417+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),
2418+add key a064_long_123456789_123456789_123456789_123456789_123456789_1234 (
2419+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16);
2420+show create table t1;
2421+Table Create Table
2422+t1 CREATE TABLE `t1` (
2423+ `c1` int DEFAULT NULL,
2424+ `c2` int DEFAULT NULL,
2425+ `c3` int DEFAULT NULL,
2426+ `c4` int DEFAULT NULL,
2427+ `c5` int DEFAULT NULL,
2428+ `c6` int DEFAULT NULL,
2429+ `c7` int DEFAULT NULL,
2430+ `c8` int DEFAULT NULL,
2431+ `c9` int DEFAULT NULL,
2432+ `c10` int DEFAULT NULL,
2433+ `c11` int DEFAULT NULL,
2434+ `c12` int DEFAULT NULL,
2435+ `c13` int DEFAULT NULL,
2436+ `c14` int DEFAULT NULL,
2437+ `c15` int DEFAULT NULL,
2438+ `c16` int DEFAULT NULL,
2439+ 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`),
2440+ 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`),
2441+ 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`),
2442+ 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`),
2443+ 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`),
2444+ 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`),
2445+ 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`),
2446+ 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`),
2447+ 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`),
2448+ 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`),
2449+ 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`),
2450+ 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`),
2451+ 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`),
2452+ 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`),
2453+ 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`),
2454+ 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`),
2455+ 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`),
2456+ 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`),
2457+ 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`),
2458+ 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`),
2459+ 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`),
2460+ 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`),
2461+ 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`),
2462+ 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`),
2463+ 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`),
2464+ 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`),
2465+ 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`),
2466+ 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`),
2467+ 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`),
2468+ 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`),
2469+ 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`),
2470+ 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`),
2471+ 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`),
2472+ 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`),
2473+ 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`),
2474+ 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`),
2475+ 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`),
2476+ 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`),
2477+ 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`),
2478+ 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`),
2479+ 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`),
2480+ 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`),
2481+ 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`),
2482+ 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`),
2483+ 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`),
2484+ 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`),
2485+ 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`),
2486+ 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`),
2487+ 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`),
2488+ 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`),
2489+ 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`),
2490+ 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`),
2491+ 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`),
2492+ 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`),
2493+ 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`),
2494+ 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`),
2495+ 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`),
2496+ 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`),
2497+ 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`),
2498+ 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`),
2499+ 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`),
2500+ 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`),
2501+ 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`),
2502+ 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`)
2503+) ENGINE=DEFAULT
2504+flush tables;
2505+show create table t1;
2506+Table Create Table
2507+t1 CREATE TABLE `t1` (
2508+ `c1` int DEFAULT NULL,
2509+ `c2` int DEFAULT NULL,
2510+ `c3` int DEFAULT NULL,
2511+ `c4` int DEFAULT NULL,
2512+ `c5` int DEFAULT NULL,
2513+ `c6` int DEFAULT NULL,
2514+ `c7` int DEFAULT NULL,
2515+ `c8` int DEFAULT NULL,
2516+ `c9` int DEFAULT NULL,
2517+ `c10` int DEFAULT NULL,
2518+ `c11` int DEFAULT NULL,
2519+ `c12` int DEFAULT NULL,
2520+ `c13` int DEFAULT NULL,
2521+ `c14` int DEFAULT NULL,
2522+ `c15` int DEFAULT NULL,
2523+ `c16` int DEFAULT NULL,
2524+ 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`),
2525+ 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`),
2526+ 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`),
2527+ 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`),
2528+ 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`),
2529+ 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`),
2530+ 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`),
2531+ 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`),
2532+ 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`),
2533+ 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`),
2534+ 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`),
2535+ 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`),
2536+ 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`),
2537+ 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`),
2538+ 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`),
2539+ 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`),
2540+ 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`),
2541+ 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`),
2542+ 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`),
2543+ 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`),
2544+ 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`),
2545+ 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`),
2546+ 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`),
2547+ 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`),
2548+ 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`),
2549+ 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`),
2550+ 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`),
2551+ 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`),
2552+ 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`),
2553+ 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`),
2554+ 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`),
2555+ 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`),
2556+ 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`),
2557+ 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`),
2558+ 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`),
2559+ 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`),
2560+ 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`),
2561+ 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`),
2562+ 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`),
2563+ 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`),
2564+ 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`),
2565+ 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`),
2566+ 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`),
2567+ 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`),
2568+ 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`),
2569+ 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`),
2570+ 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`),
2571+ 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`),
2572+ 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`),
2573+ 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`),
2574+ 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`),
2575+ 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`),
2576+ 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`),
2577+ 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`),
2578+ 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`),
2579+ 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`),
2580+ 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`),
2581+ 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`),
2582+ 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`),
2583+ 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`),
2584+ 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`),
2585+ 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`),
2586+ 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`),
2587+ 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`)
2588+) ENGINE=DEFAULT
2589+alter table t1 add key
2590+a065_long_123456789_123456789_123456789_123456789_123456789_1234 (
2591+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16);
2592+ERROR 42000: Too many keys specified; max 64 keys allowed
2593+drop table t1;
2594+create table t1 (c1 int, c2 int, c3 int, c4 int, c5 int, c6 int, c7 int,
2595+c8 int, c9 int, c10 int, c11 int, c12 int, c13 int, c14 int, c15 int,
2596+c16 int, c17 int);
2597+alter table t1 add key i1 (
2598+c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16, c17);
2599+ERROR 42000: Too many key parts specified; max 16 parts allowed
2600+alter table t1 add key
2601+a001_long_123456789_123456789_123456789_123456789_123456789_12345 (c1);
2602+ERROR 42000: Identifier name 'a001_long_123456789_123456789_123456789_123456789_123456789_12345' is too long
2603+show create table t1;
2604+Table Create Table
2605+t1 CREATE TABLE `t1` (
2606+ `c1` int DEFAULT NULL,
2607+ `c2` int DEFAULT NULL,
2608+ `c3` int DEFAULT NULL,
2609+ `c4` int DEFAULT NULL,
2610+ `c5` int DEFAULT NULL,
2611+ `c6` int DEFAULT NULL,
2612+ `c7` int DEFAULT NULL,
2613+ `c8` int DEFAULT NULL,
2614+ `c9` int DEFAULT NULL,
2615+ `c10` int DEFAULT NULL,
2616+ `c11` int DEFAULT NULL,
2617+ `c12` int DEFAULT NULL,
2618+ `c13` int DEFAULT NULL,
2619+ `c14` int DEFAULT NULL,
2620+ `c15` int DEFAULT NULL,
2621+ `c16` int DEFAULT NULL,
2622+ `c17` int DEFAULT NULL
2623+) ENGINE=DEFAULT
2624+drop table t1;
2625+
2626+Bug #26104 Bug on foreign key class constructor
2627+
2628+Check that ref_columns is initalized correctly in the constructor
2629+and semantic checks in mysql_prepare_table work.
2630+
2631+We do not need a storage engine that supports foreign keys
2632+for this test, as the checks are purely syntax-based, and the
2633+syntax is supported for all engines.
2634+
2635+drop table if exists t1,t2;
2636+create table t1(a int not null, b int not null, primary key (a, b));
2637+create table t2(a int not null, b int not null, c int not null, primary key (a),
2638+foreign key fk_bug26104 (b,c) references t1(a));
2639+ERROR 42000: Incorrect foreign key definition for 'fk_bug26104': Key reference and table reference don't match
2640+drop table t1;
2641+create table t1(f1 int,f2 int);
2642+insert into t1 value(1,1),(1,2),(1,3),(2,1),(2,2),(2,3);
2643+flush status;
2644+create table t2 select sql_big_result f1,count(f2) from t1 group by f1;
2645+show status like 'handler_read%';
2646+Variable_name Value
2647+Handler_read_first 0
2648+Handler_read_key 0
2649+Handler_read_next 0
2650+Handler_read_prev 0
2651+Handler_read_rnd 0
2652+Handler_read_rnd_next 0
2653+drop table t1,t2;
2654+CREATE TABLE t1(c1 VARCHAR(33), KEY USING BTREE (c1));
2655+DROP TABLE t1;
2656+CREATE TABLE t1(c1 VARCHAR(33), KEY (c1) USING BTREE);
2657+DROP TABLE t1;
2658+CREATE TEMPORARY TABLE t1(c1 VARCHAR(33), KEY USING BTREE (c1) USING HASH) ENGINE=MEMORY;
2659+SHOW INDEX FROM t1;
2660+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
2661+t1 1 c1 1 c1 NULL 0 NULL NULL YES HASH
2662+DROP TABLE t1;
2663+CREATE TEMPORARY TABLE t1(c1 VARCHAR(33), KEY USING HASH (c1) USING BTREE) ENGINE=MEMORY;
2664+SHOW INDEX FROM t1;
2665+Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment
2666+t1 1 c1 1 c1 A NULL NULL NULL YES BTREE
2667+DROP TABLE t1;
2668+End of 5.0 tests
2669+CREATE TABLE t1 (a int, b int);
2670+insert into t1 values (1,1),(1,2);
2671+CREATE TABLE t2 (primary key (a)) select * from t1;
2672+ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
2673+drop table if exists t2;
2674+Warnings:
2675+Note 1051 Unknown table 't2'
2676+CREATE TEMPORARY TABLE t2 (primary key (a)) select * from t1;
2677+ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
2678+drop table if exists t2;
2679+Warnings:
2680+Note 1051 Unknown table 't2'
2681+CREATE TEMPORARY TABLE t2 (a int, b int, primary key (a));
2682+CREATE TEMPORARY TABLE IF NOT EXISTS t2 (primary key (a)) select * from t1;
2683+ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
2684+SELECT * from t2;
2685+a b
2686+TRUNCATE table t2;
2687+INSERT INTO t2 select * from t1;
2688+ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
2689+SELECT * from t2;
2690+a b
2691+drop table t1,t2;
2692+CREATE DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
2693+ERROR 42000: Incorrect database name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
2694+DROP DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
2695+ERROR 42000: Incorrect database name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
2696+USE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
2697+ERROR 42000: Incorrect database name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
2698+SHOW CREATE DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;
2699+ERROR 42000: Incorrect database name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'
2700+create database им�_базы_в_кодировке_утф8_длиной_больше_чем_45;
2701+use им�_базы_в_кодировке_утф8_длиной_больше_чем_45;
2702+select database();
2703+database()
2704+им�_базы_в_кодировке_утф8_длиной_больше_чем_45
2705+use test;
2706+select SCHEMA_NAME from information_schema.schemata
2707+where schema_name='им�_базы_в_кодировке_утф8_длиной_больше_чем_45';
2708+SCHEMA_NAME
2709+им�_базы_в_кодировке_утф8_длиной_больше_чем_45
2710+drop database им�_базы_в_кодировке_утф8_длиной_больше_чем_45;
2711+create table им�_таблицы_в_кодировке_утф8_длиной_больше_чем_48
2712+(
2713+им�_пол�_в_кодировке_утф8_длиной_больше_чем_45 int,
2714+index им�_индек�а_в_кодировке_утф8_длиной_больше_чем_48 (им�_пол�_в_кодировке_утф8_длиной_больше_чем_45)
2715+);
2716+select * from им�_таблицы_в_кодировке_утф8_длиной_больше_чем_48;
2717+им�_пол�_в_кодировке_утф8_длиной_больше_чем_45
2718+select TABLE_NAME from information_schema.tables where
2719+table_schema='test';
2720+TABLE_NAME
2721+им�_таблицы_в_кодировке_утф8_длиной_больше_чем_48
2722+select COLUMN_NAME from information_schema.columns where
2723+table_schema='test';
2724+COLUMN_NAME
2725+им�_пол�_в_кодировке_утф8_длиной_больше_чем_45
2726+select INDEX_NAME from information_schema.statistics where
2727+table_schema='test';
2728+INDEX_NAME
2729+им�_индек�а_в_кодировке_утф8_длиной_больше_чем_48
2730+show create table им�_таблицы_в_кодировке_утф8_длиной_больше_чем_48;
2731+Table Create Table
2732+им�_таблицы_в_кодировке_утф8_длиной_больше_чем_48 CREATE TABLE `им�_таблицы_в_кодировке_утф8_длиной_больше_чем_48` (
2733+ `им�_пол�_в_кодировке_утф8_длиной_больше_чем_45` int DEFAULT NULL,
2734+ KEY `им�_индек�а_в_кодировке_утф8_длиной_больше_чем_48` (`им�_пол�_в_кодировке_утф8_длиной_больше_чем_45`)
2735+) ENGINE=DEFAULT
2736+drop table им�_таблицы_в_кодировке_утф8_длиной_больше_чем_48;
2737+create table t1 like information_schema.processlist;
2738+show create table t1;
2739+Table Create Table
2740+t1 CREATE TABLE `t1` (
2741+ `ID` bigint NOT NULL DEFAULT '0',
2742+ `USER` varchar(16) NOT NULL DEFAULT '',
2743+ `HOST` varchar(64) NOT NULL DEFAULT '',
2744+ `DB` varchar(64) DEFAULT NULL,
2745+ `COMMAND` varchar(16) NOT NULL DEFAULT '',
2746+ `TIME` bigint NOT NULL DEFAULT '0',
2747+ `STATE` varchar(64) DEFAULT NULL,
2748+ `INFO` text
2749+) ENGINE=MyISAM
2750+drop table t1;
2751+create temporary table t1 like information_schema.processlist;
2752+show create table t1;
2753+Table Create Table
2754+t1 CREATE TEMPORARY TABLE `t1` (
2755+ `ID` bigint NOT NULL DEFAULT '0',
2756+ `USER` varchar(16) NOT NULL DEFAULT '',
2757+ `HOST` varchar(64) NOT NULL DEFAULT '',
2758+ `DB` varchar(64) DEFAULT NULL,
2759+ `COMMAND` varchar(16) NOT NULL DEFAULT '',
2760+ `TIME` bigint NOT NULL DEFAULT '0',
2761+ `STATE` varchar(64) DEFAULT NULL,
2762+ `INFO` text
2763+) ENGINE=MyISAM
2764+drop table t1;
2765+
2766+# --
2767+# -- Bug#21380: DEFAULT definition not always transfered by CREATE
2768+# -- TABLE/SELECT to the new table.
2769+# --
2770+
2771+DROP TABLE IF EXISTS t1;
2772+DROP TABLE IF EXISTS t2;
2773+
2774+CREATE TABLE t1(
2775+c1 INT DEFAULT 12 COMMENT 'column1',
2776+c2 INT NULL COMMENT 'column2',
2777+c3 INT NOT NULL COMMENT 'column3',
2778+c4 VARCHAR(255) NOT NULL DEFAULT 'a',
2779+c5 VARCHAR(255) COLLATE utf8_unicode_ci NULL DEFAULT 'b',
2780+c6 VARCHAR(255))
2781+COLLATE utf8_bin;
2782+
2783+SHOW CREATE TABLE t1;
2784+Table Create Table
2785+t1 CREATE TABLE `t1` (
2786+ `c1` int DEFAULT '12' COMMENT 'column1',
2787+ `c2` int DEFAULT NULL COMMENT 'column2',
2788+ `c3` int NOT NULL COMMENT 'column3',
2789+ `c4` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'a',
2790+ `c5` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT 'b',
2791+ `c6` varchar(255) COLLATE utf8_bin DEFAULT NULL
2792+) ENGINE=DEFAULT
2793+
2794+CREATE TABLE t2 AS SELECT * FROM t1;
2795+
2796+SHOW CREATE TABLE t2;
2797+Table Create Table
2798+t2 CREATE TABLE `t2` (
2799+ `c1` int DEFAULT '12' COMMENT 'column1',
2800+ `c2` int DEFAULT NULL COMMENT 'column2',
2801+ `c3` int NOT NULL COMMENT 'column3',
2802+ `c4` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'a',
2803+ `c5` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT 'b',
2804+ `c6` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL
2805+) ENGINE=DEFAULT
2806+
2807+DROP TABLE t2;
2808+
2809+# -- End of test case for Bug#21380.
2810+
2811+# --
2812+# -- Bug#18834: ALTER TABLE ADD INDEX on table with two timestamp fields
2813+# --
2814+
2815+DROP TABLE IF EXISTS t1;
2816+DROP TABLE IF EXISTS t2;
2817+DROP TABLE IF EXISTS t3;
2818+
2819+CREATE TABLE t1(c1 TIMESTAMP, c2 TIMESTAMP);
2820+
2821+
2822+CREATE TABLE t2(c1 TIMESTAMP, c2 TIMESTAMP NULL);
2823+drop table t2;
2824+CREATE TABLE t2(c1 TIMESTAMP, c2 TIMESTAMP DEFAULT '1982-01-29');
2825+drop table t2;
2826+
2827+CREATE TABLE t2(c1 TIMESTAMP, c2 TIMESTAMP);
2828+drop table t2;
2829+
2830+# -- Check that NULL column still can be created.
2831+CREATE TABLE t2(c1 TIMESTAMP NULL);
2832+
2833+# -- Check ALTER TABLE.
2834+ALTER TABLE t1 ADD INDEX(c1);
2835+
2836+# -- Check DATETIME.
2837+
2838+CREATE TABLE t3(c1 DATETIME NOT NULL);
2839+INSERT INTO t3 VALUES (0);
2840+ERROR HY000: Received an invalid datetime value '0'.
2841+
2842+ALTER TABLE t3 ADD INDEX(c1);
2843+
2844+# -- Cleanup.
2845+DROP TABLE t1;
2846+DROP TABLE t2;
2847+DROP TABLE t3;
2848+
2849+# -- End of Bug#18834.
2850
2851=== added file 'tests/r/pbxt/csv.result'
2852--- tests/r/pbxt/csv.result 1970-01-01 00:00:00 +0000
2853+++ tests/r/pbxt/csv.result 2010-04-05 20:27:29 +0000
2854@@ -0,0 +1,5112 @@
2855+drop table if exists t1,t2,t3,t4;
2856+CREATE TEMPORARY TABLE t1 (
2857+Period int DEFAULT 0 NOT NULL,
2858+Varor_period int DEFAULT 0 NOT NULL
2859+) ENGINE = CSV;
2860+INSERT INTO t1 VALUES (9410,9412);
2861+select period from t1;
2862+period
2863+9410
2864+select * from t1;
2865+Period Varor_period
2866+9410 9412
2867+select t1.* from t1;
2868+Period Varor_period
2869+9410 9412
2870+CREATE TEMPORARY TABLE t2 (
2871+auto int not null,
2872+fld1 int DEFAULT 0 NOT NULL,
2873+companynr int DEFAULT 0 NOT NULL,
2874+fld3 char(30) DEFAULT '' NOT NULL,
2875+fld4 char(35) DEFAULT '' NOT NULL,
2876+fld5 char(35) DEFAULT '' NOT NULL,
2877+fld6 char(4) DEFAULT '' NOT NULL
2878+) ENGINE = CSV;
2879+select t2.fld3 from t2 where companynr = 58 and fld3 like "%imaginable%";
2880+fld3
2881+imaginable
2882+select fld3 from t2 where fld3 like "%cultivation" ;
2883+fld3
2884+cultivation
2885+select t2.fld3,companynr from t2 where companynr = 57+1 order by fld3;
2886+fld3 companynr
2887+concoct 58
2888+druggists 58
2889+engrossing 58
2890+Eurydice 58
2891+exclaimers 58
2892+ferociousness 58
2893+hopelessness 58
2894+Huey 58
2895+imaginable 58
2896+judges 58
2897+merging 58
2898+ostrich 58
2899+peering 58
2900+Phelps 58
2901+presumes 58
2902+Ruth 58
2903+sentences 58
2904+Shylock 58
2905+straggled 58
2906+synergy 58
2907+thanking 58
2908+tying 58
2909+unlocks 58
2910+select fld3,companynr from t2 where companynr = 58 order by fld3;
2911+fld3 companynr
2912+concoct 58
2913+druggists 58
2914+engrossing 58
2915+Eurydice 58
2916+exclaimers 58
2917+ferociousness 58
2918+hopelessness 58
2919+Huey 58
2920+imaginable 58
2921+judges 58
2922+merging 58
2923+ostrich 58
2924+peering 58
2925+Phelps 58
2926+presumes 58
2927+Ruth 58
2928+sentences 58
2929+Shylock 58
2930+straggled 58
2931+synergy 58
2932+thanking 58
2933+tying 58
2934+unlocks 58
2935+select fld3 from t2 order by fld3 desc limit 10;
2936+fld3
2937+youthfulness
2938+yelped
2939+Wotan
2940+workers
2941+Witt
2942+witchcraft
2943+Winsett
2944+Willy
2945+willed
2946+wildcats
2947+select fld3 from t2 order by fld3 desc limit 5;
2948+fld3
2949+youthfulness
2950+yelped
2951+Wotan
2952+workers
2953+Witt
2954+select fld3 from t2 order by fld3 desc limit 5,5;
2955+fld3
2956+witchcraft
2957+Winsett
2958+Willy
2959+willed
2960+wildcats
2961+UPDATE t2 SET fld3="foo" WHERE fld3="b%";
2962+select fld3 from t2;
2963+fld3
2964+Omaha
2965+breaking
2966+Romans
2967+intercepted
2968+bewilderingly
2969+astound
2970+admonishing
2971+sumac
2972+flanking
2973+combed
2974+subjective
2975+scatterbrain
2976+Eulerian
2977+dubbed
2978+Kane
2979+overlay
2980+perturb
2981+goblins
2982+annihilates
2983+Wotan
2984+snatching
2985+concludes
2986+laterally
2987+yelped
2988+grazing
2989+Baird
2990+celery
2991+misunderstander
2992+handgun
2993+foldout
2994+mystic
2995+succumbed
2996+Nabisco
2997+fingerings
2998+aging
2999+afield
3000+ammonium
3001+boat
3002+intelligibility
3003+Augustine
3004+teethe
3005+dreaded
3006+scholastics
3007+audiology
3008+wallet
3009+parters
3010+eschew
3011+quitter
3012+neat
3013+Steinberg
3014+jarring
3015+tinily
3016+balled
3017+persist
3018+attainments
3019+fanatic
3020+measures
3021+rightfulness
3022+capably
3023+impulsive
3024+starlet
3025+terminators
3026+untying
3027+announces
3028+featherweight
3029+pessimist
3030+daughter
3031+decliner
3032+lawgiver
3033+stated
3034+readable
3035+attrition
3036+cascade
3037+motors
3038+interrogate
3039+pests
3040+stairway
3041+dopers
3042+testicle
3043+Parsifal
3044+leavings
3045+postulation
3046+squeaking
3047+contrasted
3048+leftover
3049+whiteners
3050+erases
3051+Punjab
3052+Merritt
3053+Quixotism
3054+sweetish
3055+dogging
3056+scornfully
3057+bellow
3058+bills
3059+cupboard
3060+sureties
3061+puddings
3062+tapestry
3063+fetters
3064+bivalves
3065+incurring
3066+Adolph
3067+pithed
3068+emergency
3069+Miles
3070+trimmings
3071+tragedies
3072+skulking
3073+flint
3074+flopping
3075+relaxing
3076+offload
3077+suites
3078+lists
3079+animized
3080+multilayer
3081+standardizes
3082+Judas
3083+vacuuming
3084+dentally
3085+humanness
3086+inch
3087+Weissmuller
3088+irresponsibly
3089+luckily
3090+culled
3091+medical
3092+bloodbath
3093+subschema
3094+animals
3095+Micronesia
3096+repetitions
3097+Antares
3098+ventilate
3099+pityingly
3100+interdependent
3101+Graves
3102+neonatal
3103+scribbled
3104+chafe
3105+honoring
3106+realtor
3107+elite
3108+funereal
3109+abrogating
3110+sorters
3111+Conley
3112+lectured
3113+Abraham
3114+Hawaii
3115+cage
3116+hushes
3117+Simla
3118+reporters
3119+Dutchman
3120+descendants
3121+groupings
3122+dissociate
3123+coexist
3124+Beebe
3125+Taoism
3126+Connally
3127+fetched
3128+checkpoints
3129+rusting
3130+galling
3131+obliterates
3132+traitor
3133+resumes
3134+analyzable
3135+terminator
3136+gritty
3137+firearm
3138+minima
3139+Selfridge
3140+disable
3141+witchcraft
3142+betroth
3143+Manhattanize
3144+imprint
3145+peeked
3146+swelling
3147+interrelationships
3148+riser
3149+Gandhian
3150+peacock
3151+bee
3152+kanji
3153+dental
3154+scarf
3155+chasm
3156+insolence
3157+syndicate
3158+alike
3159+imperial
3160+convulsion
3161+railway
3162+validate
3163+normalizes
3164+comprehensive
3165+chewing
3166+denizen
3167+schemer
3168+chronicle
3169+Kline
3170+Anatole
3171+partridges
3172+brunch
3173+recruited
3174+dimensions
3175+Chicana
3176+announced
3177+praised
3178+employing
3179+linear
3180+quagmire
3181+western
3182+relishing
3183+serving
3184+scheduling
3185+lore
3186+eventful
3187+arteriole
3188+disentangle
3189+cured
3190+Fenton
3191+avoidable
3192+drains
3193+detectably
3194+husky
3195+impelling
3196+undoes
3197+evened
3198+squeezes
3199+destroyer
3200+rudeness
3201+beaner
3202+boorish
3203+Everhart
3204+encompass
3205+mushrooms
3206+Alison
3207+externally
3208+pellagra
3209+cult
3210+creek
3211+Huffman
3212+Majorca
3213+governing
3214+gadfly
3215+reassigned
3216+intentness
3217+craziness
3218+psychic
3219+squabbled
3220+burlesque
3221+capped
3222+extracted
3223+DiMaggio
3224+exclamation
3225+subdirectory
3226+fangs
3227+buyer
3228+pithing
3229+transistorizing
3230+nonbiodegradable
3231+dislocate
3232+monochromatic
3233+batting
3234+postcondition
3235+catalog
3236+Remus
3237+devices
3238+bike
3239+qualify
3240+detained
3241+commended
3242+civilize
3243+Elmhurst
3244+anesthetizing
3245+deaf
3246+Brigham
3247+title
3248+coarse
3249+combinations
3250+grayness
3251+innumerable
3252+Caroline
3253+fatty
3254+eastbound
3255+inexperienced
3256+hoarder
3257+scotch
3258+passport
3259+strategic
3260+gated
3261+flog
3262+Pipestone
3263+Dar
3264+Corcoran
3265+flyers
3266+competitions
3267+suppliers
3268+skips
3269+institutes
3270+troop
3271+connective
3272+denies
3273+polka
3274+observations
3275+askers
3276+homeless
3277+Anna
3278+subdirectories
3279+decaying
3280+outwitting
3281+Harpy
3282+crazed
3283+suffocate
3284+provers
3285+technically
3286+Franklinizations
3287+considered
3288+tinnily
3289+uninterruptedly
3290+whistled
3291+automate
3292+gutting
3293+surreptitious
3294+Choctaw
3295+cooks
3296+millivolt
3297+counterpoise
3298+Gothicism
3299+feminine
3300+metaphysically
3301+sanding
3302+contributorily
3303+receivers
3304+adjourn
3305+straggled
3306+druggists
3307+thanking
3308+ostrich
3309+hopelessness
3310+Eurydice
3311+excitation
3312+presumes
3313+imaginable
3314+concoct
3315+peering
3316+Phelps
3317+ferociousness
3318+sentences
3319+unlocks
3320+engrossing
3321+Ruth
3322+tying
3323+exclaimers
3324+synergy
3325+Huey
3326+merging
3327+judges
3328+Shylock
3329+Miltonism
3330+hen
3331+honeybee
3332+towers
3333+dilutes
3334+numerals
3335+democracy
3336+Ibero-
3337+invalids
3338+behavior
3339+accruing
3340+relics
3341+rackets
3342+Fischbein
3343+phony
3344+cross
3345+cleanup
3346+conspirator
3347+label
3348+university
3349+cleansed
3350+ballgown
3351+starlet
3352+aqueous
3353+portrayal
3354+despising
3355+distort
3356+palmed
3357+faced
3358+silverware
3359+assessor
3360+spiders
3361+artificially
3362+reminiscence
3363+Mexican
3364+obnoxious
3365+fragile
3366+apprehensible
3367+births
3368+garages
3369+panty
3370+anteater
3371+displacement
3372+drovers
3373+patenting
3374+far
3375+shrieks
3376+aligning
3377+pragmatism
3378+fevers
3379+reexamines
3380+occupancies
3381+sweats
3382+modulators
3383+demand
3384+Madeira
3385+Viennese
3386+chillier
3387+wildcats
3388+gentle
3389+Angles
3390+accuracies
3391+toggle
3392+Mendelssohn
3393+behaviorally
3394+Rochford
3395+mirror
3396+Modula
3397+clobbering
3398+chronography
3399+Eskimoizeds
3400+British
3401+pitfalls
3402+verify
3403+scatter
3404+Aztecan
3405+acuity
3406+sinking
3407+beasts
3408+Witt
3409+physicists
3410+folksong
3411+strokes
3412+crowder
3413+merry
3414+cadenced
3415+alimony
3416+principled
3417+golfing
3418+undiscovered
3419+irritates
3420+patriots
3421+rooms
3422+towering
3423+displease
3424+photosensitive
3425+inking
3426+gainers
3427+leaning
3428+hydrant
3429+preserve
3430+blinded
3431+interactions
3432+Barry
3433+whiteness
3434+pastimes
3435+Edenization
3436+Muscat
3437+assassinated
3438+labeled
3439+glacial
3440+implied
3441+bibliographies
3442+Buchanan
3443+forgivably
3444+innuendo
3445+den
3446+submarines
3447+mouthful
3448+expiring
3449+unfulfilled
3450+precession
3451+nullified
3452+affects
3453+Cynthia
3454+Chablis
3455+betterments
3456+advertising
3457+rubies
3458+southwest
3459+superstitious
3460+tabernacle
3461+silk
3462+handsomest
3463+Persian
3464+analog
3465+complex
3466+Taoist
3467+suspend
3468+relegated
3469+awesome
3470+Bruxelles
3471+imprecisely
3472+televise
3473+braking
3474+true
3475+disappointing
3476+navally
3477+circus
3478+beetles
3479+trumps
3480+fourscore
3481+Blackfoots
3482+Grady
3483+quiets
3484+floundered
3485+profundity
3486+Garrisonian
3487+Strauss
3488+cemented
3489+contrition
3490+mutations
3491+exhibits
3492+tits
3493+mate
3494+arches
3495+Moll
3496+ropers
3497+bombast
3498+difficultly
3499+adsorption
3500+definiteness
3501+cultivation
3502+heals
3503+Heusen
3504+target
3505+cited
3506+congresswoman
3507+Katherine
3508+titter
3509+aspire
3510+Mardis
3511+Nadia
3512+estimating
3513+stuck
3514+fifteenth
3515+Colombo
3516+survey
3517+staffing
3518+obtain
3519+loaded
3520+slaughtered
3521+lights
3522+circumference
3523+dull
3524+weekly
3525+wetness
3526+visualized
3527+Tannenbaum
3528+moribund
3529+demultiplex
3530+lockings
3531+thugs
3532+unnerves
3533+abut
3534+Chippewa
3535+stratifications
3536+signaled
3537+Italianizes
3538+algorithmic
3539+paranoid
3540+camping
3541+signifying
3542+Patrice
3543+search
3544+Angeles
3545+semblance
3546+taxed
3547+Beatrice
3548+retrace
3549+lockout
3550+grammatic
3551+helmsman
3552+uniform
3553+hamming
3554+disobedience
3555+captivated
3556+transferals
3557+cartographer
3558+aims
3559+Pakistani
3560+burglarized
3561+saucepans
3562+lacerating
3563+corny
3564+megabytes
3565+chancellor
3566+bulk
3567+commits
3568+meson
3569+deputies
3570+northeaster
3571+dipole
3572+machining
3573+therefore
3574+Telefunken
3575+salvaging
3576+Corinthianizes
3577+restlessly
3578+bromides
3579+generalized
3580+mishaps
3581+quelling
3582+spiritual
3583+beguiles
3584+Trobriand
3585+fleeing
3586+Armour
3587+chin
3588+provers
3589+aeronautic
3590+voltage
3591+sash
3592+anaerobic
3593+simultaneous
3594+accumulating
3595+Medusan
3596+shouted
3597+freakish
3598+index
3599+commercially
3600+mistiness
3601+endpoint
3602+straight
3603+flurried
3604+denotative
3605+coming
3606+commencements
3607+gentleman
3608+gifted
3609+Shanghais
3610+sportswriting
3611+sloping
3612+navies
3613+leaflet
3614+shooter
3615+Joplin
3616+babies
3617+subdivision
3618+burstiness
3619+belted
3620+assails
3621+admiring
3622+swaying
3623+Goldstine
3624+fitting
3625+Norwalk
3626+weakening
3627+analogy
3628+deludes
3629+cokes
3630+Clayton
3631+exhausts
3632+causality
3633+sating
3634+icon
3635+throttles
3636+communicants
3637+dehydrate
3638+priceless
3639+publicly
3640+incidentals
3641+commonplace
3642+mumbles
3643+furthermore
3644+cautioned
3645+parametrized
3646+registration
3647+sadly
3648+positioning
3649+babysitting
3650+eternal
3651+hoarder
3652+congregates
3653+rains
3654+workers
3655+sags
3656+unplug
3657+garage
3658+boulder
3659+hollowly
3660+specifics
3661+Teresa
3662+Winsett
3663+convenient
3664+buckboards
3665+amenities
3666+resplendent
3667+priding
3668+configurations
3669+untidiness
3670+Brice
3671+sews
3672+participated
3673+Simon
3674+certificates
3675+Fitzpatrick
3676+Evanston
3677+misted
3678+textures
3679+save
3680+count
3681+rightful
3682+chaperone
3683+Lizzy
3684+clenched
3685+effortlessly
3686+accessed
3687+beaters
3688+Hornblower
3689+vests
3690+indulgences
3691+infallibly
3692+unwilling
3693+excrete
3694+spools
3695+crunches
3696+overestimating
3697+ineffective
3698+humiliation
3699+sophomore
3700+star
3701+rifles
3702+dialysis
3703+arriving
3704+indulge
3705+clockers
3706+languages
3707+Antarctica
3708+percentage
3709+ceiling
3710+specification
3711+regimented
3712+ciphers
3713+pictures
3714+serpents
3715+allot
3716+realized
3717+mayoral
3718+opaquely
3719+hostess
3720+fiftieth
3721+incorrectly
3722+decomposition
3723+stranglings
3724+mixture
3725+electroencephalography
3726+similarities
3727+charges
3728+freest
3729+Greenberg
3730+tinting
3731+expelled
3732+warm
3733+smoothed
3734+deductions
3735+Romano
3736+bitterroot
3737+corset
3738+securing
3739+environing
3740+cute
3741+Crays
3742+heiress
3743+inform
3744+avenge
3745+universals
3746+Kinsey
3747+ravines
3748+bestseller
3749+equilibrium
3750+extents
3751+relatively
3752+pressure
3753+critiques
3754+befouled
3755+rightfully
3756+mechanizing
3757+Latinizes
3758+timesharing
3759+Aden
3760+embassies
3761+males
3762+shapelessly
3763+genres
3764+mastering
3765+Newtonian
3766+finishers
3767+abates
3768+teem
3769+kiting
3770+stodgy
3771+scalps
3772+feed
3773+guitars
3774+airships
3775+store
3776+denounces
3777+Pyle
3778+Saxony
3779+serializations
3780+Peruvian
3781+taxonomically
3782+kingdom
3783+stint
3784+Sault
3785+faithful
3786+Ganymede
3787+tidiness
3788+gainful
3789+contrary
3790+Tipperary
3791+tropics
3792+theorizers
3793+renew
3794+already
3795+terminal
3796+Hegelian
3797+hypothesizer
3798+warningly
3799+journalizing
3800+nested
3801+Lars
3802+saplings
3803+foothill
3804+labeled
3805+imperiously
3806+reporters
3807+furnishings
3808+precipitable
3809+discounts
3810+excises
3811+Stalin
3812+despot
3813+ripeness
3814+Arabia
3815+unruly
3816+mournfulness
3817+boom
3818+slaughter
3819+Sabine
3820+handy
3821+rural
3822+organizer
3823+shipyard
3824+civics
3825+inaccuracy
3826+rules
3827+juveniles
3828+comprised
3829+investigations
3830+stabilizes
3831+seminaries
3832+Hunter
3833+sporty
3834+test
3835+weasels
3836+CERN
3837+tempering
3838+afore
3839+Galatean
3840+techniques
3841+error
3842+veranda
3843+severely
3844+Cassites
3845+forthcoming
3846+guides
3847+vanish
3848+lied
3849+sawtooth
3850+fated
3851+gradually
3852+widens
3853+preclude
3854+Jobrel
3855+hooker
3856+rainstorm
3857+disconnects
3858+cruelty
3859+exponentials
3860+affective
3861+arteries
3862+Crosby
3863+acquaint
3864+evenhandedly
3865+percentage
3866+disobedience
3867+humility
3868+gleaning
3869+petted
3870+bloater
3871+minion
3872+marginal
3873+apiary
3874+measures
3875+precaution
3876+repelled
3877+primary
3878+coverings
3879+Artemia
3880+navigate
3881+spatial
3882+Gurkha
3883+meanwhile
3884+Melinda
3885+Butterfield
3886+Aldrich
3887+previewing
3888+glut
3889+unaffected
3890+inmate
3891+mineral
3892+impending
3893+meditation
3894+ideas
3895+miniaturizes
3896+lewdly
3897+title
3898+youthfulness
3899+creak
3900+Chippewa
3901+clamored
3902+freezes
3903+forgivably
3904+reduce
3905+McGovern
3906+Nazis
3907+epistle
3908+socializes
3909+conceptions
3910+Kevin
3911+uncovering
3912+chews
3913+appendixes
3914+appendixes
3915+appendixes
3916+appendixes
3917+appendixes
3918+appendixes
3919+raining
3920+infest
3921+compartment
3922+minting
3923+ducks
3924+roped
3925+waltz
3926+Lillian
3927+repressions
3928+chillingly
3929+noncritical
3930+lithograph
3931+spongers
3932+parenthood
3933+posed
3934+instruments
3935+filial
3936+fixedly
3937+relives
3938+Pandora
3939+watering
3940+ungrateful
3941+secures
3942+chastisers
3943+icon
3944+reuniting
3945+imagining
3946+abiding
3947+omnisciently
3948+Britannic
3949+scholastics
3950+mechanics
3951+humidly
3952+masterpiece
3953+however
3954+Mendelian
3955+jarred
3956+scolds
3957+infatuate
3958+willed
3959+joyfully
3960+Microsoft
3961+fibrosities
3962+Baltimorean
3963+equestrian
3964+Goodrich
3965+apish
3966+Adlerian
3967+Tropez
3968+nouns
3969+distracting
3970+mutton
3971+bridgeable
3972+stickers
3973+transcontinental
3974+amateurish
3975+Gandhian
3976+stratified
3977+chamberlains
3978+creditably
3979+philosophic
3980+ores
3981+Carleton
3982+tape
3983+afloat
3984+goodness
3985+welcoming
3986+Pinsky
3987+halting
3988+bibliography
3989+decoding
3990+variance
3991+allowed
3992+dire
3993+dub
3994+poisoning
3995+Iraqis
3996+heaving
3997+population
3998+bomb
3999+Majorca
4000+Gershwins
4001+explorers
4002+libretto
4003+occurred
4004+Lagos
4005+rats
4006+bankruptcies
4007+crying
4008+unexpected
4009+accessed
4010+colorful
4011+versatility
4012+cosy
4013+Darius
4014+mastering
4015+Asiaticizations
4016+offerers
4017+uncles
4018+sleepwalk
4019+Ernestine
4020+checksumming
4021+stopped
4022+sicker
4023+Italianization
4024+alphabetic
4025+pharmaceutic
4026+creator
4027+chess
4028+charcoal
4029+Epiphany
4030+bulldozes
4031+Pygmalion
4032+caressing
4033+Palestine
4034+regimented
4035+scars
4036+realest
4037+diffusing
4038+clubroom
4039+Blythe
4040+ahead
4041+reviver
4042+retransmitting
4043+landslide
4044+Eiffel
4045+absentee
4046+aye
4047+forked
4048+Peruvianizes
4049+clerked
4050+tutor
4051+boulevard
4052+shuttered
4053+quotes
4054+Caltech
4055+Mossberg
4056+kept
4057+roundly
4058+features
4059+imaginable
4060+controller
4061+racial
4062+uprisings
4063+narrowed
4064+cannot
4065+vest
4066+famine
4067+sugars
4068+exterminated
4069+belays
4070+Hodges
4071+translatable
4072+duality
4073+recording
4074+rouses
4075+poison
4076+attitude
4077+dusted
4078+encompasses
4079+presentation
4080+Kantian
4081+imprecision
4082+saving
4083+maternal
4084+hewed
4085+kerosene
4086+Cubans
4087+photographers
4088+nymph
4089+bedlam
4090+north
4091+Schoenberg
4092+botany
4093+curs
4094+solidification
4095+inheritresses
4096+stiller
4097+t1
4098+suite
4099+ransomer
4100+Willy
4101+Rena
4102+Seattle
4103+relaxes
4104+exclaim
4105+exclaim
4106+implicated
4107+distinguish
4108+assayed
4109+homeowner
4110+and
4111+stealth
4112+coinciding
4113+founder
4114+environing
4115+jewelry
4116+lemons
4117+brokenness
4118+bedpost
4119+assurers
4120+annoyers
4121+affixed
4122+warbling
4123+seriously
4124+boasted
4125+Chantilly
4126+Iranizes
4127+violinist
4128+extramarital
4129+spates
4130+cloakroom
4131+gazer
4132+hand
4133+tucked
4134+gems
4135+clinker
4136+refiner
4137+callus
4138+leopards
4139+comfortingly
4140+generically
4141+getters
4142+sexually
4143+spear
4144+serums
4145+Italianization
4146+attendants
4147+spies
4148+Anthony
4149+planar
4150+cupped
4151+cleanser
4152+commuters
4153+honeysuckle
4154+orphanage
4155+skies
4156+crushers
4157+Puritan
4158+squeezer
4159+bruises
4160+bonfire
4161+Colombo
4162+nondecreasing
4163+UPDATE t2 SET fld3="bar" WHERE fld3="s%";
4164+select fld3 from t2;
4165+fld3
4166+Omaha
4167+breaking
4168+Romans
4169+intercepted
4170+bewilderingly
4171+astound
4172+admonishing
4173+sumac
4174+flanking
4175+combed
4176+subjective
4177+scatterbrain
4178+Eulerian
4179+dubbed
4180+Kane
4181+overlay
4182+perturb
4183+goblins
4184+annihilates
4185+Wotan
4186+snatching
4187+concludes
4188+laterally
4189+yelped
4190+grazing
4191+Baird
4192+celery
4193+misunderstander
4194+handgun
4195+foldout
4196+mystic
4197+succumbed
4198+Nabisco
4199+fingerings
4200+aging
4201+afield
4202+ammonium
4203+boat
4204+intelligibility
4205+Augustine
4206+teethe
4207+dreaded
4208+scholastics
4209+audiology
4210+wallet
4211+parters
4212+eschew
4213+quitter
4214+neat
4215+Steinberg
4216+jarring
4217+tinily
4218+balled
4219+persist
4220+attainments
4221+fanatic
4222+measures
4223+rightfulness
4224+capably
4225+impulsive
4226+starlet
4227+terminators
4228+untying
4229+announces
4230+featherweight
4231+pessimist
4232+daughter
4233+decliner
4234+lawgiver
4235+stated
4236+readable
4237+attrition
4238+cascade
4239+motors
4240+interrogate
4241+pests
4242+stairway
4243+dopers
4244+testicle
4245+Parsifal
4246+leavings
4247+postulation
4248+squeaking
4249+contrasted
4250+leftover
4251+whiteners
4252+erases
4253+Punjab
4254+Merritt
4255+Quixotism
4256+sweetish
4257+dogging
4258+scornfully
4259+bellow
4260+bills
4261+cupboard
4262+sureties
4263+puddings
4264+tapestry
4265+fetters
4266+bivalves
4267+incurring
4268+Adolph
4269+pithed
4270+emergency
4271+Miles
4272+trimmings
4273+tragedies
4274+skulking
4275+flint
4276+flopping
4277+relaxing
4278+offload
4279+suites
4280+lists
4281+animized
4282+multilayer
4283+standardizes
4284+Judas
4285+vacuuming
4286+dentally
4287+humanness
4288+inch
4289+Weissmuller
4290+irresponsibly
4291+luckily
4292+culled
4293+medical
4294+bloodbath
4295+subschema
4296+animals
4297+Micronesia
4298+repetitions
4299+Antares
4300+ventilate
4301+pityingly
4302+interdependent
4303+Graves
4304+neonatal
4305+scribbled
4306+chafe
4307+honoring
4308+realtor
4309+elite
4310+funereal
4311+abrogating
4312+sorters
4313+Conley
4314+lectured
4315+Abraham
4316+Hawaii
4317+cage
4318+hushes
4319+Simla
4320+reporters
4321+Dutchman
4322+descendants
4323+groupings
4324+dissociate
4325+coexist
4326+Beebe
4327+Taoism
4328+Connally
4329+fetched
4330+checkpoints
4331+rusting
4332+galling
4333+obliterates
4334+traitor
4335+resumes
4336+analyzable
4337+terminator
4338+gritty
4339+firearm
4340+minima
4341+Selfridge
4342+disable
4343+witchcraft
4344+betroth
4345+Manhattanize
4346+imprint
4347+peeked
4348+swelling
4349+interrelationships
4350+riser
4351+Gandhian
4352+peacock
4353+bee
4354+kanji
4355+dental
4356+scarf
4357+chasm
4358+insolence
4359+syndicate
4360+alike
4361+imperial
4362+convulsion
4363+railway
4364+validate
4365+normalizes
4366+comprehensive
4367+chewing
4368+denizen
4369+schemer
4370+chronicle
4371+Kline
4372+Anatole
4373+partridges
4374+brunch
4375+recruited
4376+dimensions
4377+Chicana
4378+announced
4379+praised
4380+employing
4381+linear
4382+quagmire
4383+western
4384+relishing
4385+serving
4386+scheduling
4387+lore
4388+eventful
4389+arteriole
4390+disentangle
4391+cured
4392+Fenton
4393+avoidable
4394+drains
4395+detectably
4396+husky
4397+impelling
4398+undoes
4399+evened
4400+squeezes
4401+destroyer
4402+rudeness
4403+beaner
4404+boorish
4405+Everhart
4406+encompass
4407+mushrooms
4408+Alison
4409+externally
4410+pellagra
4411+cult
4412+creek
4413+Huffman
4414+Majorca
4415+governing
4416+gadfly
4417+reassigned
4418+intentness
4419+craziness
4420+psychic
4421+squabbled
4422+burlesque
4423+capped
4424+extracted
4425+DiMaggio
4426+exclamation
4427+subdirectory
4428+fangs
4429+buyer
4430+pithing
4431+transistorizing
4432+nonbiodegradable
4433+dislocate
4434+monochromatic
4435+batting
4436+postcondition
4437+catalog
4438+Remus
4439+devices
4440+bike
4441+qualify
4442+detained
4443+commended
4444+civilize
4445+Elmhurst
4446+anesthetizing
4447+deaf
4448+Brigham
4449+title
4450+coarse
4451+combinations
4452+grayness
4453+innumerable
4454+Caroline
4455+fatty
4456+eastbound
4457+inexperienced
4458+hoarder
4459+scotch
4460+passport
4461+strategic
4462+gated
4463+flog
4464+Pipestone
4465+Dar
4466+Corcoran
4467+flyers
4468+competitions
4469+suppliers
4470+skips
4471+institutes
4472+troop
4473+connective
4474+denies
4475+polka
4476+observations
4477+askers
4478+homeless
4479+Anna
4480+subdirectories
4481+decaying
4482+outwitting
4483+Harpy
4484+crazed
4485+suffocate
4486+provers
4487+technically
4488+Franklinizations
4489+considered
4490+tinnily
4491+uninterruptedly
4492+whistled
4493+automate
4494+gutting
4495+surreptitious
4496+Choctaw
4497+cooks
4498+millivolt
4499+counterpoise
4500+Gothicism
4501+feminine
4502+metaphysically
4503+sanding
4504+contributorily
4505+receivers
4506+adjourn
4507+straggled
4508+druggists
4509+thanking
4510+ostrich
4511+hopelessness
4512+Eurydice
4513+excitation
4514+presumes
4515+imaginable
4516+concoct
4517+peering
4518+Phelps
4519+ferociousness
4520+sentences
4521+unlocks
4522+engrossing
4523+Ruth
4524+tying
4525+exclaimers
4526+synergy
4527+Huey
4528+merging
4529+judges
4530+Shylock
4531+Miltonism
4532+hen
4533+honeybee
4534+towers
4535+dilutes
4536+numerals
4537+democracy
4538+Ibero-
4539+invalids
4540+behavior
4541+accruing
4542+relics
4543+rackets
4544+Fischbein
4545+phony
4546+cross
4547+cleanup
4548+conspirator
4549+label
4550+university
4551+cleansed
4552+ballgown
4553+starlet
4554+aqueous
4555+portrayal
4556+despising
4557+distort
4558+palmed
4559+faced
4560+silverware
4561+assessor
4562+spiders
4563+artificially
4564+reminiscence
4565+Mexican
4566+obnoxious
4567+fragile
4568+apprehensible
4569+births
4570+garages
4571+panty
4572+anteater
4573+displacement
4574+drovers
4575+patenting
4576+far
4577+shrieks
4578+aligning
4579+pragmatism
4580+fevers
4581+reexamines
4582+occupancies
4583+sweats
4584+modulators
4585+demand
4586+Madeira
4587+Viennese
4588+chillier
4589+wildcats
4590+gentle
4591+Angles
4592+accuracies
4593+toggle
4594+Mendelssohn
4595+behaviorally
4596+Rochford
4597+mirror
4598+Modula
4599+clobbering
4600+chronography
4601+Eskimoizeds
4602+British
4603+pitfalls
4604+verify
4605+scatter
4606+Aztecan
4607+acuity
4608+sinking
4609+beasts
4610+Witt
4611+physicists
4612+folksong
4613+strokes
4614+crowder
4615+merry
4616+cadenced
4617+alimony
4618+principled
4619+golfing
4620+undiscovered
4621+irritates
4622+patriots
4623+rooms
4624+towering
4625+displease
4626+photosensitive
4627+inking
4628+gainers
4629+leaning
4630+hydrant
4631+preserve
4632+blinded
4633+interactions
4634+Barry
4635+whiteness
4636+pastimes
4637+Edenization
4638+Muscat
4639+assassinated
4640+labeled
4641+glacial
4642+implied
4643+bibliographies
4644+Buchanan
4645+forgivably
4646+innuendo
4647+den
4648+submarines
4649+mouthful
4650+expiring
4651+unfulfilled
4652+precession
4653+nullified
4654+affects
4655+Cynthia
4656+Chablis
4657+betterments
4658+advertising
4659+rubies
4660+southwest
4661+superstitious
4662+tabernacle
4663+silk
4664+handsomest
4665+Persian
4666+analog
4667+complex
4668+Taoist
4669+suspend
4670+relegated
4671+awesome
4672+Bruxelles
4673+imprecisely
4674+televise
4675+braking
4676+true
4677+disappointing
4678+navally
4679+circus
4680+beetles
4681+trumps
4682+fourscore
4683+Blackfoots
4684+Grady
4685+quiets
4686+floundered
4687+profundity
4688+Garrisonian
4689+Strauss
4690+cemented
4691+contrition
4692+mutations
4693+exhibits
4694+tits
4695+mate
4696+arches
4697+Moll
4698+ropers
4699+bombast
4700+difficultly
4701+adsorption
4702+definiteness
4703+cultivation
4704+heals
4705+Heusen
4706+target
4707+cited
4708+congresswoman
4709+Katherine
4710+titter
4711+aspire
4712+Mardis
4713+Nadia
4714+estimating
4715+stuck
4716+fifteenth
4717+Colombo
4718+survey
4719+staffing
4720+obtain
4721+loaded
4722+slaughtered
4723+lights
4724+circumference
4725+dull
4726+weekly
4727+wetness
4728+visualized
4729+Tannenbaum
4730+moribund
4731+demultiplex
4732+lockings
4733+thugs
4734+unnerves
4735+abut
4736+Chippewa
4737+stratifications
4738+signaled
4739+Italianizes
4740+algorithmic
4741+paranoid
4742+camping
4743+signifying
4744+Patrice
4745+search
4746+Angeles
4747+semblance
4748+taxed
4749+Beatrice
4750+retrace
4751+lockout
4752+grammatic
4753+helmsman
4754+uniform
4755+hamming
4756+disobedience
4757+captivated
4758+transferals
4759+cartographer
4760+aims
4761+Pakistani
4762+burglarized
4763+saucepans
4764+lacerating
4765+corny
4766+megabytes
4767+chancellor
4768+bulk
4769+commits
4770+meson
4771+deputies
4772+northeaster
4773+dipole
4774+machining
4775+therefore
4776+Telefunken
4777+salvaging
4778+Corinthianizes
4779+restlessly
4780+bromides
4781+generalized
4782+mishaps
4783+quelling
4784+spiritual
4785+beguiles
4786+Trobriand
4787+fleeing
4788+Armour
4789+chin
4790+provers
4791+aeronautic
4792+voltage
4793+sash
4794+anaerobic
4795+simultaneous
4796+accumulating
4797+Medusan
4798+shouted
4799+freakish
4800+index
4801+commercially
4802+mistiness
4803+endpoint
4804+straight
4805+flurried
4806+denotative
4807+coming
4808+commencements
4809+gentleman
4810+gifted
4811+Shanghais
4812+sportswriting
4813+sloping
4814+navies
4815+leaflet
4816+shooter
4817+Joplin
4818+babies
4819+subdivision
4820+burstiness
4821+belted
4822+assails
4823+admiring
4824+swaying
4825+Goldstine
4826+fitting
4827+Norwalk
4828+weakening
4829+analogy
4830+deludes
4831+cokes
4832+Clayton
4833+exhausts
4834+causality
4835+sating
4836+icon
4837+throttles
4838+communicants
4839+dehydrate
4840+priceless
4841+publicly
4842+incidentals
4843+commonplace
4844+mumbles
4845+furthermore
4846+cautioned
4847+parametrized
4848+registration
4849+sadly
4850+positioning
4851+babysitting
4852+eternal
4853+hoarder
4854+congregates
4855+rains
4856+workers
4857+sags
4858+unplug
4859+garage
4860+boulder
4861+hollowly
4862+specifics
4863+Teresa
4864+Winsett
4865+convenient
4866+buckboards
4867+amenities
4868+resplendent
4869+priding
4870+configurations
4871+untidiness
4872+Brice
4873+sews
4874+participated
4875+Simon
4876+certificates
4877+Fitzpatrick
4878+Evanston
4879+misted
4880+textures
4881+save
4882+count
4883+rightful
4884+chaperone
4885+Lizzy
4886+clenched
4887+effortlessly
4888+accessed
4889+beaters
4890+Hornblower
4891+vests
4892+indulgences
4893+infallibly
4894+unwilling
4895+excrete
4896+spools
4897+crunches
4898+overestimating
4899+ineffective
4900+humiliation
4901+sophomore
4902+star
4903+rifles
4904+dialysis
4905+arriving
4906+indulge
4907+clockers
4908+languages
4909+Antarctica
4910+percentage
4911+ceiling
4912+specification
4913+regimented
4914+ciphers
4915+pictures
4916+serpents
4917+allot
4918+realized
4919+mayoral
4920+opaquely
4921+hostess
4922+fiftieth
4923+incorrectly
4924+decomposition
4925+stranglings
4926+mixture
4927+electroencephalography
4928+similarities
4929+charges
4930+freest
4931+Greenberg
4932+tinting
4933+expelled
4934+warm
4935+smoothed
4936+deductions
4937+Romano
4938+bitterroot
4939+corset
4940+securing
4941+environing
4942+cute
4943+Crays
4944+heiress
4945+inform
4946+avenge
4947+universals
4948+Kinsey
4949+ravines
4950+bestseller
4951+equilibrium
4952+extents
4953+relatively
4954+pressure
4955+critiques
4956+befouled
4957+rightfully
4958+mechanizing
4959+Latinizes
4960+timesharing
4961+Aden
4962+embassies
4963+males
4964+shapelessly
4965+genres
4966+mastering
4967+Newtonian
4968+finishers
4969+abates
4970+teem
4971+kiting
4972+stodgy
4973+scalps
4974+feed
4975+guitars
4976+airships
4977+store
4978+denounces
4979+Pyle
4980+Saxony
4981+serializations
4982+Peruvian
4983+taxonomically
4984+kingdom
4985+stint
4986+Sault
4987+faithful
4988+Ganymede
4989+tidiness
4990+gainful
4991+contrary
4992+Tipperary
4993+tropics
4994+theorizers
4995+renew
4996+already
4997+terminal
4998+Hegelian
4999+hypothesizer
5000+warningly
The diff has been truncated for viewing.