From 46325044d028315eeafed2d6539397e9c0787e24 Mon Sep 17 00:00:00 2001
From: "igor@rurik.mysql.com" <>
Date: Wed, 15 Jun 2005 02:02:25 -0700
Subject: 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.

---
 mysql-test/r/join_outer.result | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'mysql-test/r/join_outer.result')

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;
-- 
cgit v1.2.1