diff options
| author | unknown <serg@serg.mylan> | 2005-03-13 16:34:40 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2005-03-13 16:34:40 +0100 |
| commit | 2427f3695ccd495eb33ce10c3fb3a636823e8850 (patch) | |
| tree | 254e6f7485d61866406b23139ea1dfecd5af5896 /mysql-test/t/join_outer.test | |
| parent | 7cecea527d5fcfa7c12c55ee3c95347ee8f43b15 (diff) | |
| download | mariadb-git-2427f3695ccd495eb33ce10c3fb3a636823e8850.tar.gz | |
correct not_null_tables() for XOR and AND
correct top_level_item for XOR
mysql-test/r/join_outer.result:
one more test
mysql-test/t/join_outer.test:
one more test
Diffstat (limited to 'mysql-test/t/join_outer.test')
| -rw-r--r-- | mysql-test/t/join_outer.test | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test index 2ed7086746f..fe9ec1e0963 100644 --- a/mysql-test/t/join_outer.test +++ b/mysql-test/t/join_outer.test @@ -610,6 +610,7 @@ SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.a; SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.a WHERE t1.b=1; SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.a WHERE t1.b=1 XOR (NOT ISNULL(t2.a) AND t2.b=1); +SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.a WHERE not(0+(t1.a=30 and t2.b=1)); DROP TABLE t1,t2; |