diff options
| author | Sergey Petrunya <psergey@askmonty.org> | 2013-07-31 17:24:52 +0400 |
|---|---|---|
| committer | Sergey Petrunya <psergey@askmonty.org> | 2013-07-31 17:24:52 +0400 |
| commit | 04684b7709f55a5a9de9226e834bcfbed05ee5c0 (patch) | |
| tree | 5771f2c3c0f2401e1eb9f6164ecf71eb0e002b91 /mysql-test/r/join_outer_innodb.result | |
| parent | 6fb1786584bc85db84e7ad184d6162d3208068c0 (diff) | |
| download | mariadb-git-04684b7709f55a5a9de9226e834bcfbed05ee5c0.tar.gz | |
MDEV-4817: Optimizer fails to optimize expression of the form 'FOO' IS NULL
- Modify the way Item_cond::fix_fields() and Item_cond::eval_not_null_tables()
calculate bitmap for Item_cond_or::not_null_tables():
if they see a "... OR inexpensive_const_false_item OR ..." then the item can
be ignored.
- Updated test results. There can be more warnings produced since parts of WHERE
are evaluated more times.
Diffstat (limited to 'mysql-test/r/join_outer_innodb.result')
| -rw-r--r-- | mysql-test/r/join_outer_innodb.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/join_outer_innodb.result b/mysql-test/r/join_outer_innodb.result index 1081fc0eed3..336fb5ee6b6 100644 --- a/mysql-test/r/join_outer_innodb.result +++ b/mysql-test/r/join_outer_innodb.result @@ -14,8 +14,8 @@ EXPLAIN SELECT COUNT(*) FROM t2 LEFT JOIN t1 ON t2.fkey = t1.id WHERE t1.name LIKE 'A%' OR FALSE; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t2 index NULL fkey 5 NULL 5 Using index -1 SIMPLE t1 eq_ref PRIMARY PRIMARY 4 test.t2.fkey 1 Using where +1 SIMPLE t1 index PRIMARY,name name 23 NULL 3 Using where; Using index +1 SIMPLE t2 ref fkey fkey 5 test.t1.id 1 Using index DROP TABLE t1,t2; # # BUG#58456: Assertion 0 in QUICK_INDEX_MERGE_SELECT::need_sorted_output |