Details
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
Gliffy Diagrams
Attachments
Issue Links
- relates to
-
MDEV-7069 Fix buildbot failures in main server trees
-
- Stalled
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
