|
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
|
|