diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2019-08-12 19:29:06 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-11-26 09:33:26 +0200 |
| commit | 4ba747855376d9b854dd2656ab8caf7b371ce13e (patch) | |
| tree | ff8c1573be999eee809187554b6d8dd0ce736347 | |
| parent | f809a4fbd069dc2986677eabde50b1a253f6695f (diff) | |
| download | mariadb-git-st-10.2-marko.tar.gz | |
add a test casest-10.2-marko
MDEV-20330 Combination of "," (comma), cross join and left join fails to parse
| -rw-r--r-- | mysql-test/r/join.result | 3 | ||||
| -rw-r--r-- | mysql-test/t/join.test | 5 |
2 files changed, 8 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 diff --git a/mysql-test/t/join.test b/mysql-test/t/join.test index 31eee0a7d5e..a875d247e64 100644 --- a/mysql-test/t/join.test +++ b/mysql-test/t/join.test @@ -1718,3 +1718,8 @@ 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 ); DROP TABLE t1,t2; + +# +# MDEV-20330 Combination of "," (comma), cross join and left join fails to parse +# +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; |