diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2021-11-29 11:16:20 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2021-11-29 11:16:20 +0200 |
| commit | d4cb1776030b643895da0532b75c051f55e84356 (patch) | |
| tree | 67ca086a5e0e0f0b959c8dd2080009bd51dc6a9b /mysql-test/main/join.result | |
| parent | ca2695392411adc7f1d19f85d464213128e4f285 (diff) | |
| parent | 4da22738765ecc31fe9e253d349ca6e9d0f5d985 (diff) | |
| download | mariadb-git-d4cb1776030b643895da0532b75c051f55e84356.tar.gz | |
Merge 10.4 into 10.5
Diffstat (limited to 'mysql-test/main/join.result')
| -rw-r--r-- | mysql-test/main/join.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/main/join.result b/mysql-test/main/join.result index d8eb9795b4e..b9543fc2c43 100644 --- a/mysql-test/main/join.result +++ b/mysql-test/main/join.result @@ -3315,6 +3315,9 @@ 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 # # MDEV-19600: The optimizer should be able to produce rows=1 estimate for unique index with NULLable columns # @@ -3403,3 +3406,4 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t3 ref a a 5 test.t2.key2 1 drop table t1,t2,t3; drop table t1000,t10,t03; +# End of 10.3 tests |