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 java.lang.String
cubeA
static java.lang.String
queryCubeA
static java.lang.String
sqlWithAllGroupBy
static java.lang.String
sqlWithLevelGroupBy
static java.lang.String
sqlWithNoGroupBy
static java.lang.String
storeDimensionLevelDependent
static java.lang.String
storeDimensionLevelIndependent
static java.lang.String
storeDimensionUniqueLevelDependentProp
static java.lang.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 java.lang.String storeDimensionLevelIndependent
- See Also:
- Constant Field Values
-
storeDimensionLevelDependent
public static final java.lang.String storeDimensionLevelDependent
- See Also:
- Constant Field Values
-
storeDimensionUniqueLevelDependentProp
public static final java.lang.String storeDimensionUniqueLevelDependentProp
- See Also:
- Constant Field Values
-
storeDimensionUniqueLevelIndependentProp
public static final java.lang.String storeDimensionUniqueLevelIndependentProp
- See Also:
- Constant Field Values
-
cubeA
public static final java.lang.String cubeA
- See Also:
- Constant Field Values
-
queryCubeA
public static final java.lang.String queryCubeA
- See Also:
- Constant Field Values
-
sqlWithAllGroupBy
public static final java.lang.String sqlWithAllGroupBy
- See Also:
- Constant Field Values
-
sqlWithNoGroupBy
public static final java.lang.String sqlWithNoGroupBy
- See Also:
- Constant Field Values
-
sqlWithLevelGroupBy
public static final java.lang.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()
-
-