diff options
| author | Igor Babaev <igor@askmonty.org> | 2014-02-20 21:27:33 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2014-02-20 21:27:33 -0800 |
| commit | 3e03c9eae9089cd2cae0f378bd81ff29367f41eb (patch) | |
| tree | 59de03ac847622691243e92d7f90f8e1bc102098 /mysql-test/r/subselect_extra.result | |
| parent | 6ebaa4939e0a4e22491a4a251863f0b31af90829 (diff) | |
| download | mariadb-git-3e03c9eae9089cd2cae0f378bd81ff29367f41eb.tar.gz | |
After constant row substitution the optimizer should call the method
update_used_tables for the the where condition to update cached
indicators of constant subexpressions. It should be done before further
possible simplification of the where condition.
This change caused simplification of the executed where conditions
in many test cases.
Diffstat (limited to 'mysql-test/r/subselect_extra.result')
| -rw-r--r-- | mysql-test/r/subselect_extra.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/subselect_extra.result b/mysql-test/r/subselect_extra.result index d29d57c764c..7310157eb6c 100644 --- a/mysql-test/r/subselect_extra.result +++ b/mysql-test/r/subselect_extra.result @@ -46,7 +46,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Warnings: Note 1276 Field or reference 'test.t1.cur_date' of SELECT #2 was resolved in SELECT #1 -Note 1003 select 1 AS `id`,'2007-04-25 18:30:22' AS `cur_date` from `test`.`t1` semi join (`test`.`t1` `x1`) where ('2007-04-25 18:30:22' = 0) +Note 1003 select 1 AS `id`,'2007-04-25 18:30:22' AS `cur_date` from `test`.`t1` semi join (`test`.`t1` `x1`) where 0 select * from t1 where id in (select id from t1 as x1 where (t1.cur_date is null)); id cur_date @@ -57,7 +57,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra 1 PRIMARY NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Warnings: Note 1276 Field or reference 'test.t2.cur_date' of SELECT #2 was resolved in SELECT #1 -Note 1003 select 1 AS `id`,'2007-04-25' AS `cur_date` from `test`.`t2` semi join (`test`.`t2` `x1`) where ('2007-04-25' = 0) +Note 1003 select 1 AS `id`,'2007-04-25' AS `cur_date` from `test`.`t2` semi join (`test`.`t2` `x1`) where 0 select * from t2 where id in (select id from t2 as x1 where (t2.cur_date is null)); id cur_date |