diff options
| author | Igor Babaev <igor@askmonty.org> | 2013-10-11 23:24:57 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2013-10-11 23:24:57 -0700 |
| commit | 78b580b77965d63d4292a72a3ba12d0cc83b01a3 (patch) | |
| tree | 59075c51767ff2726dbfedc428206d6b1485b2f8 /mysql-test | |
| parent | 092a238864591bc540beb00145759fa6af5f2746 (diff) | |
| download | mariadb-git-78b580b77965d63d4292a72a3ba12d0cc83b01a3.tar.gz | |
Fixed bug mdev-5132.
Objects of the classes Item_func_isnull and Item_func_isnotnull
must have the flag sargable set to TRUE.
Set the value of the flag sargable only in constructors of the
classes inherited from Item_int_func.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/null.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/null.test | 12 |
2 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/null.result b/mysql-test/r/null.result index e62ba68c8f6..fe7ed32cbb0 100644 --- a/mysql-test/r/null.result +++ b/mysql-test/r/null.result @@ -373,3 +373,12 @@ id select_type table type possible_keys key key_len ref rows Extra SELECT * FROM t1 WHERE NOT (concat( dt, '1' ) IS NOT NULL); dt DROP TABLE t1; +# +# Bug mdev-5132: crash when exeicuting a join query +# with IS NULL and IS NOT NULL in where +# +CREATE TABLE t1 (a DATE, b INT, c INT, KEY(a), KEY(b), KEY(c)) ENGINE=MyISAM; +CREATE TABLE t2 (d DATE) ENGINE=MyISAM; +SELECT * FROM t1,t2 WHERE 1 IS NOT NULL AND t1.b IS NULL; +a b c d +DROP TABLE t1,t2; diff --git a/mysql-test/t/null.test b/mysql-test/t/null.test index 4a45240ec68..81951a9ce68 100644 --- a/mysql-test/t/null.test +++ b/mysql-test/t/null.test @@ -283,3 +283,15 @@ SELECT * FROM t1 WHERE NOT (concat( dt, '1' ) IS NOT NULL); SELECT * FROM t1 WHERE NOT (concat( dt, '1' ) IS NOT NULL); DROP TABLE t1; + +--echo # +--echo # Bug mdev-5132: crash when exeicuting a join query +--echo # with IS NULL and IS NOT NULL in where +--echo # + +CREATE TABLE t1 (a DATE, b INT, c INT, KEY(a), KEY(b), KEY(c)) ENGINE=MyISAM; +CREATE TABLE t2 (d DATE) ENGINE=MyISAM; + +SELECT * FROM t1,t2 WHERE 1 IS NOT NULL AND t1.b IS NULL; + +DROP TABLE t1,t2; |