diff options
| author | serg@serg.mylan <> | 2005-03-13 16:34:40 +0100 |
|---|---|---|
| committer | serg@serg.mylan <> | 2005-03-13 16:34:40 +0100 |
| commit | 18343b9454e7711b8fea5319360f2f325d8d9d15 (patch) | |
| tree | 254e6f7485d61866406b23139ea1dfecd5af5896 /mysql-test/t/join_outer.test | |
| parent | a90d2bd97c9893b2a3df6f8aeeb315d589f4660c (diff) | |
| download | mariadb-git-18343b9454e7711b8fea5319360f2f325d8d9d15.tar.gz | |
correct not_null_tables() for XOR and AND
correct top_level_item for XOR
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; |