Details
-
Type:
Bug
-
Status:
Open
-
Priority:
Medium
-
Resolution: Unresolved
-
Affects Version/s: 3.2.0 GA (3.6.0 GA Suite Release)
-
Fix Version/s: 4.0 Backlog
-
Component/s: Native SQL
-
Labels:None
Description
Native evaluation does not respect ordering. MDX sets, unlike SQL sets, are deterministically ordered. So for instance {X, Y} * {A, B} must return {(X, A), (X, B), (Y, A), (Y, B)}.
Pushing the evaluation down to SQL is very desirable for performance reasons. However, the SQL results may come back in a different order. If the SQL is generated without an ORDER BY clause the results may be different for different databases.
One example of this failure is mondrian.test.clearview.SummaryTest.testRankExpandNonNative. It occurs on MySQL with mondrian.native.crossjoin.enable=true.
For other examples, search for this bug number, or uses of Bug.<ThisBug>Fixed.
Pushing the evaluation down to SQL is very desirable for performance reasons. However, the SQL results may come back in a different order. If the SQL is generated without an ORDER BY clause the results may be different for different databases.
One example of this failure is mondrian.test.clearview.SummaryTest.testRankExpandNonNative. It occurs on MySQL with mondrian.native.crossjoin.enable=true.
For other examples, search for this bug number, or uses of Bug.<ThisBug>Fixed.
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions