← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/mix1.inc

  • Committer: Brian Aker
  • Date: 2011-02-22 06:12:02 UTC
  • mfrom: (2190.1.6 drizzle-build)
  • Revision ID: brian@tangent.org-20110222061202-k03czxykqy4x9hjs
List update, header fixes, multiple symbols, and David deletes some code.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/include/mix1.inc
317
317
 
318
318
DELETE IGNORE FROM t1 WHERE i = 1;
319
319
 
320
 
SELECT * FROM t1, t2;
 
320
SELECT * FROM t1 CROSS JOIN 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;
656
657
--error ER_DUP_ENTRY
657
658
CREATE TABLE IF NOT EXISTS t2 (primary key (a)) select * from t1;
658
659
SELECT * from t2;
1035
1036
#             auto_increment keys
1036
1037
#
1037
1038
create table t1 (a int auto_increment primary key) engine=innodb;
1038
 
--error 1105
 
1039
--error ER_UNKNOWN_ERROR
1039
1040
alter table t1 order by a;
1040
1041
drop table t1;
1041
1042