← 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: 2009-06-16 00:53:22 UTC
  • mto: This revision was merged to the branch mainline in revision 1094.
  • Revision ID: brian@gaz-20090616005322-w0ode4jul9z8s2y9
Partial fix for tests for tmp

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/include/mix1.inc
565
565
UPDATE t2 SET a = 'us' WHERE a = 'uk';
566
566
SELECT * FROM t2 WHERE a = 'uk';
567
567
 
568
 
CREATE TABLE t3 (a CHAR(2), KEY (a)) ENGINE = MyISAM;
 
568
CREATE TEMPORARY TABLE t3 (a CHAR(2), KEY (a)) ENGINE = MyISAM;
569
569
INSERT INTO t3 VALUES ('uk'),('bg');
570
570
SELECT * FROM t3 WHERE a = 'uk';
571
571
DELETE FROM t3 WHERE a = 'uk';
591
591
CREATE TABLE t2 (
592
592
  b int NOT NULL auto_increment PRIMARY KEY,
593
593
  c datetime NOT NULL
594
 
) ENGINE= MyISAM;
 
594
) ENGINE= InnoDB;
595
595
 
596
596
INSERT INTO t2(c) VALUES ('2007-01-01');
597
597
INSERT INTO t2(c) SELECT c FROM t2;