← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/t/join_outer_innodb.test

  • Committer: Monty Taylor
  • Date: 2008-07-02 14:35:48 UTC
  • mto: This revision was merged to the branch mainline in revision 51.
  • Revision ID: monty@inaugust.com-20080702143548-onj30ry0sugr01uw
Removed all references to THREAD.

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/t/join_outer_innodb.test
8
8
# Test for bug #17164: ORed FALSE blocked conversion of outer join into join
9
9
# 
10
10
 
11
 
CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, name varchar(20),
 
11
CREATE TABLE t1 (id int(11) NOT NULL PRIMARY KEY, name varchar(20),
12
12
                 INDEX (name)) ENGINE=InnoDB;
13
 
CREATE TABLE t2 (id int NOT NULL PRIMARY KEY, fkey int,
 
13
CREATE TABLE t2 (id int(11) NOT NULL PRIMARY KEY, fkey int(11),
14
14
                 FOREIGN KEY (fkey) REFERENCES t2(id)) ENGINE=InnoDB;
15
15
INSERT INTO t1 VALUES (1,'A1'),(2,'A2'),(3,'B');
16
16
INSERT INTO t2 VALUES (1,1),(2,2),(3,2),(4,3),(5,3);