diff options
| author | Igor Babaev <igor@askmonty.org> | 2013-11-21 15:19:25 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2013-11-21 15:19:25 -0800 |
| commit | c0f31dc9f3e0a42911beb6655a40601d2fddfe8e (patch) | |
| tree | eceda1a471f3179d772999bf15a77d282e226c45 /mysql-test/r/select.result | |
| parent | f8a6ee59acb082678cf601a10cbe9c1152748242 (diff) | |
| download | mariadb-git-c0f31dc9f3e0a42911beb6655a40601d2fddfe8e.tar.gz | |
Another attempt to fix bug mdev-5103.
The earlier pushed fix for the bug was incomplete. It did not remove
the main cause of the problem: the function remove_eq_conds()
removed always true multiple equalities from any conjunct, but did not
adjust the list of them stored in Item_cond_and::cond_equal.current_level.
Simplified the test case for the bug and moved it to another test file.
The fix triggered changes in EXPLAIN EXTENDED for some queries.
Diffstat (limited to 'mysql-test/r/select.result')
| -rw-r--r-- | mysql-test/r/select.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index f0de9622368..e8bcba8043a 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -5125,7 +5125,7 @@ SELECT * FROM t1 WHERE (1=2 OR t1.pk=2) AND t1.a <> 0; 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 2 AS `pk`,0 AS `a` from `test`.`t1` where ((0 <> 0)) +Note 1003 select 2 AS `pk`,0 AS `a` from `test`.`t1` where (0 <> 0) DROP TABLE t1; SELECT * FROM mysql.time_zone WHERE ( NOT (Use_leap_seconds <= Use_leap_seconds AND Time_zone_id != 1) |