summaryrefslogtreecommitdiff
path: root/mysql-test/t/join_outer.test
diff options
context:
space:
mode:
authormonty@mysql.com <>2005-07-28 17:09:54 +0300
committermonty@mysql.com <>2005-07-28 17:09:54 +0300
commit15d48525afc66df10f8f4e68c0a33a4e3ef2ae8c (patch)
treeefa95d21efbbc033b0cabce038118a09be44e9ac /mysql-test/t/join_outer.test
parentb3cbd0048fe5fe36fe4fba9ce591b0d1b26e10a1 (diff)
parent3c12d0ae54eccaef7c265af4f782d95250308dc9 (diff)
downloadmariadb-git-15d48525afc66df10f8f4e68c0a33a4e3ef2ae8c.tar.gz
Merge mysql.com:/home/my/mysql-4.1
into mysql.com:/home/my/mysql-5.0
Diffstat (limited to 'mysql-test/t/join_outer.test')
-rw-r--r--mysql-test/t/join_outer.test5
1 files changed, 2 insertions, 3 deletions
diff --git a/mysql-test/t/join_outer.test b/mysql-test/t/join_outer.test
index 7dd35f164d5..f48ae985e56 100644
--- a/mysql-test/t/join_outer.test
+++ b/mysql-test/t/join_outer.test
@@ -662,6 +662,8 @@ select group_concat(t1.b,t2.c) from t1 inner join t2 using(a) group by t1.a;
drop table t1, t2;
set group_concat_max_len=default;
+# End of 4.1 tests
+
#
# BUG#10162 - ON is merged with WHERE, left join is convered to a regular join
#
@@ -706,8 +708,5 @@ 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;
-