bk commit into 5.0 tree (timour:1.1911) BUG#4889

[timour]

Below is the list of changes that have just been committed into a local
5.0 repository of timka. When timka does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html

ChangeSet
  1.1911 05/08/23 20:24:29 timour@stripped +2 -0
  Test for BUG#4889 - inconsistent resilts of more than 2-way natural join
  due to incorrect transformation to JOIN ... ON.
  
  The bug itself is fixed by WL#2486.

  mysql-test/t/select.test
    1.71 05/08/23 20:24:26 timour@stripped +17 -0
    Test for BUG#4889.

  mysql-test/r/select.result
    1.86 05/08/23 20:24:26 timour@stripped +15 -0
    Test for BUG#4889.

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User:	timour
# Host:	lamia.home
# Root:	/home/timka/mysql/src/5.0-2486

--- 1.85/mysql-test/r/select.result	2005-08-23 20:03:29 +03:00
+++ 1.86/mysql-test/r/select.result	2005-08-23 20:24:26 +03:00
@@ -2860,3 +2860,18 @@
 2	2
 drop table t1, t2;
 drop view v2;
+create table t1 (a int(10), t1_val int(10));
+create table t2 (b int(10), t2_val int(10));
+create table t3 (a int(10), b int(10));
+insert into t1 values (1,1),(2,2);
+insert into t2 values (1,1),(2,2),(3,3);
+insert into t3 values (1,1),(2,1),(3,1),(4,1);
+select * from t1 natural join t2 natural join t3;
+a	b	t1_val	t2_val
+1	1	1	1
+2	1	2	1
+select * from t1 natural join t3 natural join t2;
+b	a	t1_val	t2_val
+1	1	1	1
+1	2	2	1
+drop table t1, t2, t3;

--- 1.70/mysql-test/t/select.test	2005-08-23 20:03:29 +03:00
+++ 1.71/mysql-test/t/select.test	2005-08-23 20:24:26 +03:00
@@ -2426,3 +2426,20 @@
 
 drop table t1, t2;
 drop view v2;
+
+
+#
+# Bug #4789 Incosistent results of more than 2-way natural joins due to
+#           incorrect transformation to join ... on.
+#
+
+create table t1 (a int(10), t1_val int(10));
+create table t2 (b int(10), t2_val int(10));
+create table t3 (a int(10), b int(10));
+insert into t1 values (1,1),(2,2);
+insert into t2 values (1,1),(2,2),(3,3);
+insert into t3 values (1,1),(2,1),(3,1),(4,1);
+# the following two queries must return the same result
+select * from t1 natural join t2 natural join t3;
+select * from t1 natural join t3 natural join t2;
+drop table t1, t2, t3;