CURRENT_TEST: main.subselect_sj_jcl6

--- /usr/share/mysql/mysql-test/r/subselect_sj_jcl6.result	2013-11-25 20:09:44.000000000 +0100

+++ /dev/shm/var/2/log/subselect_sj_jcl6.reject	2013-11-25 21:49:23.971058629 +0100

@@ -2947,8 +2947,8 @@

 pk	c1	c2

 4	NULL	x

 3	c	x

-1	v	x

 2	v	x

+1	v	x

 5	x	x

 # This should show that "t1 left join t3" is still in the semi-join nest:

 EXPLAIN EXTENDED

SELECT * FROM t1, t2 WHERE pk IN ( SELECT pk FROM t1 LEFT JOIN t3 ON (c1 = c3 ) ) ORDER BY c2, c1;