~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/mix1.inc

• browse files at revision 2024.1.3
• compare with another revision
• download diff
• download tarball
• view history from revision 2024.1.3

• reverse the comparison (2024.1.3 to 2191)
• stop comparing with revision 2191

Show diffs side-by-side

added

removed

tests/include/mix1.inc

317

317

 

318

318

DELETE IGNORE FROM t1 WHERE i = 1;

319

319

 

320

 

SELECT * FROM t1 CROSS JOIN t2;

 

320

SELECT * FROM t1, t2;

321

321

 

322

322

DROP TABLE t2, t1;

323

323

 

653

653

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

654

654

BEGIN;

655

655

INSERT INTO t2 values(100,100);

656

 

COMMIT;

657

656

--error ER_DUP_ENTRY

658

657

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

659

658

SELECT * from t2;

1036

1035

#             auto_increment keys

1037

1036

#

1038

1037

create table t1 (a int auto_increment primary key) engine=innodb;

1039

 

--error ER_UNKNOWN_ERROR

 

1038

--error 1105

1040

1039

alter table t1 order by a;

1041

1040

drop table t1;

1042

1041

 

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1