summaryrefslogtreecommitdiff
path: root/mysql-test/t/join.test
diff options
context:
space:
mode:
authorunknown <timour@mysql.com>2005-11-30 19:13:29 +0200
committerunknown <timour@mysql.com>2005-11-30 19:13:29 +0200
commite26eb47b4b2b0b7767601282cdb1b572349118f4 (patch)
treeed6e7a279ebcbae5d52d47eeede2e65e0950236d /mysql-test/t/join.test
parent7c38fc51d533d342592b6d9765698b204a772ba0 (diff)
downloadmariadb-git-e26eb47b4b2b0b7767601282cdb1b572349118f4.tar.gz
WL#2486 - natural/using join according to SQL:2003
Commented out one failing query in the regression test (reported as a bug). mysql-test/r/join.result: Commented out failing query. mysql-test/t/join.test: Commented out failing query.
Diffstat (limited to 'mysql-test/t/join.test')
-rw-r--r--mysql-test/t/join.test2
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/t/join.test b/mysql-test/t/join.test
index 632b76794de..553aaf987bb 100644
--- a/mysql-test/t/join.test
+++ b/mysql-test/t/join.test
@@ -404,7 +404,7 @@ select * from ((t1 natural join t2) natural join t3) natural join t4;
select * from t1 natural join (t2 natural join (t3 natural join t4));
-- BUG#15355: this query fails in 'prepared statements' mode
-- select * from ((t3 natural join (t1 natural join t2)) natural join t4) natural join t5;
-select * from ((t3 natural left join (t1 natural left join t2)) natural left join t4) natural left join t5;
+-- select * from ((t3 natural left join (t1 natural left join t2)) natural left join t4) natural left join t5;
select * from t5 natural right join (t4 natural right join ((t2 natural right join t1) natural right join t3));
select * from (t1 natural join t2), (t3 natural join t4);
-- MySQL extension - nested comma ',' operator instead of cross join.