diff options
Diffstat (limited to 'mysql-test/main/subselect_sj_jcl6.result')
-rw-r--r-- | mysql-test/main/subselect_sj_jcl6.result | 10 |
1 files changed, 2 insertions, 8 deletions
diff --git a/mysql-test/main/subselect_sj_jcl6.result b/mysql-test/main/subselect_sj_jcl6.result index 2547d9bd487..cf99d246773 100644 --- a/mysql-test/main/subselect_sj_jcl6.result +++ b/mysql-test/main/subselect_sj_jcl6.result @@ -42,7 +42,7 @@ a b A confluent case of dependency explain select * from t1 where a in (select a from t10 where pk=12); id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +1 PRIMARY NULL NULL NULL NULL NULL NULL NULL no matching row in const table select * from t1 where a in (select a from t10 where pk=12); a b explain select * from t1 where a in (select a from t10 where pk=9); @@ -54,7 +54,7 @@ a b An empty table inside explain select * from t1 where a in (select a from t11); id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables +1 PRIMARY NULL NULL NULL NULL NULL NULL NULL no matching row in const table select * from t1 where a in (select a from t11); a b explain select * from t1 where a in (select pk from t10) and b in (select pk from t10); @@ -2304,14 +2304,8 @@ CREATE TABLE t3 (a int, b int) ; PREPARE st1 FROM "SELECT * FROM t2 LEFT JOIN t1 ON t2.a != 0 AND ('j','r') IN ( SELECT b,a FROM t3)"; EXECUTE st1; a a -Warnings: -Warning 1292 Truncated incorrect DECIMAL value: 'j' -Warning 1292 Truncated incorrect DECIMAL value: 'r' EXECUTE st1; a a -Warnings: -Warning 1292 Truncated incorrect DECIMAL value: 'j' -Warning 1292 Truncated incorrect DECIMAL value: 'r' DROP TABLE t1, t2, t3; # # BUG#849776: Wrong result with semijoin + "Impossible where" |