Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5349

Test main.subselect_sj_jcl6 fails sporadically due to insufficient ordering

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: 5.5.35
        • Component/s: None
        • Labels:

          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.

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                dbart Daniel Bartholomew added a comment -

                http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/4009

                Show
                dbart Daniel Bartholomew added a comment - http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/4009

                  People

                  • Assignee:
                    psergey Sergei Petrunia
                    Reporter:
                    elenst Elena Stepanova
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: