diff options
| author | igor@rurik.mysql.com <> | 2005-06-15 02:02:25 -0700 |
|---|---|---|
| committer | igor@rurik.mysql.com <> | 2005-06-15 02:02:25 -0700 |
| commit | 46325044d028315eeafed2d6539397e9c0787e24 (patch) | |
| tree | c8de61fb09a90791472202aa385f53def48b8033 /mysql-test/t/join_outer.test | |
| parent | f183b1be31213982199b37d2c0cfdb1732e32568 (diff) | |
| download | mariadb-git-46325044d028315eeafed2d6539397e9c0787e24.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.
Diffstat (limited to 'mysql-test/t/join_outer.test')
| -rw-r--r-- | mysql-test/t/join_outer.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test index 670e7433926..7dd35f164d5 100644 --- a/mysql-test/t/join_outer.test +++ b/mysql-test/t/join_outer.test @@ -698,4 +698,16 @@ SELECT * FROM v1 WHERE EMPNUM < 10; DROP TABLE t1,t2; +# +# Test for bug #11285: false Item_equal on expression in outer join +# + +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; + +DROP TABLE t1, t2; |