[#MDEV-5349] Test main.subselect_sj_jcl6 fails sporadically due to insufficient ordering

[MDEV-5349] Test main.subselect_sj_jcl6 fails sporadically due to insufficient ordering Created: 2013-11-26 Updated: 2014-01-29 Resolved: 2013-12-30
Status:	Closed
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	None
Fix Version/s:	5.5.35

Type:

Bug

Priority:

Major

Reporter:

Elena Stepanova

Assignee:

Sergei Petrunia

Resolution:

Fixed

Votes:

Labels:

buildbot, tests

Description

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.

Comments

Comment by Daniel Bartholomew [ 2014-01-29 ]

Generated at Thu Feb 08 07:03:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.