Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.5
    • Fix Version/s: 5.5.44
    • Component/s: Tests
    • Labels:
      None
    • Sprint:
      5.5.44

      Description

      http://buildbot.askmonty.org/buildbot/builders/work-amd64-valgrind/builds/7098/steps/test/logs/stdio

      main.group_by                            w6 [ fail ]
              Test ended at 2015-04-30 01:59:59
       
      CURRENT_TEST: main.group_by
      --- /var/lib/buildbot/maria-slave/work-opensuse-amd64/build/mysql-test/r/group_by.result	2015-04-29 18:00:03.000000000 +0300
      +++ /var/lib/buildbot/maria-slave/work-opensuse-amd64/build/mysql-test/r/group_by.reject	2015-04-30 01:59:59.000000000 +0300
      @@ -2345,7 +2345,7 @@
       insert into t2 values (1,11), (1,12), (2,22),(2,23), (4,44),(4,45);
       select distinct a,sum(b), (select d from t2 where c=a order by max(b) limit 1) from t1 group by a order by max(b);
       a	sum(b)	(select d from t2 where c=a order by max(b) limit 1)
      -1	23	11
      +1	23	12
       2	45	22
       4	89	44
       drop table t1, t2;

      It happened once so far, but is bound to happen again, as the query is non-deterministic, the subquery can return either 11 or 12.

      The test was added as a part of this commit:

      commit fbab0685a7b7f39db0217823ad90dd47034eae29
      Author: Sergei Golubchik <serg@mariadb.org>
      Date:   Tue Apr 28 13:57:21 2015 +0200
       
          post-merge changes, fixes, and tests

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: