diff options
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/join.result | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/join.result b/mysql-test/r/join.result index 7d00536cbde..ac9ad8fc6a7 100644 --- a/mysql-test/r/join.result +++ b/mysql-test/r/join.result @@ -3308,3 +3308,6 @@ SELECT STRAIGHT_JOIN * FROM t1, t2 AS t2_1, t2 AS t2_2 WHERE t2_2.c = t2_1.c AND t2_2.b = t2_1.b AND ( a IS NULL OR t2_1.c = a ); a b c b c DROP TABLE t1,t2; +select a.a from (select 1 as a) a, (select 2 as b) b cross join (select 3 as c) c left join (select 4 as d) d on 1; +a +1 |