summaryrefslogtreecommitdiff
path: root/mysql-test/main/join_nested_jcl6.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/join_nested_jcl6.result')
-rw-r--r--mysql-test/main/join_nested_jcl6.result2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/main/join_nested_jcl6.result b/mysql-test/main/join_nested_jcl6.result
index eb59531b7d2..de5ebfbe989 100644
--- a/mysql-test/main/join_nested_jcl6.result
+++ b/mysql-test/main/join_nested_jcl6.result
@@ -1161,7 +1161,7 @@ a b a b
4 2 2 2
5 3 NULL NULL
SELECT t2.a,t2.b,t3.a,t3.b
-FROM t2 LEFT JOIN (t3) ON t2.b=t3.b
+FROM t2 LEFT JOIN t3 ON t2.b=t3.b
WHERE t2.a = 4 OR (t2.a > 4 AND t3.a IS NULL);
a b a b
4 2 1 2