diff options
author | Sergey Petrunya <psergey@askmonty.org> | 2011-03-05 12:56:22 +0300 |
---|---|---|
committer | Sergey Petrunya <psergey@askmonty.org> | 2011-03-05 12:56:22 +0300 |
commit | 76165dc76064ea5942c9f62c16fc4f59264226fc (patch) | |
tree | a0d873238d72ecdf92fda12945cf14068e06dacb /mysql-test/r/null.result | |
parent | e59d56039407b62c6cb86a0277335456d7642c28 (diff) | |
download | mariadb-git-76165dc76064ea5942c9f62c16fc4f59264226fc.tar.gz |
BUG#727667 Wrong result with OR + NOT NULL in maria-5.3
- put the code that sets HA_NULL_PART bit back
- Fix test_if_ref/part_of_refkey() so that
= NULL-ability of lookup columns does not prevent the equality
from being removed (we now have early/late NULLs filtering which
will filter out NULL values)
= equality is not removed if it is ref_or_null access, and the value
of the lookup column can alternate between the lookup value and NULL.
Diffstat (limited to 'mysql-test/r/null.result')
-rw-r--r-- | mysql-test/r/null.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/null.result b/mysql-test/r/null.result index 897366787f1..7cadeb81c2c 100644 --- a/mysql-test/r/null.result +++ b/mysql-test/r/null.result @@ -170,7 +170,7 @@ insert into t1 select i*2 from t1; insert into t1 values(null); explain select * from t1 where i=2 or i is null; id select_type table type possible_keys key key_len ref rows Extra -1 SIMPLE t1 ref_or_null i i 5 const 9 Using index +1 SIMPLE t1 ref_or_null i i 5 const 9 Using where; Using index select count(*) from t1 where i=2 or i is null; count(*) 10 |