diff options
| author | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2010-06-01 11:54:06 +0400 |
|---|---|---|
| committer | Sergey Glukhov <Sergey.Glukhov@sun.com> | 2010-06-01 11:54:06 +0400 |
| commit | 4d0177180779130c8f9dc950c682723fa2e22a9e (patch) | |
| tree | 61abe98647293962687d30556f76422c9235b5cb /mysql-test/t/join_outer.test | |
| parent | 8cef6205048a0522f966e7dccf14ce2ffdd37fe8 (diff) | |
| download | mariadb-git-4d0177180779130c8f9dc950c682723fa2e22a9e.tar.gz | |
test case fix
Diffstat (limited to 'mysql-test/t/join_outer.test')
| -rw-r--r-- | mysql-test/t/join_outer.test | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test index e7bc5cf6317..cf881e6aaa2 100644 --- a/mysql-test/t/join_outer.test +++ b/mysql-test/t/join_outer.test @@ -961,22 +961,22 @@ DROP TABLE t1, t2; CREATE TABLE t1(f1 INT, PRIMARY KEY (f1)); INSERT INTO t1 VALUES (1),(2); -EXPLAIN EXTENDED SELECT STRAIGHT_JOIN T1.f1 FROM t1 AS T1 - LEFT JOIN t1 AS T2 - RIGHT JOIN t1 AS T3 - JOIN t1 AS T4 ON 1 - LEFT JOIN t1 AS T5 ON 1 +EXPLAIN EXTENDED SELECT STRAIGHT_JOIN jt1.f1 FROM t1 AS jt1 + LEFT JOIN t1 AS jt2 + RIGHT JOIN t1 AS jt3 + JOIN t1 AS jt4 ON 1 + LEFT JOIN t1 AS jt5 ON 1 ON 1 - RIGHT JOIN t1 AS T6 ON T6.f1 + RIGHT JOIN t1 AS jt6 ON jt6.f1 ON 1; -EXPLAIN EXTENDED SELECT STRAIGHT_JOIN T1.f1 FROM t1 AS T1 - RIGHT JOIN t1 AS T2 - RIGHT JOIN t1 AS T3 - JOIN t1 AS T4 ON 1 - LEFT JOIN t1 AS T5 ON 1 +EXPLAIN EXTENDED SELECT STRAIGHT_JOIN jt1.f1 FROM t1 AS jt1 + RIGHT JOIN t1 AS jt2 + RIGHT JOIN t1 AS jt3 + JOIN t1 AS jt4 ON 1 + LEFT JOIN t1 AS jt5 ON 1 ON 1 - RIGHT JOIN t1 AS T6 ON T6.f1 + RIGHT JOIN t1 AS jt6 ON jt6.f1 ON 1; DROP TABLE t1; |