~drizzle-trunk/drizzle/development : revision 1455.3.1

1

drop table if exists t1,t2,t3,t4,t5;

2

drop database if exists mysqltest;

3

create table t1 (b char(0));

4

insert into t1 values (""),(null);

5

select * from t1;

6

b

7

8

NULL

9

drop table if exists t1;

10

create table t1 (b char(0) not null);

11

create table if not exists t1 (b char(0) not null);

12

Warnings:

13

Note 1050 Table 't1' already exists

14

insert into t1 values (""),(null);

15

ERROR 23000: Column 'b' cannot be null

16

select * from t1;

17

b

18

drop table t1;

19

create temporary table t1 (a int not null auto_increment,primary key (a)) engine=heap;

20

drop table t1;

21

create temporary table t2 engine=heap select * from t1;

22

ERROR 42S02: Table 'test.t1' doesn't exist

23

create table t2 select auto+1 from t1;

24

ERROR 42S02: Table 'test.t1' doesn't exist

25

drop table if exists t1,t2;

26

Warnings:

27

Note 1051 Unknown table 't1'

28

Note 1051 Unknown table 't2'

29

create table t1 (b char(0) not null, index(b));

30

ERROR 42000: The used storage engine can't index column 'b'

31

create temporary table t1 (a int not null,b text) engine=heap;

32

ERROR 42000: The used table type doesn't support BLOB/TEXT columns

33

drop table if exists t1;

34

Warnings:

35

Note 1051 Unknown table 't1'

36

create temporary table t1 (ordid int not null auto_increment, ord varchar(50) not null, primary key (ord,ordid)) engine=heap;

37

ERROR 42000: Incorrect table definition; there can be only one auto column and it must be defined as a key

38

create table not_existing_database.test (a int);

39

ERROR 42000: Unknown database 'not_existing_database'

40

create table `a/a` (a int);

41

show create table `a/a`;

42

Table Create Table

43

a/a CREATE TABLE `a/a` (

44

`a` int DEFAULT NULL

45

) ENGINE=DEFAULT

46

create table t1 like `a/a`;

47

drop table `a/a`;

48

drop table `t1`;

49

create table `aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` (aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa int);

50

ERROR 42000: Incorrect table name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

51

create table a (`aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa` int);

52

ERROR 42000: Identifier name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' is too long

53

create table t1 (a datetime default now());

54

ERROR 42000: Invalid default value for 'a'

55

create table t1 (a datetime on update now());

56

ERROR HY000: Invalid ON UPDATE clause for 'a' column

57

create table t1 (a int default 100 auto_increment);

58

ERROR 42000: Invalid default value for 'a'

59

create table t1 (a varchar(5) default 'abcdef');

60

ERROR 42000: Invalid default value for 'a'

61

create table t1 (a varchar(5) default 'abcde');

62

insert into t1 values();

63

select * from t1;

64

a

65

abcde

66

alter table t1 alter column a set default 'abcdef';

67

ERROR 42000: Invalid default value for 'a'

68

drop table t1;

69

create table 1ea10 (1a20 int,1e int);

70

insert into 1ea10 values(1,1);

71

select 1ea10.1a20,1e+ 1e+10 from 1ea10;

72

1a20 1e+ 1e+10

73

1 10000000001

74

drop table 1ea10;

75

create table t1 (t1.index int);

76

drop table t1;

77

drop database if exists mysqltest;

78

Warnings:

79

Note 1008 Can't drop database 'mysqltest'; database doesn't exist

80

create database mysqltest;

81

create table mysqltest.$test1 (a$1 int, $b int, c$ int);

82

insert into mysqltest.$test1 values (1,2,3);

83

select a$1, $b, c$ from mysqltest.$test1;

84

a$1 $b c$

85

1 2 3

86

create table mysqltest.test2$ (a int);

87

drop table mysqltest.test2$;

88

drop database mysqltest;

89

create table `` (a int);

90

ERROR 42000: Incorrect table name ''

91

drop table if exists ``;

92

ERROR 42000: Incorrect table name ''

93

create table t1 (`` int);

94

ERROR 42000: Incorrect column name ''

95

create table t1 (i int, index `` (i));

96

ERROR 42000: Incorrect index name ''

97

create table t1 (a int auto_increment not null primary key, B CHAR(20));

98

insert into t1 (b) values ("hello"),("my"),("world");

99

create table t2 (key (b)) select * from t1;

100

explain select * from t2 where b="world";

101

id select_type table type possible_keys key key_len ref rows Extra

102

1 SIMPLE t2 ref B B 83 const 1 Using where

103

select * from t2 where b="world";

104

a B

105

3 world

106

drop table t1,t2;

107

create table t1(x varchar(50) );

108

create table t2 select x from t1 where 1=2;

109

describe t1;

110

Field Type Null Key Default Extra

111

x varchar(50) YES NULL

112

describe t2;

113

Field Type Null Key Default Extra

114

x varchar(50) YES NULL

115

drop table t2;

116

create table t2 select now() as a , curdate() as c , 1+1 as d , 1.0 + 1 as e , 33333333333333333 + 3 as f;

117

describe t2;

118

Field Type Null Key Default Extra

119

a datetime YES NULL

120

c date NO NULL

121

d int NO NULL

122

e decimal(3,1) NO NULL

123

f bigint NO NULL

124

drop table t2;

125

create table t2 select CAST("2001-12-29" AS DATE) as d, CAST("2001-12-29 20:45:11" AS DATETIME) as dt;

126

describe t2;

127

Field Type Null Key Default Extra

128

d date YES NULL

129

dt datetime YES NULL

130

drop table t1,t2;

131

create table t1 (a int);

132

create table t2 (a int) select * from t1;

133

describe t1;

134

Field Type Null Key Default Extra

135

a int YES NULL

136

describe t2;

137

Field Type Null Key Default Extra

138

a int YES NULL

139

drop table if exists t2;

140

create table t2 (a int, a float) select * from t1;

141

ERROR 42S21: Duplicate column name 'a'

142

drop table if exists t2;

143

Warnings:

144

Note 1051 Unknown table 't2'

145

create table t2 (a int) select a as b, a+1 as b from t1;

146

ERROR 42S21: Duplicate column name 'b'

147

drop table if exists t2;

148

Warnings:

149

Note 1051 Unknown table 't2'

150

create table t2 (b int) select a as b, a+1 as b from t1;

151

ERROR 42S21: Duplicate column name 'b'

152

drop table if exists t1,t2;

153

Warnings:

154

Note 1051 Unknown table 't2'

155

CREATE TABLE t1 (a int not null);

156

INSERT INTO t1 values (1),(2),(1);

157

CREATE TABLE t2 (primary key(a)) SELECT * FROM t1;

158

ERROR 23000: Duplicate entry '1' for key 'PRIMARY'

159

SELECT * from t2;

160

ERROR 42S02: Table 'test.t2' doesn't exist

161

DROP TABLE t1;

162

DROP TABLE IF EXISTS t2;

163

Warnings:

164

Note 1051 Unknown table 't2'

165

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));

166

show create table t1;

167

Table Create Table

168

t1 CREATE TABLE `t1` (

169

`a` int NOT NULL,

170

`b` int DEFAULT NULL,

171

PRIMARY KEY (`a`),

172

KEY `b` (`b`),

173

KEY `b_2` (`b`),

174

KEY `b_3` (`b`),

175

KEY `b_4` (`b`),

176

KEY `b_5` (`b`),

177

KEY `b_6` (`b`),

178

KEY `b_7` (`b`),

179

KEY `b_8` (`b`),

180

KEY `b_9` (`b`),

181

KEY `b_10` (`b`),

182

KEY `b_11` (`b`),

183

KEY `b_12` (`b`),

184

KEY `b_13` (`b`),

185

KEY `b_14` (`b`),

186

KEY `b_15` (`b`),

187

KEY `b_16` (`b`),

188

KEY `b_17` (`b`),

189

KEY `b_18` (`b`),

190

KEY `b_19` (`b`),

191

KEY `b_20` (`b`),

192

KEY `b_21` (`b`),

193

KEY `b_22` (`b`),

194

KEY `b_23` (`b`),

195

KEY `b_24` (`b`),

196

KEY `b_25` (`b`),

197

KEY `b_26` (`b`),

198

KEY `b_27` (`b`),

199

KEY `b_28` (`b`),

200

KEY `b_29` (`b`),

201

KEY `b_30` (`b`),

202

KEY `b_31` (`b`)

203

) ENGINE=DEFAULT

204

drop table t1;

205

create table t1 select if(1,'1','0'), month("2002-08-02");

206

drop table t1;

207

create table t1 select if('2002'='2002','Y','N');

208

select * from t1;

209

if('2002'='2002','Y','N')

210

Y

211

drop table if exists t1;

212

SET SESSION storage_engine="heap";

213

SELECT @@storage_engine;

214

@@storage_engine

215

MEMORY

216

CREATE TEMPORARY TABLE t1 (a int not null);

217

show create table t1;

218

Table Create Table

219

t1 CREATE TEMPORARY TABLE `t1` (

220

`a` int NOT NULL

221

) ENGINE=MEMORY

222

drop table t1;

223

SET SESSION storage_engine="gemini";

224

ERROR 42000: Unknown table engine 'gemini'

225

SELECT @@storage_engine;

226

@@storage_engine

227

MEMORY

228

CREATE TEMPORARY TABLE t1 (a int not null);

229

show create table t1;

230

Table Create Table

231

t1 CREATE TEMPORARY TABLE `t1` (

232

`a` int NOT NULL

233

) ENGINE=MEMORY

234

SET SESSION storage_engine=default;

235

drop table t1;

236

create table t1 ( k1 varchar(2), k2 int, primary key(k1,k2));

237

insert into t1 values ("a", 1), ("b", 2);

238

insert into t1 values ("c", NULL);

239

ERROR 23000: Column 'k2' cannot be null

240

insert into t1 values (NULL, 3);

241

ERROR 23000: Column 'k1' cannot be null

242

insert into t1 values (NULL, NULL);

243

ERROR 23000: Column 'k1' cannot be null

244

drop table t1;

245

create table t1 select x'4132';

246

drop table t1;

247

create table t1 select 1,2,3;

248

create table if not exists t1 select 1,2;

249

ERROR HY000: Field '1' doesn't have a default value

250

create table if not exists t1 select 1,2,3,4;

251

ERROR 21S01: Column count doesn't match value count at row 1

252

create table if not exists t1 select 1;

253

ERROR HY000: Field '1' doesn't have a default value

254

select * from t1;

255

1 2 3

256

1 2 3

257

drop table t1;

258

flush status;

259

create table t1 (a int not null, b int, primary key (a));

260

insert into t1 values (1,1);

261

select * from t1;

262

a b

263

1 1

264

create table if not exists t1 select 3 as 'a',4 as 'b';

265

Warnings:

266

Note 1050 Table 't1' already exists

267

create table if not exists t1 select 3 as 'a',3 as 'b';

268

ERROR 23000: Duplicate entry '3' for key 'PRIMARY'

269

show warnings;

270

Level Code Message

271

Note 1050 Table 't1' already exists

272

Error 1062 Duplicate entry '3' for key 'PRIMARY'

273

show status like "Opened_tables";

274

Variable_name Value

275

Opened_tables 3

276

select * from t1;

277

a b

278

1 1

279

3 4

280

drop table t1;

281

create table `t1 `(a int);

282

ERROR 42000: Incorrect table name 't1 '

283

create database `db1 `;

284

ERROR 42000: Incorrect database name 'db1 '

285

create table t1(`a ` int);

286

ERROR 42000: Incorrect column name 'a '

287

create table t1 (a int,);

288

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

289

create table t1 (a int,,b int);

290

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

291

create table t1 (,b int);

292

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

293

create table t1 (a int, key(a));

294

create table t2 (b int, foreign key(b) references t1(a), key(b));

295

drop table if exists t1,t2;

296

ERROR 23000: Cannot delete or update a parent row: a foreign key constraint fails

297

drop table if exists t2,t1;

298

Warnings:

299

Note 1051 Unknown table 't2'

300

create table t1(id int not null, name char(20));

301

insert into t1 values(10,'mysql'),(20,'monty- the creator');

302

create table t2(id int not null);

303

insert into t2 values(10),(20);

304

create table t3 like t1;

305

show create table t3;

306

Table Create Table

307

t3 CREATE TABLE `t3` (

308

`id` int NOT NULL,

309

`name` varchar(20) DEFAULT NULL

310

) ENGINE=DEFAULT

311

select * from t3;

312

id name

313

create table if not exists t3 like t1;

314

Warnings:

315

Note 1050 Table 't3' already exists

316

select @@warning_count;

317

@@warning_count

318

1

319

create temporary table t3 like t2;

320

show create table t3;

321

Table Create Table

322

t3 CREATE TEMPORARY TABLE `t3` (

323

`id` int NOT NULL

324

) ENGINE=DEFAULT

325

select * from t3;

326

id

327

drop table t3;

328

show create table t3;

329

Table Create Table

330

t3 CREATE TABLE `t3` (

331

`id` int NOT NULL,

332

`name` varchar(20) DEFAULT NULL

333

) ENGINE=DEFAULT

334

select * from t3;

335

id name

336

drop table t2, t3;

337

create database mysqltest;

338

create table mysqltest.t3 like t1;

339

create temporary table t3 like mysqltest.t3;

340

show create table t3;

341

Table Create Table

342

t3 CREATE TEMPORARY TABLE `t3` (

343

`id` int NOT NULL,

344

`name` varchar(20) DEFAULT NULL

345

) ENGINE=DEFAULT

346

create table t2 like t3;

347

show create table t2;

348

Table Create Table

349

t2 CREATE TABLE `t2` (

350

`id` int NOT NULL,

351

`name` varchar(20) DEFAULT NULL

352

) ENGINE=DEFAULT

353

select * from t2;

354

id name

355

create table t3 like t1;

356

create table t3 like mysqltest.t3;

357

ERROR 42S01: Table 't3' already exists

358

create table non_existing_database.t1 like t1;

359

ERROR 42000: Unknown database 'non_existing_database'

360

create table t3 like non_existing_table;

361

ERROR 42S02: Table 'test.non_existing_table' doesn't exist

362

create temporary table t3 like t1;

363

ERROR 42S01: Table 't3' already exists

364

drop table t1, t2, t3;

365

drop table t3;

366

drop database mysqltest;

367

SET SESSION storage_engine="heap";

368

SELECT @@storage_engine;

369

@@storage_engine

370

MEMORY

371

CREATE TEMPORARY TABLE t1 (a int not null);

372

show create table t1;

373

Table Create Table

374

t1 CREATE TEMPORARY TABLE `t1` (

375

`a` int NOT NULL

376

) ENGINE=MEMORY

377

drop table t1;

378

SET SESSION storage_engine="gemini";

379

ERROR 42000: Unknown table engine 'gemini'

380

SELECT @@storage_engine;

381

@@storage_engine

382

MEMORY

383

CREATE TEMPORARY TABLE t1 (a int not null);

384

show create table t1;

385

Table Create Table

386

t1 CREATE TEMPORARY TABLE `t1` (

387

`a` int NOT NULL

388

) ENGINE=MEMORY

389

SET SESSION storage_engine=default;

390

drop table t1;

391

create table t1(a int,b int,c int,d date,e char,f datetime,h blob);

392

insert into t1(a)values(1);

393

insert into t1(a,b,c,d,e,f,h)

394

values(2,-2,2,'1825-12-14','a','2003-01-01 03:02:01','binary data');

395

select * from t1;

396

a b c d e f h

397

1 NULL NULL NULL NULL NULL NULL

398

2 -2 2 1825-12-14 a 2003-01-01 03:02:01 binary data

399

select a,

400

ifnull(b,-7) as b,

401

ifnull(c,7) as c,

402

ifnull(d,cast('2000-01-01' as date)) as d,

403

ifnull(e,cast('b' as char)) as e,

404

ifnull(f,cast('2000-01-01' as datetime)) as f,

405

ifnull(h,cast('yet another binary data' as binary)) as h

406

from t1;

407

a b c d e f h

408

1 -7 7 2000-01-01 b 2000-01-01 00:00:00 yet another binary data

409

2 -2 2 1825-12-14 a 2003-01-01 03:02:01 binary data

410

create table t2

411

select

412

a,

413

ifnull(b,-7) as b,

414

ifnull(c,7) as c,

415

ifnull(d,cast('2000-01-01' as date)) as d,

416

ifnull(e,cast('b' as char)) as e,

417

ifnull(f,cast('2000-01-01' as datetime)) as f,

418

ifnull(h,cast('yet another binary data' as binary)) as h

419

from t1;

420

explain t2;

421

Field Type Null Key Default Extra

422

a int YES NULL

423

b bigint NO NULL

424

c bigint NO NULL

425

d date YES NULL

426

e varchar(1) YES NULL

427

f datetime YES NULL

428

h blob YES NULL

429

select * from t2;

430

a b c d e f h

431

1 -7 7 2000-01-01 b 2000-01-01 00:00:00 yet another binary data

432

2 -2 2 1825-12-14 a 2003-01-01 03:02:01 binary data

433

drop table t1, t2;

434

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));

435

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;

436

show create table t2;

437

Table Create Table

438

t2 CREATE TABLE `t2` (

439

`ifnull(a,a)` int DEFAULT NULL,

440

`ifnull(b,b)` int DEFAULT NULL,

441

`ifnull(d,d)` int DEFAULT NULL,

442

`ifnull(e,e)` bigint DEFAULT NULL,

443

`ifnull(f,f)` double(3,2) DEFAULT NULL,

444

`ifnull(g,g)` double(4,3) DEFAULT NULL,

445

`ifnull(h,h)` decimal(5,4) DEFAULT NULL,

446

`ifnull(j,j)` date DEFAULT NULL,

447

`ifnull(k,k)` timestamp NULL DEFAULT NULL,

448

`ifnull(l,l)` datetime DEFAULT NULL,

449

`ifnull(m,m)` varchar(1) DEFAULT NULL,

450

`ifnull(o,o)` varchar(10) DEFAULT NULL

451

) ENGINE=DEFAULT

452

drop table t1,t2;

453

create table t1(str varchar(10) default 'def',strnull varchar(10),intg int default '10',rel double default '3.14');

454

insert into t1 values ('','',0,0.0);

455

describe t1;

456

Field Type Null Key Default Extra

457

str varchar(10) YES def

458

strnull varchar(10) YES NULL

459

intg int YES 10

460

rel double YES 3.14

461

create table t2 select default(str) as str, default(strnull) as strnull, default(intg) as intg, default(rel) as rel from t1;

462

describe t2;

463

Field Type Null Key Default Extra

464

str varchar(10) YES NULL

465

strnull varchar(10) YES NULL

466

intg int YES NULL

467

rel double YES NULL

468

drop table t1, t2;

469

create table t1(name varchar(10), age int default -1);

470

describe t1;

471

Field Type Null Key Default Extra

472

name varchar(10) YES NULL

473

age int YES -1

474

create table t2(name varchar(10), age int default - 1);

475

describe t2;

476

Field Type Null Key Default Extra

477

name varchar(10) YES NULL

478

age int YES -1

479

drop table t1, t2;

480

create table t1(cenum enum('a'));

481

create table t2(cenum enum('a','a'));

482

ERROR HY000: Column 'cenum' has duplicated value 'a' in ENUM

483

create table t3(cenum enum('a','A','a','c','c'));

484

ERROR HY000: Column 'cenum' has duplicated value 'a' in ENUM

485

drop table t1;

486

create database mysqltest;

487

use mysqltest;

488

select database();

489

database()

490

mysqltest

491

drop database mysqltest;

492

select database();

493

database()

494

NULL

495

use test;

496

CREATE TABLE t1(id varchar(10) NOT NULL PRIMARY KEY, dsc longtext);

497

INSERT INTO t1 VALUES ('5000000001', NULL),('5000000003', 'Test'),('5000000004', NULL);

498

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));

499

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');

500

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;

501

SELECT * FROM t3;

502

dsc countOfRuns

503

NULL 1

504

Test 0

505

NULL 1

506

drop table t1, t2, t3;

507

create table t1 (a int);

508

create table t1 select * from t1;

509

ERROR HY000: You can't specify target table 't1' for update in FROM clause

510

flush tables with read lock;

511

unlock tables;

512

drop table t1;

513

create table t1(column.name int);

514

ERROR 42000: Incorrect table name 'column'

515

create table t1(test.column.name int);

516

ERROR 42000: Incorrect table name 'column'

517

create table t1(xyz.t1.name int);

518

ERROR 42000: Incorrect database name 'xyz'

519

create table t1(t1.name int);

520

create table t2(test.t2.name int);

521

drop table t1,t2;

522

CREATE TABLE t1 (f1 VARCHAR(255));

523

CREATE TABLE t2 AS SELECT LEFT(f1,171) AS f2 FROM t1 UNION SELECT LEFT(f1,171) AS f2 FROM t1;

524

DESC t2;

525

Field Type Null Key Default Extra

526

f2 varchar(171) YES NULL

527

DROP TABLE t1,t2;

528

CREATE TABLE t12913 (f1 ENUM ('a','b')) AS SELECT 'a' AS f1;

529

SELECT * FROM t12913;

530

f1

531

a

532

DROP TABLE t12913;

533

create database mysqltest;

534

use mysqltest;

535

drop database mysqltest;

536

create table test.t1 like x;

537

ERROR 3D000: No database selected

538

drop table if exists test.t1;

539

create database mysqltest;

540

create database if not exists mysqltest;

541

Warnings:

542

Note 1007 Can't create database 'mysqltest'; database exists

543

show create database mysqltest;

544

Database Create Database

545

mysqltest CREATE DATABASE `mysqltest`

546

drop database mysqltest;

547

use test;

548

create table t1 (a int);

549

create table if not exists t1 (a int);

550

Warnings:

551

Note 1050 Table 't1' already exists

552

drop table t1;

553

create table t1 (

554

a varchar(112) collate utf8_bin not null,

555

primary key (a)

556

) select 'test' as a ;

557

show create table t1;

558

Table Create Table

559

t1 CREATE TABLE `t1` (

560

`a` varchar(112) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

561

PRIMARY KEY (`a`)

562

) ENGINE=DEFAULT

563

drop table t1;

564

CREATE TABLE t2 (

565

a int default NULL

566

);

567

insert into t2 values(111);

568

create table t1 (

569

a varchar(12) collate utf8_bin not null,

570

b int not null, primary key (a)

571

) select a, 1 as b from t2 ;

572

show create table t1;

573

Table Create Table

574

t1 CREATE TABLE `t1` (

575

`a` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

576

`b` int NOT NULL,

577

PRIMARY KEY (`a`)

578

) ENGINE=DEFAULT

579

drop table t1;

580

create table t1 (

581

a varchar(12) collate utf8_bin not null,

582

b int not null, primary key (a)

583

) select a, 1 as c from t2 ;

584

ERROR HY000: Field 'b' doesn't have a default value

585

create table t1 (

586

a varchar(12) collate utf8_bin not null,

587

b int null, primary key (a)

588

) select a, 1 as c from t2 ;

589

show create table t1;

590

Table Create Table

591

t1 CREATE TABLE `t1` (

592

`b` int DEFAULT NULL,

593

`a` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

594

`c` int NOT NULL,

595

PRIMARY KEY (`a`)

596

) ENGINE=DEFAULT

597

drop table t1;

598

create table t1 (

599

a varchar(12) collate utf8_bin not null,

600

b int not null, primary key (a)

601

) select 'a' as a , 1 as b from t2 ;

602

show create table t1;

603

Table Create Table

604

t1 CREATE TABLE `t1` (

605

`a` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

606

`b` int NOT NULL,

607

PRIMARY KEY (`a`)

608

) ENGINE=DEFAULT

609

drop table t1;

610

create table t1 (

611

a varchar(12) collate utf8_bin,

612

b int not null, primary key (a)

613

) select 'a' as a , 1 as b from t2 ;

614

show create table t1;

615

Table Create Table

616

t1 CREATE TABLE `t1` (

617

`a` varchar(12) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,

618

`b` int NOT NULL,

619

PRIMARY KEY (`a`)

620

) ENGINE=DEFAULT

621

drop table t1, t2;

622

create table t1 (

623

a1 int not null,

624

a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int

625

);

626

insert into t1 values (1,1,1, 1,1,1, 1,1,1);

627

create table t2 (

628

a1 varchar(12) collate utf8_bin not null,

629

a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int,

630

primary key (a1)

631

) select a1,a2,a3,a4,a5,a6,a7,a8,a9 from t1 ;

632

drop table t2;

633

create table t2 (

634

a1 varchar(12) collate utf8_bin,

635

a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int

636

) select a1,a2,a3,a4,a5,a6,a7,a8,a9 from t1;

637

drop table t1, t2;

638

create table t1 (

639

a1 int, a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int

640

);

641

insert into t1 values (1,1,1, 1,1,1, 1,1,1);

642

create table t2 (

643

a1 varchar(12) collate utf8_bin not null,

644

a2 int, a3 int, a4 int, a5 int, a6 int, a7 int, a8 int, a9 int,

645

primary key (a1)

646

) select a1,a2,a3,a4,a5,a6,a7,a8,a9 from t1 ;

647

drop table t2;

648

create table t2 ( a int default 3, b int default 3)

649

select a1,a2 from t1;

650

show create table t2;

651

Table Create Table

652

t2 CREATE TABLE `t2` (

653

`a` int DEFAULT '3',

654

`b` int DEFAULT '3',

655

`a1` int DEFAULT NULL,

656

`a2` int DEFAULT NULL

657

) ENGINE=DEFAULT

658

drop table t1, t2;

659

create table t1 select * from t2;

660

ERROR 42S02: Table 'test.t2' doesn't exist

661

create table t1 select * from t1;

662

ERROR HY000: You can't specify target table 't1' for update in FROM clause

663

create table t1 select coalesce('a' collate utf8_swedish_ci,'b' collate utf8_bin);

664

ERROR HY000: Illegal mix of collations (utf8_swedish_ci,EXPLICIT) and (utf8_bin,EXPLICIT) for operation 'coalesce'

665

create table t1 (primary key(a)) select "b" as b;

666

ERROR 42000: Key column 'a' doesn't exist in table

667

create table t1 (primary key (a)) (select 1 as a) union all (select 1 as a);

668

ERROR 23000: Duplicate entry '1' for key 'PRIMARY'

669

create table t1 (i int);

670

create table if not exists t1 select 1 as i;

671

Warnings:

672

Note 1050 Table 't1' already exists

673

select * from t1;

674

i

675

1

676

drop table t1;

677

create table t1 select coalesce('a' collate utf8_swedish_ci,'b' collate utf8_bin);

678

ERROR HY000: Illegal mix of collations (utf8_swedish_ci,EXPLICIT) and (utf8_bin,EXPLICIT) for operation 'coalesce'

679

create temporary table t1 (j int);

680

create table if not exists t1 select 1;

681

Warnings:

682

Note 1050 Table 't1' already exists

683

select * from t1;

684

j

685

1

686

drop temporary table t1;

687

select * from t1;

688

ERROR 42S02: Table 'test.t1' doesn't exist

689

drop table t1;

690

ERROR 42S02: Unknown table 't1'

691

create table t1 (upgrade int);

692

drop table t1;

693

create table t1 (

694

c1 int, c2 int, c3 int, c4 int, c5 int, c6 int, c7 int, c8 int,

695

c9 int, c10 int, c11 int, c12 int, c13 int, c14 int, c15 int, c16 int,

696

key a001_long_123456789_123456789_123456789_123456789_123456789_1234 (

697

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

698

key a002_long_123456789_123456789_123456789_123456789_123456789_1234 (

699

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

700

key a003_long_123456789_123456789_123456789_123456789_123456789_1234 (

701

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

702

key a004_long_123456789_123456789_123456789_123456789_123456789_1234 (

703

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

704

key a005_long_123456789_123456789_123456789_123456789_123456789_1234 (

705

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

706

key a006_long_123456789_123456789_123456789_123456789_123456789_1234 (

707

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

708

key a007_long_123456789_123456789_123456789_123456789_123456789_1234 (

709

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

710

key a008_long_123456789_123456789_123456789_123456789_123456789_1234 (

711

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

712

key a009_long_123456789_123456789_123456789_123456789_123456789_1234 (

713

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

714

key a010_long_123456789_123456789_123456789_123456789_123456789_1234 (

715

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

716

key a011_long_123456789_123456789_123456789_123456789_123456789_1234 (

717

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

718

key a012_long_123456789_123456789_123456789_123456789_123456789_1234 (

719

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

720

key a013_long_123456789_123456789_123456789_123456789_123456789_1234 (

721

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

722

key a014_long_123456789_123456789_123456789_123456789_123456789_1234 (

723

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

724

key a015_long_123456789_123456789_123456789_123456789_123456789_1234 (

725

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

726

key a016_long_123456789_123456789_123456789_123456789_123456789_1234 (

727

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

728

key a017_long_123456789_123456789_123456789_123456789_123456789_1234 (

729

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

730

key a018_long_123456789_123456789_123456789_123456789_123456789_1234 (

731

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

732

key a019_long_123456789_123456789_123456789_123456789_123456789_1234 (

733

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

734

key a020_long_123456789_123456789_123456789_123456789_123456789_1234 (

735

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

736

key a021_long_123456789_123456789_123456789_123456789_123456789_1234 (

737

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

738

key a022_long_123456789_123456789_123456789_123456789_123456789_1234 (

739

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

740

key a023_long_123456789_123456789_123456789_123456789_123456789_1234 (

741

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

742

key a024_long_123456789_123456789_123456789_123456789_123456789_1234 (

743

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

744

key a025_long_123456789_123456789_123456789_123456789_123456789_1234 (

745

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

746

key a026_long_123456789_123456789_123456789_123456789_123456789_1234 (

747

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

748

key a027_long_123456789_123456789_123456789_123456789_123456789_1234 (

749

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

750

key a028_long_123456789_123456789_123456789_123456789_123456789_1234 (

751

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

752

key a029_long_123456789_123456789_123456789_123456789_123456789_1234 (

753

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

754

key a030_long_123456789_123456789_123456789_123456789_123456789_1234 (

755

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

756

key a031_long_123456789_123456789_123456789_123456789_123456789_1234 (

757

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

758

key a032_long_123456789_123456789_123456789_123456789_123456789_1234 (

759

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

760

key a033_long_123456789_123456789_123456789_123456789_123456789_1234 (

761

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

762

key a034_long_123456789_123456789_123456789_123456789_123456789_1234 (

763

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

764

key a035_long_123456789_123456789_123456789_123456789_123456789_1234 (

765

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

766

key a036_long_123456789_123456789_123456789_123456789_123456789_1234 (

767

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

768

key a037_long_123456789_123456789_123456789_123456789_123456789_1234 (

769

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

770

key a038_long_123456789_123456789_123456789_123456789_123456789_1234 (

771

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

772

key a039_long_123456789_123456789_123456789_123456789_123456789_1234 (

773

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

774

key a040_long_123456789_123456789_123456789_123456789_123456789_1234 (

775

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

776

key a041_long_123456789_123456789_123456789_123456789_123456789_1234 (

777

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

778

key a042_long_123456789_123456789_123456789_123456789_123456789_1234 (

779

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

780

key a043_long_123456789_123456789_123456789_123456789_123456789_1234 (

781

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

782

key a044_long_123456789_123456789_123456789_123456789_123456789_1234 (

783

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

784

key a045_long_123456789_123456789_123456789_123456789_123456789_1234 (

785

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

786

key a046_long_123456789_123456789_123456789_123456789_123456789_1234 (

787

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

788

key a047_long_123456789_123456789_123456789_123456789_123456789_1234 (

789

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

790

key a048_long_123456789_123456789_123456789_123456789_123456789_1234 (

791

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

792

key a049_long_123456789_123456789_123456789_123456789_123456789_1234 (

793

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

794

key a050_long_123456789_123456789_123456789_123456789_123456789_1234 (

795

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

796

key a051_long_123456789_123456789_123456789_123456789_123456789_1234 (

797

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

798

key a052_long_123456789_123456789_123456789_123456789_123456789_1234 (

799

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

800

key a053_long_123456789_123456789_123456789_123456789_123456789_1234 (

801

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

802

key a054_long_123456789_123456789_123456789_123456789_123456789_1234 (

803

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

804

key a055_long_123456789_123456789_123456789_123456789_123456789_1234 (

805

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

806

key a056_long_123456789_123456789_123456789_123456789_123456789_1234 (

807

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

808

key a057_long_123456789_123456789_123456789_123456789_123456789_1234 (

809

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

810

key a058_long_123456789_123456789_123456789_123456789_123456789_1234 (

811

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

812

key a059_long_123456789_123456789_123456789_123456789_123456789_1234 (

813

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

814

key a060_long_123456789_123456789_123456789_123456789_123456789_1234 (

815

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

816

key a061_long_123456789_123456789_123456789_123456789_123456789_1234 (

817

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

818

key a062_long_123456789_123456789_123456789_123456789_123456789_1234 (

819

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

820

key a063_long_123456789_123456789_123456789_123456789_123456789_1234 (

821

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

822

key a064_long_123456789_123456789_123456789_123456789_123456789_1234 (

823

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16)

824

);

825

show create table t1;

826

Table Create Table

827

t1 CREATE TABLE `t1` (

828

`c1` int DEFAULT NULL,

829

`c2` int DEFAULT NULL,

830

`c3` int DEFAULT NULL,

831

`c4` int DEFAULT NULL,

832

`c5` int DEFAULT NULL,

833

`c6` int DEFAULT NULL,

834

`c7` int DEFAULT NULL,

835

`c8` int DEFAULT NULL,

836

`c9` int DEFAULT NULL,

837

`c10` int DEFAULT NULL,

838

`c11` int DEFAULT NULL,

839

`c12` int DEFAULT NULL,

840

`c13` int DEFAULT NULL,

841

`c14` int DEFAULT NULL,

842

`c15` int DEFAULT NULL,

843

`c16` int DEFAULT NULL,

844

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`),

845

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`),

846

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`),

847

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`),

848

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`),

849

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`),

850

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`),

851

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`),

852

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`),

853

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`),

854

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`),

855

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`),

856

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`),

857

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`),

858

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`),

859

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`),

860

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`),

861

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`),

862

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`),

863

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`),

864

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`),

865

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`),

866

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`),

867

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`),

868

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`),

869

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`),

870

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`),

871

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`),

872

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`),

873

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`),

874

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`),

875

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`),

876

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`),

877

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`),

878

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`),

879

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`),

880

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`),

881

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`),

882

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`),

883

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`),

884

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`),

885

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`),

886

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`),

887

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`),

888

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`),

889

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`),

890

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`),

891

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`),

892

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`),

893

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`),

894

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`),

895

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`),

896

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`),

897

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`),

898

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`),

899

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`),

900

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`),

901

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`),

902

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`),

903

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`),

904

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`),

905

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`),

906

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`),

907

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`)

908

) ENGINE=DEFAULT

909

flush tables;

910

show create table t1;

911

Table Create Table

912

t1 CREATE TABLE `t1` (

913

`c1` int DEFAULT NULL,

914

`c2` int DEFAULT NULL,

915

`c3` int DEFAULT NULL,

916

`c4` int DEFAULT NULL,

917

`c5` int DEFAULT NULL,

918

`c6` int DEFAULT NULL,

919

`c7` int DEFAULT NULL,

920

`c8` int DEFAULT NULL,

921

`c9` int DEFAULT NULL,

922

`c10` int DEFAULT NULL,

923

`c11` int DEFAULT NULL,

924

`c12` int DEFAULT NULL,

925

`c13` int DEFAULT NULL,

926

`c14` int DEFAULT NULL,

927

`c15` int DEFAULT NULL,

928

`c16` int DEFAULT NULL,

929

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`),

930

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`),

931

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`),

932

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`),

933

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`),

934

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`),

935

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`),

936

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`),

937

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`),

938

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`),

939

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`),

940

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`),

941

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`),

942

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`),

943

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`),

944

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`),

945

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`),

946

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`),

947

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`),

948

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`),

949

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`),

950

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`),

951

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`),

952

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`),

953

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`),

954

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`),

955

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`),

956

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`),

957

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`),

958

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`),

959

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`),

960

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`),

961

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`),

962

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`),

963

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`),

964

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`),

965

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`),

966

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`),

967

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`),

968

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`),

969

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`),

970

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`),

971

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`),

972

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`),

973

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`),

974

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`),

975

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`),

976

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`),

977

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`),

978

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`),

979

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`),

980

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`),

981

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`),

982

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`),

983

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`),

984

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`),

985

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`),

986

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`),

987

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`),

988

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`),

989

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`),

990

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`),

991

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`),

992

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`)

993

) ENGINE=DEFAULT

994

drop table t1;

995

create table t1 (c1 int, c2 int, c3 int, c4 int, c5 int, c6 int, c7 int,

996

c8 int, c9 int, c10 int, c11 int, c12 int, c13 int, c14 int, c15 int, c16 int);

997

alter table t1

998

add key a001_long_123456789_123456789_123456789_123456789_123456789_1234 (

999

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1000

add key a002_long_123456789_123456789_123456789_123456789_123456789_1234 (

1001

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1002

add key a003_long_123456789_123456789_123456789_123456789_123456789_1234 (

1003

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1004

add key a004_long_123456789_123456789_123456789_123456789_123456789_1234 (

1005

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1006

add key a005_long_123456789_123456789_123456789_123456789_123456789_1234 (

1007

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1008

add key a006_long_123456789_123456789_123456789_123456789_123456789_1234 (

1009

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1010

add key a007_long_123456789_123456789_123456789_123456789_123456789_1234 (

1011

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1012

add key a008_long_123456789_123456789_123456789_123456789_123456789_1234 (

1013

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1014

add key a009_long_123456789_123456789_123456789_123456789_123456789_1234 (

1015

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1016

add key a010_long_123456789_123456789_123456789_123456789_123456789_1234 (

1017

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1018

add key a011_long_123456789_123456789_123456789_123456789_123456789_1234 (

1019

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1020

add key a012_long_123456789_123456789_123456789_123456789_123456789_1234 (

1021

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1022

add key a013_long_123456789_123456789_123456789_123456789_123456789_1234 (

1023

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1024

add key a014_long_123456789_123456789_123456789_123456789_123456789_1234 (

1025

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1026

add key a015_long_123456789_123456789_123456789_123456789_123456789_1234 (

1027

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1028

add key a016_long_123456789_123456789_123456789_123456789_123456789_1234 (

1029

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1030

add key a017_long_123456789_123456789_123456789_123456789_123456789_1234 (

1031

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1032

add key a018_long_123456789_123456789_123456789_123456789_123456789_1234 (

1033

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1034

add key a019_long_123456789_123456789_123456789_123456789_123456789_1234 (

1035

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1036

add key a020_long_123456789_123456789_123456789_123456789_123456789_1234 (

1037

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1038

add key a021_long_123456789_123456789_123456789_123456789_123456789_1234 (

1039

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1040

add key a022_long_123456789_123456789_123456789_123456789_123456789_1234 (

1041

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1042

add key a023_long_123456789_123456789_123456789_123456789_123456789_1234 (

1043

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1044

add key a024_long_123456789_123456789_123456789_123456789_123456789_1234 (

1045

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1046

add key a025_long_123456789_123456789_123456789_123456789_123456789_1234 (

1047

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1048

add key a026_long_123456789_123456789_123456789_123456789_123456789_1234 (

1049

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1050

add key a027_long_123456789_123456789_123456789_123456789_123456789_1234 (

1051

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1052

add key a028_long_123456789_123456789_123456789_123456789_123456789_1234 (

1053

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1054

add key a029_long_123456789_123456789_123456789_123456789_123456789_1234 (

1055

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1056

add key a030_long_123456789_123456789_123456789_123456789_123456789_1234 (

1057

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1058

add key a031_long_123456789_123456789_123456789_123456789_123456789_1234 (

1059

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1060

add key a032_long_123456789_123456789_123456789_123456789_123456789_1234 (

1061

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1062

add key a033_long_123456789_123456789_123456789_123456789_123456789_1234 (

1063

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1064

add key a034_long_123456789_123456789_123456789_123456789_123456789_1234 (

1065

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1066

add key a035_long_123456789_123456789_123456789_123456789_123456789_1234 (

1067

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1068

add key a036_long_123456789_123456789_123456789_123456789_123456789_1234 (

1069

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1070

add key a037_long_123456789_123456789_123456789_123456789_123456789_1234 (

1071

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1072

add key a038_long_123456789_123456789_123456789_123456789_123456789_1234 (

1073

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1074

add key a039_long_123456789_123456789_123456789_123456789_123456789_1234 (

1075

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1076

add key a040_long_123456789_123456789_123456789_123456789_123456789_1234 (

1077

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1078

add key a041_long_123456789_123456789_123456789_123456789_123456789_1234 (

1079

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1080

add key a042_long_123456789_123456789_123456789_123456789_123456789_1234 (

1081

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1082

add key a043_long_123456789_123456789_123456789_123456789_123456789_1234 (

1083

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1084

add key a044_long_123456789_123456789_123456789_123456789_123456789_1234 (

1085

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1086

add key a045_long_123456789_123456789_123456789_123456789_123456789_1234 (

1087

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1088

add key a046_long_123456789_123456789_123456789_123456789_123456789_1234 (

1089

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1090

add key a047_long_123456789_123456789_123456789_123456789_123456789_1234 (

1091

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1092

add key a048_long_123456789_123456789_123456789_123456789_123456789_1234 (

1093

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1094

add key a049_long_123456789_123456789_123456789_123456789_123456789_1234 (

1095

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1096

add key a050_long_123456789_123456789_123456789_123456789_123456789_1234 (

1097

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1098

add key a051_long_123456789_123456789_123456789_123456789_123456789_1234 (

1099

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1100

add key a052_long_123456789_123456789_123456789_123456789_123456789_1234 (

1101

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1102

add key a053_long_123456789_123456789_123456789_123456789_123456789_1234 (

1103

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1104

add key a054_long_123456789_123456789_123456789_123456789_123456789_1234 (

1105

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1106

add key a055_long_123456789_123456789_123456789_123456789_123456789_1234 (

1107

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1108

add key a056_long_123456789_123456789_123456789_123456789_123456789_1234 (

1109

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1110

add key a057_long_123456789_123456789_123456789_123456789_123456789_1234 (

1111

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1112

add key a058_long_123456789_123456789_123456789_123456789_123456789_1234 (

1113

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1114

add key a059_long_123456789_123456789_123456789_123456789_123456789_1234 (

1115

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1116

add key a060_long_123456789_123456789_123456789_123456789_123456789_1234 (

1117

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1118

add key a061_long_123456789_123456789_123456789_123456789_123456789_1234 (

1119

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1120

add key a062_long_123456789_123456789_123456789_123456789_123456789_1234 (

1121

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1122

add key a063_long_123456789_123456789_123456789_123456789_123456789_1234 (

1123

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16),

1124

add key a064_long_123456789_123456789_123456789_123456789_123456789_1234 (

1125

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16);

1126

show create table t1;

1127

Table Create Table

1128

t1 CREATE TABLE `t1` (

1129

`c1` int DEFAULT NULL,

1130

`c2` int DEFAULT NULL,

1131

`c3` int DEFAULT NULL,

1132

`c4` int DEFAULT NULL,

1133

`c5` int DEFAULT NULL,

1134

`c6` int DEFAULT NULL,

1135

`c7` int DEFAULT NULL,

1136

`c8` int DEFAULT NULL,

1137

`c9` int DEFAULT NULL,

1138

`c10` int DEFAULT NULL,

1139

`c11` int DEFAULT NULL,

1140

`c12` int DEFAULT NULL,

1141

`c13` int DEFAULT NULL,

1142

`c14` int DEFAULT NULL,

1143

`c15` int DEFAULT NULL,

1144

`c16` int DEFAULT NULL,

1145

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`),

1146

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`),

1147

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`),

1148

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`),

1149

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`),

1150

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`),

1151

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`),

1152

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`),

1153

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`),

1154

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`),

1155

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`),

1156

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`),

1157

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`),

1158

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`),

1159

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`),

1160

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`),

1161

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`),

1162

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`),

1163

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`),

1164

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`),

1165

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`),

1166

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`),

1167

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`),

1168

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`),

1169

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`),

1170

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`),

1171

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`),

1172

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`),

1173

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`),

1174

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`),

1175

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`),

1176

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`),

1177

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`),

1178

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`),

1179

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`),

1180

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`),

1181

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`),

1182

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`),

1183

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`),

1184

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`),

1185

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`),

1186

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`),

1187

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`),

1188

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`),

1189

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`),

1190

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`),

1191

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`),

1192

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`),

1193

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`),

1194

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`),

1195

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`),

1196

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`),

1197

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`),

1198

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`),

1199

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`),

1200

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`),

1201

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`),

1202

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`),

1203

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`),

1204

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`),

1205

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`),

1206

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`),

1207

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`),

1208

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`)

1209

) ENGINE=DEFAULT

1210

flush tables;

1211

show create table t1;

1212

Table Create Table

1213

t1 CREATE TABLE `t1` (

1214

`c1` int DEFAULT NULL,

1215

`c2` int DEFAULT NULL,

1216

`c3` int DEFAULT NULL,

1217

`c4` int DEFAULT NULL,

1218

`c5` int DEFAULT NULL,

1219

`c6` int DEFAULT NULL,

1220

`c7` int DEFAULT NULL,

1221

`c8` int DEFAULT NULL,

1222

`c9` int DEFAULT NULL,

1223

`c10` int DEFAULT NULL,

1224

`c11` int DEFAULT NULL,

1225

`c12` int DEFAULT NULL,

1226

`c13` int DEFAULT NULL,

1227

`c14` int DEFAULT NULL,

1228

`c15` int DEFAULT NULL,

1229

`c16` int DEFAULT NULL,

1230

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`),

1231

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`),

1232

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`),

1233

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`),

1234

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`),

1235

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`),

1236

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`),

1237

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`),

1238

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`),

1239

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`),

1240

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`),

1241

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`),

1242

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`),

1243

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`),

1244

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`),

1245

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`),

1246

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`),

1247

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`),

1248

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`),

1249

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`),

1250

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`),

1251

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`),

1252

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`),

1253

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`),

1254

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`),

1255

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`),

1256

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`),

1257

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`),

1258

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`),

1259

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`),

1260

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`),

1261

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`),

1262

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`),

1263

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`),

1264

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`),

1265

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`),

1266

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`),

1267

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`),

1268

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`),

1269

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`),

1270

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`),

1271

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`),

1272

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`),

1273

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`),

1274

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`),

1275

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`),

1276

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`),

1277

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`),

1278

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`),

1279

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`),

1280

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`),

1281

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`),

1282

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`),

1283

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`),

1284

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`),

1285

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`),

1286

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`),

1287

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`),

1288

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`),

1289

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`),

1290

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`),

1291

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`),

1292

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`),

1293

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`)

1294

) ENGINE=DEFAULT

1295

alter table t1 add key

1296

a065_long_123456789_123456789_123456789_123456789_123456789_1234 (

1297

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16);

1298

ERROR 42000: Too many keys specified; max 64 keys allowed

1299

drop table t1;

1300

create table t1 (c1 int, c2 int, c3 int, c4 int, c5 int, c6 int, c7 int,

1301

c8 int, c9 int, c10 int, c11 int, c12 int, c13 int, c14 int, c15 int,

1302

c16 int, c17 int);

1303

alter table t1 add key i1 (

1304

c1,c2,c3,c4,c5,c6,c7,c8,c9,c10,c11,c12,c13,c14,c15,c16, c17);

1305

ERROR 42000: Too many key parts specified; max 16 parts allowed

1306

alter table t1 add key

1307

a001_long_123456789_123456789_123456789_123456789_123456789_12345 (c1);

1308

ERROR 42000: Identifier name 'a001_long_123456789_123456789_123456789_123456789_123456789_12345' is too long

1309

show create table t1;

1310

Table Create Table

1311

t1 CREATE TABLE `t1` (

1312

`c1` int DEFAULT NULL,

1313

`c2` int DEFAULT NULL,

1314

`c3` int DEFAULT NULL,

1315

`c4` int DEFAULT NULL,

1316

`c5` int DEFAULT NULL,

1317

`c6` int DEFAULT NULL,

1318

`c7` int DEFAULT NULL,

1319

`c8` int DEFAULT NULL,

1320

`c9` int DEFAULT NULL,

1321

`c10` int DEFAULT NULL,

1322

`c11` int DEFAULT NULL,

1323

`c12` int DEFAULT NULL,

1324

`c13` int DEFAULT NULL,

1325

`c14` int DEFAULT NULL,

1326

`c15` int DEFAULT NULL,

1327

`c16` int DEFAULT NULL,

1328

`c17` int DEFAULT NULL

1329

) ENGINE=DEFAULT

1330

drop table t1;

1331

1332

Bug #26104 Bug on foreign key class constructor

1333

1334

Check that ref_columns is initalized correctly in the constructor

1335

and semantic checks in mysql_prepare_table work.

1336

1337

We do not need a storage engine that supports foreign keys

1338

for this test, as the checks are purely syntax-based, and the

1339

syntax is supported for all engines.

1340

1341

drop table if exists t1,t2;

1342

create table t1(a int not null, b int not null, primary key (a, b));

1343

create table t2(a int not null, b int not null, c int not null, primary key (a),

1344

foreign key fk_bug26104 (b,c) references t1(a));

1345

ERROR 42000: Incorrect foreign key definition for 'fk_bug26104': Key reference and table reference don't match

1346

drop table t1;

1347

create table t1(f1 int,f2 int);

1348

insert into t1 value(1,1),(1,2),(1,3),(2,1),(2,2),(2,3);

1349

flush status;

1350

create table t2 select sql_big_result f1,count(f2) from t1 group by f1;

1351

show status like 'handler_read%';

1352

Variable_name Value

1353

Handler_read_first 0

1354

Handler_read_key 0

1355

Handler_read_next 0

1356

Handler_read_prev 0

1357

Handler_read_rnd 0

1358

Handler_read_rnd_next 0

1359

drop table t1,t2;

1360

CREATE TABLE t1(c1 VARCHAR(33), KEY USING BTREE (c1));

1361

DROP TABLE t1;

1362

CREATE TABLE t1(c1 VARCHAR(33), KEY (c1) USING BTREE);

1363

DROP TABLE t1;

1364

CREATE TEMPORARY TABLE t1(c1 VARCHAR(33), KEY USING BTREE (c1) USING HASH) ENGINE=MEMORY;

1365

SHOW INDEX FROM t1;

1366

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment

1367

t1 1 c1 1 c1 NULL 0 NULL NULL YES HASH

1368

DROP TABLE t1;

1369

CREATE TEMPORARY TABLE t1(c1 VARCHAR(33), KEY USING HASH (c1) USING BTREE) ENGINE=MEMORY;

1370

SHOW INDEX FROM t1;

1371

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_Comment

1372

t1 1 c1 1 c1 A NULL NULL NULL YES BTREE

1373

DROP TABLE t1;

1374

End of 5.0 tests

1375

CREATE TABLE t1 (a int, b int);

1376

insert into t1 values (1,1),(1,2);

1377

CREATE TABLE t2 (primary key (a)) select * from t1;

1378

ERROR 23000: Duplicate entry '1' for key 'PRIMARY'

1379

drop table if exists t2;

1380

Warnings:

1381

Note 1051 Unknown table 't2'

1382

CREATE TEMPORARY TABLE t2 (primary key (a)) select * from t1;

1383

ERROR 23000: Duplicate entry '1' for key 'PRIMARY'

1384

drop table if exists t2;

1385

Warnings:

1386

Note 1051 Unknown table 't2'

1387

CREATE TEMPORARY TABLE t2 (a int, b int, primary key (a));

1388

CREATE TEMPORARY TABLE IF NOT EXISTS t2 (primary key (a)) select * from t1;

1389

ERROR 23000: Duplicate entry '1' for key 'PRIMARY'

1390

SELECT * from t2;

1391

a b

1392

TRUNCATE table t2;

1393

INSERT INTO t2 select * from t1;

1394

ERROR 23000: Duplicate entry '1' for key 'PRIMARY'

1395

SELECT * from t2;

1396

a b

1397

drop table t1,t2;

1398

CREATE DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;

1399

ERROR 42000: Incorrect database name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

1400

DROP DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;

1401

ERROR 42000: Incorrect database name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

1402

USE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;

1403

ERROR 42000: Incorrect database name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

1404

SHOW CREATE DATABASE aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa;

1405

ERROR 42000: Incorrect database name 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'

1406

create database имя_базы_в_кодировке_утф8_длиной_больше_чем_45;

1407

use имя_базы_в_кодировке_утф8_длиной_больше_чем_45;

1408

select database();

1409

database()

1410

имя_базы_в_кодировке_утф8_длиной_больше_чем_45

1411

use test;

1412

select SCHEMA_NAME from information_schema.schemata

1413

where schema_name='имя_базы_в_кодировке_утф8_длиной_больше_чем_45';

1414

SCHEMA_NAME

1415

имя_базы_в_кодировке_утф8_длиной_больше_чем_45

1416

drop database имя_базы_в_кодировке_утф8_длиной_больше_чем_45;

1417

create table имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48

1418

(

1419

имя_поля_в_кодировке_утф8_длиной_больше_чем_45 int,

1420

index имя_индекса_в_кодировке_утф8_длиной_больше_чем_48 (имя_поля_в_кодировке_утф8_длиной_больше_чем_45)

1421

);

1422

select * from имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48;

1423

имя_поля_в_кодировке_утф8_длиной_больше_чем_45

1424

select TABLE_NAME from information_schema.tables where

1425

table_schema='test';

1426

TABLE_NAME

1427

имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48

1428

select COLUMN_NAME from information_schema.columns where

1429

table_schema='test';

1430

COLUMN_NAME

1431

имя_поля_в_кодировке_утф8_длиной_больше_чем_45

1432

select INDEX_NAME from information_schema.statistics where

1433

table_schema='test';

1434

INDEX_NAME

1435

имя_индекса_в_кодировке_утф8_длиной_больше_чем_48

1436

show create table имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48;

1437

Table Create Table

1438

имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48 CREATE TABLE `имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48` (

1439

`имя_поля_в_кодировке_утф8_длиной_больше_чем_45` int DEFAULT NULL,

1440

KEY `имя_индекса_в_кодировке_утф8_длиной_больше_чем_48` (`имя_поля_в_кодировке_утф8_длиной_больше_чем_45`)

1441

) ENGINE=DEFAULT

1442

drop table имя_таблицы_в_кодировке_утф8_длиной_больше_чем_48;

1443

create table t1 like information_schema.processlist;

1444

show create table t1;

1445

Table Create Table

1446

t1 CREATE TABLE `t1` (

1447

`ID` bigint NOT NULL DEFAULT '0',

1448

`USER` varchar(16) NOT NULL DEFAULT '',

1449

`HOST` varchar(64) NOT NULL DEFAULT '',

1450

`DB` varchar(64) DEFAULT NULL,

1451

`COMMAND` varchar(16) NOT NULL DEFAULT '',

1452

`TIME` bigint NOT NULL DEFAULT '0',

1453

`STATE` varchar(64) DEFAULT NULL,

1454

`INFO` text

1455

) ENGINE=MyISAM

1456

drop table t1;

1457

create temporary table t1 like information_schema.processlist;

1458

show create table t1;

1459

Table Create Table

1460

t1 CREATE TEMPORARY TABLE `t1` (

1461

`ID` bigint NOT NULL DEFAULT '0',

1462

`USER` varchar(16) NOT NULL DEFAULT '',

1463

`HOST` varchar(64) NOT NULL DEFAULT '',

1464

`DB` varchar(64) DEFAULT NULL,

1465

`COMMAND` varchar(16) NOT NULL DEFAULT '',

1466

`TIME` bigint NOT NULL DEFAULT '0',

1467

`STATE` varchar(64) DEFAULT NULL,

1468

`INFO` text

1469

) ENGINE=MyISAM

1470

drop table t1;

1471

1472

# --

1473

# -- Bug#21380: DEFAULT definition not always transfered by CREATE

1474

# -- TABLE/SELECT to the new table.

1475

# --

1476

1477

DROP TABLE IF EXISTS t1;

1478

DROP TABLE IF EXISTS t2;

1479

1480

CREATE TABLE t1(

1481

c1 INT DEFAULT 12 COMMENT 'column1',

1482

c2 INT NULL COMMENT 'column2',

1483

c3 INT NOT NULL COMMENT 'column3',

1484

c4 VARCHAR(255) NOT NULL DEFAULT 'a',

1485

c5 VARCHAR(255) COLLATE utf8_unicode_ci NULL DEFAULT 'b',

1486

c6 VARCHAR(255))

1487

COLLATE utf8_bin;

1488

1489

SHOW CREATE TABLE t1;

1490

Table Create Table

1491

t1 CREATE TABLE `t1` (

1492

`c1` int DEFAULT '12' COMMENT 'column1',

1493

`c2` int DEFAULT NULL COMMENT 'column2',

1494

`c3` int NOT NULL COMMENT 'column3',

1495

`c4` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'a',

1496

`c5` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT 'b',

1497

`c6` varchar(255) COLLATE utf8_bin DEFAULT NULL

1498

) ENGINE=DEFAULT

1499

1500

CREATE TABLE t2 AS SELECT * FROM t1;

1501

1502

SHOW CREATE TABLE t2;

1503

Table Create Table

1504

t2 CREATE TABLE `t2` (

1505

`c1` int DEFAULT '12' COMMENT 'column1',

1506

`c2` int DEFAULT NULL COMMENT 'column2',

1507

`c3` int NOT NULL COMMENT 'column3',

1508

`c4` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'a',

1509

`c5` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT 'b',

1510

`c6` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL

1511

) ENGINE=DEFAULT

1512

1513

DROP TABLE t2;

1514

1515

# -- End of test case for Bug#21380.

1516

1517

# --

1518

# -- Bug#18834: ALTER TABLE ADD INDEX on table with two timestamp fields

1519

# --

1520

1521

DROP TABLE IF EXISTS t1;

1522

DROP TABLE IF EXISTS t2;

1523

DROP TABLE IF EXISTS t3;

1524

1525

CREATE TABLE t1(c1 TIMESTAMP, c2 TIMESTAMP);

1526

1527

1528

CREATE TABLE t2(c1 TIMESTAMP, c2 TIMESTAMP NULL);

1529

drop table t2;

1530

CREATE TABLE t2(c1 TIMESTAMP, c2 TIMESTAMP DEFAULT '1982-01-29');

1531

drop table t2;

1532

1533

CREATE TABLE t2(c1 TIMESTAMP, c2 TIMESTAMP);

1534

drop table t2;

1535

1536

# -- Check that NULL column still can be created.

1537

CREATE TABLE t2(c1 TIMESTAMP NULL);

1538

1539

# -- Check ALTER TABLE.

1540

ALTER TABLE t1 ADD INDEX(c1);

1541

1542

# -- Check DATETIME.

1543

1544

CREATE TABLE t3(c1 DATETIME NOT NULL);

1545

INSERT INTO t3 VALUES (0);

1546

ERROR HY000: Received an invalid datetime value '0'.

1547

1548

ALTER TABLE t3 ADD INDEX(c1);

1549

1550

# -- Cleanup.

1551

DROP TABLE t1;

1552

DROP TABLE t2;

1553

DROP TABLE t3;

1554

1555

# -- End of Bug#18834.