diff options
| author | igor@rurik.mysql.com <> | 2004-08-20 23:48:30 -0700 |
|---|---|---|
| committer | igor@rurik.mysql.com <> | 2004-08-20 23:48:30 -0700 |
| commit | 4b760fcb94cd06a9e344c829075043c7b8bc2898 (patch) | |
| tree | 5ece749a5af4e0c83b641ea542795cfcadac30cb /mysql-test/r/join_outer.result | |
| parent | 02e93b5758f6b2f06365ee711a223e9e579c82e3 (diff) | |
| download | mariadb-git-4b760fcb94cd06a9e344c829075043c7b8bc2898.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.
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 |