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/r/join_outer.result | |
| 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/r/join_outer.result')
| -rw-r--r-- | mysql-test/r/join_outer.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index 7981fc9c733..b035f88da41 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -857,4 +857,10 @@ a b a b 1 1 1 2 2 1 2 2 3 1 NULL NULL +SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.a WHERE not(0+(t1.a=30 and t2.b=1)); +a b a b +1 1 1 2 +2 1 2 2 +3 1 NULL NULL +4 2 NULL NULL DROP TABLE t1,t2; |