diff options
-rw-r--r-- | mysql-test/r/selectivity.result | 8 | ||||
-rw-r--r-- | mysql-test/r/selectivity_innodb.result | 8 | ||||
-rw-r--r-- | mysql-test/t/selectivity.test | 2 |
3 files changed, 9 insertions, 9 deletions
diff --git a/mysql-test/r/selectivity.result b/mysql-test/r/selectivity.result index d2383f24f2d..3f2343fa365 100644 --- a/mysql-test/r/selectivity.result +++ b/mysql-test/r/selectivity.result @@ -1400,12 +1400,12 @@ Table Op Msg_type Msg_text test.t2 analyze status Engine-independent statistics collected test.t2 analyze status OK explain extended -select * from t2 A straight_join t2 B where A.a is null; +select * from t2 a straight_join t2 b where a.a is null; id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE A ALL NULL NULL NULL NULL 1000 100.00 Using where -1 SIMPLE B ALL NULL NULL NULL NULL 1000 100.00 Using join buffer (flat, BNL join) +1 SIMPLE a ALL NULL NULL NULL NULL 1000 100.00 Using where +1 SIMPLE b ALL NULL NULL NULL NULL 1000 100.00 Using join buffer (flat, BNL join) Warnings: -Note 1003 select `test`.`A`.`a` AS `a`,`test`.`A`.`b` AS `b`,`test`.`B`.`a` AS `a`,`test`.`B`.`b` AS `b` from `test`.`t2` `A` straight_join `test`.`t2` `B` where isnull(`test`.`A`.`a`) +Note 1003 select `test`.`a`.`a` AS `a`,`test`.`a`.`b` AS `b`,`test`.`b`.`a` AS `a`,`test`.`b`.`b` AS `b` from `test`.`t2` `a` straight_join `test`.`t2` `b` where isnull(`test`.`a`.`a`) set histogram_size=@save_histogram_size; set optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivity; drop table t0,t1,t2; diff --git a/mysql-test/r/selectivity_innodb.result b/mysql-test/r/selectivity_innodb.result index c4c398a9ff6..0b7f1c950e5 100644 --- a/mysql-test/r/selectivity_innodb.result +++ b/mysql-test/r/selectivity_innodb.result @@ -1410,12 +1410,12 @@ Table Op Msg_type Msg_text test.t2 analyze status Engine-independent statistics collected test.t2 analyze status OK explain extended -select * from t2 A straight_join t2 B where A.a is null; +select * from t2 a straight_join t2 b where a.a is null; id select_type table type possible_keys key key_len ref rows filtered Extra -1 SIMPLE A ALL NULL NULL NULL NULL 1000 100.00 Using where -1 SIMPLE B ALL NULL NULL NULL NULL 1000 100.00 Using join buffer (flat, BNL join) +1 SIMPLE a ALL NULL NULL NULL NULL 1000 100.00 Using where +1 SIMPLE b ALL NULL NULL NULL NULL 1000 100.00 Using join buffer (flat, BNL join) Warnings: -Note 1003 select `test`.`A`.`a` AS `a`,`test`.`A`.`b` AS `b`,`test`.`B`.`a` AS `a`,`test`.`B`.`b` AS `b` from `test`.`t2` `A` straight_join `test`.`t2` `B` where isnull(`test`.`A`.`a`) +Note 1003 select `test`.`a`.`a` AS `a`,`test`.`a`.`b` AS `b`,`test`.`b`.`a` AS `a`,`test`.`b`.`b` AS `b` from `test`.`t2` `a` straight_join `test`.`t2` `b` where isnull(`test`.`a`.`a`) set histogram_size=@save_histogram_size; set optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivity; drop table t0,t1,t2; diff --git a/mysql-test/t/selectivity.test b/mysql-test/t/selectivity.test index 5db6f3b9d6a..77ee5f49bef 100644 --- a/mysql-test/t/selectivity.test +++ b/mysql-test/t/selectivity.test @@ -935,7 +935,7 @@ set optimizer_use_condition_selectivity=4; analyze table t2 persistent for all; explain extended -select * from t2 A straight_join t2 B where A.a is null; +select * from t2 a straight_join t2 b where a.a is null; set histogram_size=@save_histogram_size; set optimizer_use_condition_selectivity=@save_optimizer_use_condition_selectivity; |