diff options
Diffstat (limited to 'mysql-test/main/join_outer.result')
| -rw-r--r-- | mysql-test/main/join_outer.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/main/join_outer.result b/mysql-test/main/join_outer.result index b7fcb55e4fe..8eaebe9d635 100644 --- a/mysql-test/main/join_outer.result +++ b/mysql-test/main/join_outer.result @@ -2488,9 +2488,9 @@ ON t1.pk = t2.pk AND t2.v2 = tb1.v1 WHERE tb1.pk = 40 ORDER BY tb1.i1; id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL no matching row in const table Warnings: -Note 1003 select straight_join 'p' AS `v2` from `test`.`t1` join `test`.`t1` `tb1` left join `test`.`t1` `tb2` on(multiple equal(NULL, NULL)) where 0 order by NULL +Note 1003 select straight_join 'p' AS `v2` from `test`.`t1` join `test`.`t1` `tb1` left join `test`.`t1` `tb2` on(multiple equal(NULL, NULL)) where multiple equal(40, NULL) and multiple equal(10) and multiple equal('p', NULL) order by NULL EXPLAIN EXTENDED SELECT STRAIGHT_JOIN t2.v2 FROM @@ -2501,9 +2501,9 @@ ON t1.pk = t2.pk AND t2.v2 = tb1.v1 WHERE tb1.pk = 40 ORDER BY tb1.i1; id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL no matching row in const table Warnings: -Note 1003 select straight_join 'p' AS `v2` from `test`.`t1` join `test`.`t1` `tb1` left join `test`.`t1` `tb2` on(multiple equal(NULL, NULL)) where 0 order by NULL +Note 1003 select straight_join 'p' AS `v2` from `test`.`t1` join `test`.`t1` `tb1` left join `test`.`t1` `tb2` on(multiple equal(NULL, NULL)) where multiple equal(40, NULL) and multiple equal(10) and multiple equal('p', NULL) order by NULL SELECT STRAIGHT_JOIN DISTINCT t2.v2 FROM (t1 as tb1 LEFT JOIN t1 AS tb2 ON tb2.v1 = tb1.v2) |