~drizzle-trunk/drizzle/development

create TEMPORARY table t1 (a int not null default 0, b int not null default 0, c int not null default 0, d int not null default 0, e int not null default 0, f int not null default 0, g int not null default 0, h int not null default 0,i int not null default 0, primary key (a,b,c,d,e,f,g,i,h)) engine=MyISAM;

210

create table t1 (a int not null default 0, b int not null default 0, c int not null default 0, d int not null default 0, e int not null default 0, f int not null default 0, g int not null default 0, h int not null default 0,i int not null default 0, primary key (a,b,c,d,e,f,g,i,h)) engine=MyISAM;

223

211

insert into t1 (a) values(1);

224

--replace_column 1 # 6 # 7 # 8 # 9 # 10 #

212

--replace_column 3 X 7 X 8 X 9 X 10 X 11 X 12 X 13 X 14 X

225

213

show table status like 't1';

226

214

drop table t1;

227

215

249

237

# BUG 12207 alter table ... discard table space on MyISAM table causes ERROR 2013 (HY000)

250

238

251

239

# Some platforms (Mac OS X, Windows) will send the error message using small letters.

252

CREATE TEMPORARY TABLE T12207(a int) ENGINE=MYISAM;

240

CREATE TABLE T12207(a int) ENGINE=MYISAM;

253

241

--replace_result t12207 T12207

254

242

--error ER_ILLEGAL_HA

255

243

ALTER TABLE T12207 DISCARD TABLESPACE;

395

383

drop table t1;

396

384

397

385

398

# BUG#23404 - ROW_FORMAT=COMPACT option is lost is an index is added to the

386

# BUG#23404 - ROW_FORMAT=FIXED option is lost is an index is added to the

399

387

# table

400

388

401

CREATE TABLE t1(a INT) ROW_FORMAT=COMPACT;

389

CREATE TABLE t1(a INT) ROW_FORMAT=FIXED;

402

390

CREATE INDEX i1 ON t1(a);

403

391

--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/

404

392

SHOW CREATE TABLE t1;

503

491

# Bug#25262 Auto Increment lost when changing Engine type

504

492

505

493

506

create TEMPORARY table t1(id int primary key auto_increment) engine=MEMORY;

494

create table t1(id int primary key auto_increment) engine=heap;

507

495

508

496

insert into t1 values (null);

509

497

insert into t1 values (null);

520

508

insert into t1 values (null);

521

509

select * from t1;

522

510

523

# Alter to MEMORY again

524

alter table t1 engine = MEMORY;

511

# Alter to heap again

512

alter table t1 engine = heap;

525

513

insert into t1 values (null);

526

514

select * from t1;

527

515

534

522

#create table t1(f1 int);

535

523

#alter table t1 add column f2 datetime not null, add column f21 date not null;

536

524

#insert into t1 values(1,'2000-01-01','2000-01-01');

537

#--error ER_TRUNCATED_WRONG_VALUE

525

#--error 1292

538

526

#alter table t1 add column f3 datetime not null;

539

#--error ER_TRUNCATED_WRONG_VALUE

527

#--error 1292

540

528

#alter table t1 add column f3 date not null;

541

#--error ER_TRUNCATED_WRONG_VALUE

529

#--error 1292

542

530

#alter table t1 add column f4 datetime not null default '2002-02-02',

543

531

# add column f41 date not null;

544

532

#alter table t1 add column f4 datetime not null default '2002-02-02',

578

566

# without # prefix is not allowed for TEXT columns, while index

579

567

# is defined with prefix.

580

568

581

create TEMPORARY table t1 (t varchar(255) default null, key t (t(80))) engine=myisam;

569

create table t1 (t varchar(255) default null, key t (t(80))) engine=myisam;

582

570

alter table t1 change t t text;

583

571

drop table t1;

584

572

586

574

# Bug#18038 MySQL server corrupts binary columns data

587

575

588

576

589

CREATE TABLE t1 (s CHAR(8));

577

CREATE TABLE t1 (s CHAR(8) BINARY);

590

578

INSERT INTO t1 VALUES ('test');

591

579

SELECT LENGTH(s) FROM t1;

592

ALTER TABLE t1 MODIFY s CHAR(10);

580

ALTER TABLE t1 MODIFY s CHAR(10) BINARY;

593

581

SELECT LENGTH(s) FROM t1;

594

582

DROP TABLE t1;

595

583

Older »