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

main.group_by failed in buildbot

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5
    • 5.5.44
    • Tests
    • None
    • 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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.