diff options
| author | unknown <igor@rurik.mysql.com> | 2003-12-01 13:59:09 -0800 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2003-12-01 13:59:09 -0800 |
| commit | 17119e6de3bb9fa3c10e73c38474b13c3cdaa002 (patch) | |
| tree | 79a048b4126de29f6a79665954947219f2dbbb19 /mysql-test/t/null.test | |
| parent | 91de6fdbce2a5c545532acf1124f35378a75ea0c (diff) | |
| download | mariadb-git-17119e6de3bb9fa3c10e73c38474b13c3cdaa002.tar.gz | |
join_outer.result, null.result, null.test, item_cmpfunc.h:
Fixed inconsistency of values of used_tables_cache and
const_item_cache for Item_func_isnull objects (bug #1990).
sql/item_cmpfunc.h:
Fixed inconsistency of values of used_tables_cache and
const_item_cache for Item_func_isnull objects (bug #1990).
mysql-test/t/null.test:
Fixed inconsistency of values of used_tables_cache and
const_item_cache for Item_func_isnull objects (bug #1990).
mysql-test/r/null.result:
Fixed inconsistency of values of used_tables_cache and
const_item_cache for Item_func_isnull objects (bug #1990).
mysql-test/r/join_outer.result:
Fixed inconsistency of values of used_tables_cache and
const_item_cache for Item_func_isnull objects (bug #1990).
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 0be755ba7ad..5fa8f8a7651 100644 --- a/mysql-test/t/null.test +++ b/mysql-test/t/null.test @@ -86,3 +86,14 @@ INSERT INTO t1 (d) values (null),(null); select * from t1; drop table t1; +# +# Test to check elimination of IS NULL predicate for a non-nullable attribute +# (bug #1990) +# +create table t1 (a int not null, b int not null, index idx(a)); +insert into t1 values + (1,1), (2,2), (3,3), (4,4), (5,5), (6,6), + (7,7), (8,8), (9,9), (10,10), (11,11), (12,12); +explain select * from t1 where a between 2 and 3; +explain select * from t1 where a between 2 and 3 or b is null; +drop table t1; |