Package mondrian.rolap
Class GroupingSetQueryTest
- java.lang.Object
-
- TestCase
-
- mondrian.test.FoodMartTestCase
-
- mondrian.rolap.BatchTestCase
-
- mondrian.rolap.GroupingSetQueryTest
-
public class GroupingSetQueryTest extends BatchTestCase
Test support for generating SQL queries with theGROUPING SETS
construct, if the DBMS supports it.- Since:
- 08-Jun-2007
- Author:
- Thiyagu
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class mondrian.rolap.BatchTestCase
BatchTestCase.Bomb, BatchTestCase.CellRequestConstraint, BatchTestCase.TestCase, BatchTestCase.TestListener
-
-
Field Summary
-
Fields inherited from class mondrian.rolap.BatchTestCase
cubeNameSales, fieldGender, fieldProductDepartment, fieldProductFamily, fieldValueProductDepartment, fieldValuesGender, fieldValuesProductFamily, fieldValuesYear, fieldYear, measureUnitSales, tableCustomer, tableProductClass, tableTime
-
Fields inherited from class mondrian.test.FoodMartTestCase
propSaver
-
-
Constructor Summary
Constructors Constructor Description GroupingSetQueryTest()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description protected void
setUp()
protected void
tearDown()
void
testBug2004202()
Testcase for bug 2004202, "Except not working with grouping sets".void
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch()
void
testGroupingSetForMultipleColumnConstraint()
void
testGroupingSetForMultipleColumnConstraintAndCompoundConstraint()
void
testGroupingSetForMultipleMeasureAndSingleConstraint()
void
testGroupingSetForSingleColumnConstraint()
void
testGroupingSetsWithAggregateOverDefaultMember()
void
testNotUsingGroupingSet()
void
testNotUsingGroupingSetWhenGroupUsesDifferentAggregateTable()
-
Methods inherited from class mondrian.rolap.BatchTestCase
assertNative, assertNoQuerySql, assertNotNative, assertQuerySql, assertQuerySql, assertQuerySql, assertQuerySqlOrNot, assertRequestSql, assertRequestSql, checkNative, checkNative, checkNative, checkNotNative, checkNotNative, checkNotNative, clearAndHardenCache, createBatch, createBatch, createRequest, createRequest, createRequest, createRequest, dialectize, executeQuery, getCube, getFoodMartConnection, getGroupingSet, getMeasure, getRegistry, makeConstraintCountryState, makeConstraintProductFamilyDepartment, makeConstraintYearQuarterMonth, mysqlPattern, sqlPattern
-
Methods inherited from class mondrian.test.FoodMartTestCase
allMember, assertAxisReturns, assertAxisThrows, assertBooleanExprReturns, assertExprReturns, assertExprThrows, assertQueriesReturnSimilarResults, assertQueryReturns, assertQueryThrows, assertSize, cubeByName, execute, executeExpr, executeQuery, executeSingletonAxis, genderMembersIncludingAll, getConnection, getDimensionWithName, getTestContext, isDefaultNullMemberRepresentation, isGroupingSetsSupported, member, productMembersPotScrubbersPotsAndPans, storeMembersCAAndOR, storeMembersUsaAndCanada, verifySameNativeAndNot, warehouseMembersCanadaMexicoUsa
-
-
-
-
Method Detail
-
tearDown
protected void tearDown() throws Exception
- Overrides:
tearDown
in classFoodMartTestCase
- Throws:
Exception
-
testGroupingSetsWithAggregateOverDefaultMember
public void testGroupingSetsWithAggregateOverDefaultMember()
-
testGroupingSetForSingleColumnConstraint
public void testGroupingSetForSingleColumnConstraint()
-
testNotUsingGroupingSetWhenGroupUsesDifferentAggregateTable
public void testNotUsingGroupingSetWhenGroupUsesDifferentAggregateTable()
-
testNotUsingGroupingSet
public void testNotUsingGroupingSet()
-
testGroupingSetForMultipleMeasureAndSingleConstraint
public void testGroupingSetForMultipleMeasureAndSingleConstraint()
-
testGroupingSetForASummaryCanBeGroupedWith2DetailBatch
public void testGroupingSetForASummaryCanBeGroupedWith2DetailBatch()
-
testGroupingSetForMultipleColumnConstraint
public void testGroupingSetForMultipleColumnConstraint()
-
testGroupingSetForMultipleColumnConstraintAndCompoundConstraint
public void testGroupingSetForMultipleColumnConstraintAndCompoundConstraint()
-
testBug2004202
public void testBug2004202()
Testcase for bug 2004202, "Except not working with grouping sets".
-
-