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/r/null.result | |
| 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/r/null.result')
| -rw-r--r-- | mysql-test/r/null.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/null.result b/mysql-test/r/null.result index 9de9fdce2db..f4decd3b79e 100644 --- a/mysql-test/r/null.result +++ b/mysql-test/r/null.result @@ -142,3 +142,14 @@ a b c d 0 0000-00-00 00:00:00 0 0 0000-00-00 00:00:00 0 drop table t1; +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; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 range idx idx 4 NULL 2 Using where +explain select * from t1 where a between 2 and 3 or b is null; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 range idx idx 4 NULL 2 Using where +drop table t1; |