Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
See for example
http://buildbot.askmonty.org/buildbot/builders/kvm-deb-lucid-amd64/builds/3238/steps/test_4/logs/stdio
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
|
The test is running
SELECT * FROM t1, t2 WHERE pk IN ( SELECT pk FROM t1 LEFT JOIN t3 ON (c1 = c3 ) ) ORDER BY c2, c1; |
but since (c1,c2) is not unique, the records (1,v,x) and (2,v,x) show up in the result set in sporadic order.