diff options
| author | unknown <igor@rurik.mysql.com> | 2005-06-15 02:02:25 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-06-15 02:02:25 -0700 |
| commit | 098d02eb44314448bb79ccf234241a41d09406f8 (patch) | |
| tree | c8de61fb09a90791472202aa385f53def48b8033 /mysql-test/r/join_outer.result | |
| parent | d5600efdc1ec98c1b9ef7190565788e7174e45f0 (diff) | |
| download | mariadb-git-098d02eb44314448bb79ccf234241a41d09406f8.tar.gz | |
join_outer.result, join_outer.test:
Added a test case for bug #11285.
sql_select.cc:
Fixed bug #11285.
The problem occurred with Item_equal in an 'on expression'
that was evaluated to false.
sql/sql_select.cc:
Fixed bug #11285.
The problem occurred with Item_equal in an 'on expression'
that was evaluated to false.
mysql-test/t/join_outer.test:
Added a test case for bug #11285.
mysql-test/r/join_outer.result:
Added a test case for bug #11285.
Diffstat (limited to 'mysql-test/r/join_outer.result')
| -rw-r--r-- | mysql-test/r/join_outer.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index e69e7603e21..b75eadd5291 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -975,3 +975,11 @@ EMPNUM NAME GRP 0 KERI 10 9 BARRY NULL DROP TABLE t1,t2; +CREATE TABLE t1 (c11 int); +CREATE TABLE t2 (c21 int); +INSERT INTO t1 VALUES (30), (40), (50); +INSERT INTO t2 VALUES (300), (400), (500); +SELECT * FROM t1 LEFT JOIN t2 ON (c11=c21 AND c21=30) WHERE c11=40; +c11 c21 +40 NULL +DROP TABLE t1, t2; |