diff options
| author | unknown <igor@rurik.mysql.com> | 2004-08-20 23:48:30 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2004-08-20 23:48:30 -0700 |
| commit | c1fd20bb5ed75b4d6df24703e0b26a488eac4a3b (patch) | |
| tree | 5ece749a5af4e0c83b641ea542795cfcadac30cb /mysql-test/r/join_outer.result | |
| parent | 4f0e2da3169968b826f0b180dfe5de0ca99b40b9 (diff) | |
| download | mariadb-git-c1fd20bb5ed75b4d6df24703e0b26a488eac4a3b.tar.gz | |
null.test, null.result:
Added test case for bug #4256.
join_outer.result:
Fixed bug #4256.
item_cmpfunc.h:
Fixed inconsistency of values of used_tables_cache and
const_item_cache for Item_func_isnull objects.
This inconsistency caused bug #4256.
sql/item_cmpfunc.h:
Fixed inconsistency of values of used_tables_cache and
const_item_cache for Item_func_isnull objects.
This inconsistency caused bug #4256.
mysql-test/r/join_outer.result:
Fixed bug #4256.
mysql-test/r/null.result:
Added test case for bug #4256.
mysql-test/t/null.test:
Added test case for bug #4256.
Diffstat (limited to 'mysql-test/r/join_outer.result')
| -rw-r--r-- | mysql-test/r/join_outer.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index ae4d99e6241..5778b2f9b72 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -91,7 +91,7 @@ grp a c id a c d NULL NULL NULL NULL NULL NULL explain select t1.*,t2.* from t1,t2 where t1.a=t2.a and isnull(t2.a)=1; Comment -Impossible WHERE noticed after reading const tables +Impossible WHERE explain select t1.*,t2.* from t1 left join t2 on t1.a=t2.a where isnull(t2.a)=1; table type possible_keys key key_len ref rows Extra t1 ALL NULL NULL NULL NULL 7 |