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/func_regexp.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/func_regexp.result')
| -rw-r--r-- | mysql-test/r/func_regexp.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/func_regexp.result b/mysql-test/r/func_regexp.result index 54aad23402f..4004520e47c 100644 --- a/mysql-test/r/func_regexp.result +++ b/mysql-test/r/func_regexp.result @@ -52,7 +52,7 @@ explain extended select * from t1 where xxx regexp('is a test of some long text id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 system NULL NULL NULL NULL 1 100.00 Warnings: -Note 1003 select 'this is a test of some long text to see what happens' AS `xxx` from `test`.`t1` where ('this is a test of some long text to see what happens' regexp 'is a test of some long text to') +Note 1003 select 'this is a test of some long text to see what happens' AS `xxx` from `test`.`t1` where 1 select * from t1 where xxx regexp('is a test of some long text to '); xxx this is a test of some long text to see what happens |