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/derived_view.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/derived_view.result')
| -rw-r--r-- | mysql-test/r/derived_view.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/derived_view.result b/mysql-test/r/derived_view.result index a37f9480e5c..acce2afb124 100644 --- a/mysql-test/r/derived_view.result +++ b/mysql-test/r/derived_view.result @@ -2243,7 +2243,7 @@ EXPLAIN EXTENDED SELECT a FROM v1 WHERE a > 100 ORDER BY b; 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 Warnings: -Note 1003 select 4 AS `a` from `test`.`t1` where (4 > 100) order by 1 +Note 1003 select 4 AS `a` from `test`.`t1` where 0 order by 1 DROP VIEW v1; DROP TABLE t1; CREATE TABLE IF NOT EXISTS `galleries` ( |