diff options
| author | Alexander Barkov <bar@mariadb.org> | 2016-06-28 13:11:04 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2016-06-28 13:11:04 +0400 |
| commit | 56a34960678874fad2ec99cc94c37f4e82dfccaa (patch) | |
| tree | dc4989b3e276d90ba3dda98735a2b841bf9183d3 /mysql-test/t/null.test | |
| parent | 64c115b835e4108c089fee7f0bb2f8e4022eae7b (diff) | |
| download | mariadb-git-56a34960678874fad2ec99cc94c37f4e82dfccaa.tar.gz | |
MDEV-10236 Where expression with NOT function gives incorrect result
Item_cache::is_null() erroneously returned null_value in a
non-cached state. Now Item_cache::is_null() uses has_value(),
which caches the value if not cached yet, similar to what other value methods do
(e.g. val_int, val_real, etc).
Diffstat (limited to 'mysql-test/t/null.test')
| -rw-r--r-- | mysql-test/t/null.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/null.test b/mysql-test/t/null.test index a5db4442183..84b3f069683 100644 --- a/mysql-test/t/null.test +++ b/mysql-test/t/null.test @@ -1008,5 +1008,16 @@ DROP TABLE t1; --echo # +--echo # MDEV-10236 Where expression with NOT function gives incorrect result +--echo # +CREATE TABLE t1 (c1 INT); +INSERT INTO t1 VALUES (1),(2),(3); +EXPLAIN EXTENDED +SELECT * FROM t1 WHERE ((c1 IS NOT NULL) >= (NOT TRUE)) IS NOT NULL; +SELECT * FROM t1 WHERE ((c1 IS NOT NULL) >= (NOT TRUE)) IS NOT NULL; +DROP TABLE t1; + + +--echo # --echo # End of 10.1 tests --echo # |