Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.2
-
Fix Version/s: 10.2.2
-
Component/s: Optimizer - Window functions, Tests
-
Labels: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
-