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 (View Workflow)
    • 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.

        Attachments

          Activity

            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: