|
All SELECTs which don't have explicit (and deterministic) ORDER BY clause should be preceded by --sorted_result. Otherwise they will produce sporadic failures, e.g.
CURRENT_TEST: main.win
|
--- /data/bld/10.2/mysql-test/r/win.result 2016-09-21 18:52:27.000000000 +0300
|
+++ /data/bld/10.2/mysql-test/r/win.reject 2016-09-22 00:01:47.668443074 +0300
|
@@ -86,10 +86,10 @@
|
2 0 1
|
3 1 3
|
4 1 3
|
-8 2 5
|
5 2 5
|
6 2 5
|
7 2 5
|
+8 2 5
|
9 4 9
|
10 4 9
|
select pk, a, rank() over (order by a desc) from t2;
|
@@ -98,10 +98,10 @@
|
2 0 9
|
3 1 7
|
4 1 7
|
-8 2 3
|
5 2 3
|
6 2 3
|
7 2 3
|
+8 2 3
|
9 4 1
|
10 4 1
|
drop table t2;
|
etc.
|