diff options
| author | sergefp@mysql.com <> | 2005-03-11 02:17:03 +0300 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2005-03-11 02:17:03 +0300 |
| commit | 5d865045c93e3429819c7840cbce0cd587331b17 (patch) | |
| tree | 1a23fa03e38a10c027a627f427f5eddeb9044b97 /mysql-test/r/join_outer.result | |
| parent | 4559fb998b8b9cc76e7801933889fbbeba05eb3a (diff) | |
| download | mariadb-git-5d865045c93e3429819c7840cbce0cd587331b17.tar.gz | |
Fix for BUG#8711: "<=>" may have true value for NULL arguments, so make
Item_func_equal::not_null_tables() always return 0.
Diffstat (limited to 'mysql-test/r/join_outer.result')
| -rw-r--r-- | mysql-test/r/join_outer.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index 5778b2f9b72..d6ce93e632b 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -684,3 +684,23 @@ t1 ALL NULL NULL NULL NULL 3 t2 ALL NULL NULL NULL NULL 2 t3 ALL NULL NULL NULL NULL 2 drop table t1, t2, t3; +create table t1 ( +a int(11), +b char(10), +key (a) +); +insert into t1 (a) values (1),(2),(3),(4); +create table t2 (a int); +select * from t1 left join t2 on t1.a=t2.a where not (t2.a <=> t1.a); +a b a +1 NULL NULL +2 NULL NULL +3 NULL NULL +4 NULL NULL +select * from t1 left join t2 on t1.a=t2.a having not (t2.a <=> t1.a); +a b a +1 NULL NULL +2 NULL NULL +3 NULL NULL +4 NULL NULL +drop table t1,t2; |