← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/mix1.inc

  • Committer: Stewart Smith
  • Date: 2011-01-14 05:21:52 UTC
  • mto: (2086.1.3 build)
  • mto: This revision was merged to the branch mainline in revision 2087.
  • Revision ID: stewart@flamingspork.com-20110114052152-xnvlbrzvy3bx1ucd
add some FIXME to analyze docs.

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