← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/innodb_mysql.result

  • 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/r/innodb_mysql.result
514
514
UPDATE t2 SET a = 'us' WHERE a = 'uk';
515
515
SELECT * FROM t2 WHERE a = 'uk';
516
516
a
517
 
CREATE TABLE t3 (a CHAR(2), KEY (a)) ENGINE = MyISAM;
 
517
CREATE TEMPORARY TABLE t3 (a CHAR(2), KEY (a)) ENGINE = MyISAM;
518
518
INSERT INTO t3 VALUES ('uk'),('bg');
519
519
SELECT * FROM t3 WHERE a = 'uk';
520
520
a
537
537
CREATE TABLE t2 (
538
538
b int NOT NULL auto_increment PRIMARY KEY,
539
539
c datetime NOT NULL
540
 
) ENGINE= MyISAM;
 
540
) ENGINE= InnoDB;
541
541
INSERT INTO t2(c) VALUES ('2007-01-01');
542
542
INSERT INTO t2(c) SELECT c FROM t2;
543
543
INSERT INTO t2(c) SELECT c FROM t2;