diff options
| author | unknown <msvensson@neptunus.(none)> | 2006-05-22 13:57:32 +0200 |
|---|---|---|
| committer | unknown <msvensson@neptunus.(none)> | 2006-05-22 13:57:32 +0200 |
| commit | 0dbe99f8aa4ead123c883c72546b1b62e8f509b9 (patch) | |
| tree | 5f8bb5c2257d3569c55fe8e0a0c0205b65b95d2f /mysql-test/t/join_outer.test | |
| parent | 38d09eb9059c9aa3ee58c55f7972827a7ecef86f (diff) | |
| download | mariadb-git-0dbe99f8aa4ead123c883c72546b1b62e8f509b9.tar.gz | |
Move innodb dependent test to join_outer_innodb
mysql-test/r/join_outer_innodb.result:
New BitKeeper file ``mysql-test/r/join_outer_innodb.result''
mysql-test/t/join_outer_innodb.test:
New BitKeeper file ``mysql-test/t/join_outer_innodb.test''
Diffstat (limited to 'mysql-test/t/join_outer.test')
| -rw-r--r-- | mysql-test/t/join_outer.test | 20 |
1 files changed, 2 insertions, 18 deletions
diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test index ca32df49ae3..e8afa701a84 100644 --- a/mysql-test/t/join_outer.test +++ b/mysql-test/t/join_outer.test @@ -2,8 +2,6 @@ # test of left outer join # ---source include/have_innodb.inc - --disable_warnings drop table if exists t0,t1,t2,t3,t4,t5; --enable_warnings @@ -763,24 +761,10 @@ DROP TABLE t1,t2; # # Test for bug #17164: ORed FALSE blocked conversion of outer join into join -# - -CREATE TABLE t1 (id int(11) NOT NULL PRIMARY KEY, name varchar(20), - INDEX (name)) ENGINE=InnoDB; -CREATE TABLE t2 (id int(11) NOT NULL PRIMARY KEY, fkey int(11), - FOREIGN KEY (fkey) REFERENCES t2(id)) ENGINE=InnoDB; -INSERT INTO t1 VALUES (1,'A1'),(2,'A2'),(3,'B'); -INSERT INTO t2 VALUES (1,1),(2,2),(3,2),(4,3),(5,3); - -EXPLAIN -SELECT COUNT(*) FROM t2 LEFT JOIN t1 ON t2.fkey = t1.id - WHERE t1.name LIKE 'A%'; +# -EXPLAIN -SELECT COUNT(*) FROM t2 LEFT JOIN t1 ON t2.fkey = t1.id - WHERE t1.name LIKE 'A%' OR FALSE; +# Test case moved to join_outer_innodb -DROP TABLE t1,t2; # # Bug 19396: LEFT OUTER JOIN over views in curly braces |