Package mondrian.rolap.sql
Class SelectNotInGroupByTest
- java.lang.Object
-
- TestCase
-
- mondrian.test.FoodMartTestCase
-
- mondrian.rolap.BatchTestCase
-
- mondrian.rolap.sql.SelectNotInGroupByTest
-
public class SelectNotInGroupByTest extends BatchTestCase
Test that various values ofDialect.allowsSelectNotInGroupBy()
produce correctly optimized SQL.- Author:
- Eric McDermid
-
-
Nested Class Summary
-
Nested classes/interfaces inherited from class mondrian.rolap.BatchTestCase
BatchTestCase.TestCase
-
-
Field Summary
Fields Modifier and Type Field Description static String
cubeA
static String
queryCubeA
static String
sqlWithAllGroupBy
static String
sqlWithLevelGroupBy
static String
sqlWithNoGroupBy
static String
storeDimensionLevelDependent
static String
storeDimensionLevelIndependent
static String
storeDimensionUniqueLevelDependentProp
static String
storeDimensionUniqueLevelIndependentProp
-
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 SelectNotInGroupByTest()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
testDependentPropertySkipped()
void
testGroupByNotSkippedIfIndependentProperty()
void
testGroupBySkippedIfUniqueLevel()
void
testIndependentPropertyNotSkipped()
-
Methods inherited from class mondrian.rolap.BatchTestCase
assertNative, assertNoQuerySql, assertNotNative, assertQuerySql, assertQuerySql, assertQuerySql, assertQuerySqlOrNot, assertRequestSql, assertRequestSql, checkNative, checkNative, checkNative, checkNotNative, checkNotNative, checkNotNative, createBatch, createBatch, createRequest, createRequest, createRequest, createRequest, dialectize, executeQuery, getCube, getFoodMartConnection, getGroupingSet, getMeasure, 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, tearDown, verifySameNativeAndNot, warehouseMembersCanadaMexicoUsa
-
-
-
-
Field Detail
-
storeDimensionLevelIndependent
public static final String storeDimensionLevelIndependent
- See Also:
- Constant Field Values
-
storeDimensionLevelDependent
public static final String storeDimensionLevelDependent
- See Also:
- Constant Field Values
-
storeDimensionUniqueLevelDependentProp
public static final String storeDimensionUniqueLevelDependentProp
- See Also:
- Constant Field Values
-
storeDimensionUniqueLevelIndependentProp
public static final String storeDimensionUniqueLevelIndependentProp
- See Also:
- Constant Field Values
-
cubeA
public static final String cubeA
- See Also:
- Constant Field Values
-
queryCubeA
public static final String queryCubeA
- See Also:
- Constant Field Values
-
sqlWithAllGroupBy
public static final String sqlWithAllGroupBy
- See Also:
- Constant Field Values
-
sqlWithNoGroupBy
public static final String sqlWithNoGroupBy
- See Also:
- Constant Field Values
-
sqlWithLevelGroupBy
public static final String sqlWithLevelGroupBy
- See Also:
- Constant Field Values
-
-
Method Detail
-
testDependentPropertySkipped
public void testDependentPropertySkipped()
-
testIndependentPropertyNotSkipped
public void testIndependentPropertyNotSkipped()
-
testGroupBySkippedIfUniqueLevel
public void testGroupBySkippedIfUniqueLevel()
-
testGroupByNotSkippedIfIndependentProperty
public void testGroupByNotSkippedIfIndependentProperty()
-
-