diff options
| author | sergefp@mysql.com <> | 2005-03-11 02:26:38 +0300 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2005-03-11 02:26:38 +0300 |
| commit | f9322a85a40cf283d1721a5ca86ba0a6487d69ce (patch) | |
| tree | cbc4ca88ebc89fc01e2f360fbce77f93d2198a90 /mysql-test/t/join_outer.test | |
| parent | 759ad1a13e8a03e4247eb3caff88e8198d4a0911 (diff) | |
| parent | 763039a17b21d81782146728df7bdd823d2ed645 (diff) | |
| download | mariadb-git-f9322a85a40cf283d1721a5ca86ba0a6487d69ce.tar.gz | |
Merge mysql.com:/home/psergey/mysql-4.1-bug8711
into mysql.com:/home/psergey/mysql-5.0-bug8711
Diffstat (limited to 'mysql-test/t/join_outer.test')
| -rw-r--r-- | mysql-test/t/join_outer.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test index 66de5e5a4c9..7d85ab09b08 100644 --- a/mysql-test/t/join_outer.test +++ b/mysql-test/t/join_outer.test @@ -457,6 +457,19 @@ explain select * from t1 left join t2 on b1 = a1 left join t3 on c1 = a1 an drop table t1, t2, t3; +# Test for BUG#8711 '<=>' was considered to be a NULL-rejecting predicate. +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); +select * from t1 left join t2 on t1.a=t2.a having not (t2.a <=> t1.a); +drop table t1,t2; + # Test for BUG#5088 create table t1 ( |