diff options
Diffstat (limited to 'mysql-test/main/selectivity_innodb.result')
-rw-r--r-- | mysql-test/main/selectivity_innodb.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/main/selectivity_innodb.result b/mysql-test/main/selectivity_innodb.result index 2159989597a..a51fd6494c9 100644 --- a/mysql-test/main/selectivity_innodb.result +++ b/mysql-test/main/selectivity_innodb.result @@ -878,18 +878,18 @@ set optimizer_use_condition_selectivity=1; EXPLAIN EXTENDED SELECT 1 FROM t1, t2 WHERE pk = 6 AND a = 2 AND b = 10; 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 1 AS `1` from `test`.`t1` join `test`.`t2` where 0 +Note 1003 select 1 AS `1` from `test`.`t1` join `test`.`t2` where multiple equal(6, NULL) and multiple equal(2, NULL) and multiple equal(10, `test`.`t2`.`b`) SELECT 1 FROM t1, t2 WHERE pk = 6 AND a = 2 AND b = 10; 1 set optimizer_use_condition_selectivity=3; EXPLAIN EXTENDED SELECT 1 FROM t1, t2 WHERE pk = 6 AND a = 2 AND b = 10; 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 1 AS `1` from `test`.`t1` join `test`.`t2` where 0 +Note 1003 select 1 AS `1` from `test`.`t1` join `test`.`t2` where multiple equal(6, NULL) and multiple equal(2, NULL) and multiple equal(10, `test`.`t2`.`b`) SELECT 1 FROM t1, t2 WHERE pk = 6 AND a = 2 AND b = 10; 1 DROP TABLE t1,t2; |