public void testOrderTupleSingleKeysNew() {
propSaver.set(
MondrianProperties.instance().CompareSiblingsByOrderKey, true);
// Use a fresh connection to make sure bad member ordinals haven't
// been assigned by previous tests.
final TestContext context = getTestContext().withFreshConnection();
try {
context.assertQueryReturns(
"with \n"
+ " set [NECJ] as \n"
+ " 'NonEmptyCrossJoin( \n"
+ " {[Customers].[USA].[WA].[Issaquah].[Abe Tramel],"
+ " [Customers].[All Customers].[USA].[CA].[Woodland Hills].[Abel Young],"
+ " [Customers].[All Customers].[USA].[CA].[Santa Monica].[Adeline Chun]},"
+ " {[Store].[USA].[WA].[Seattle],\n"
+ " [Store].[USA].[CA],\n"
+ " [Store].[USA].[OR]})'\n"
+ "select \n"
+ " Order([NECJ], [Customers].currentMember.OrderKey, BDESC) \n"
+ "on 0 from [Sales]",
"Axis #0:\n"
+ "{}\n"
+ "Axis #1:\n"
+ "{[Customers].[USA].[CA].[Santa Monica].[Adeline Chun], [Store].[USA].[CA]}\n"
+ "{[Customers].[USA].[CA].[Woodland Hills].[Abel Young], [Store].[USA].[CA]}\n"
+ "{[Customers].[USA].[WA].[Issaquah].[Abe Tramel], [Store].[USA].[WA].[Seattle]}\n"
+ "Row #0: 33\n"
+ "Row #0: 75\n"
+ "Row #0: 33\n");
} finally {
context.close();
}
}