Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
None
Description
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.
Attachments
Issue Links
- relates to
-
MDEV-9896 Testing for window functions
- Open