mondrian.rolap.sql
Class SelectNotInGroupByTest
java.lang.Object
junit.framework.Assert
junit.framework.TestCase
mondrian.test.FoodMartTestCase
mondrian.rolap.BatchTestCase
mondrian.rolap.sql.SelectNotInGroupByTest
- All Implemented Interfaces:
- Test
public class SelectNotInGroupByTest
- extends BatchTestCase
Test that various values of Dialect.allowsSelectNotInGroupBy()
produce correctly optimized SQL.
- Version:
- $Id: //open/mondrian/testsrc/main/mondrian/rolap/sql/SelectNotInGroupByTest.java#4 $
- Author:
- Eric McDermid
Fields inherited from class mondrian.rolap.BatchTestCase |
cubeNameSales, fieldGender, fieldProductDepartment, fieldProductFamily, fieldValueProductDepartment, fieldValuesGender, fieldValuesProductFamily, fieldValuesYear, fieldYear, measureUnitSales, tableCustomer, tableProductClass, tableTime |
Methods inherited from class mondrian.rolap.BatchTestCase |
assertNative, assertNoQuerySql, assertNotNative, assertQuerySql, assertQuerySql, assertQuerySql, assertQuerySqlOrNot, checkNative, checkNative, checkNative, checkNotNative, checkNotNative, checkNotNative, createBatch, createBatch, dialectize, executeQuery, getCube, getFoodMartConnection, getGroupingSet, getMeasure |
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, getTestContext, isDefaultNullMemberRepresentation, isGroupingSetsSupported, member, productMembersPotScrubbersPotsAndPans, storeMembersCAAndOR, storeMembersUsaAndCanada, tearDown, warehouseMembersCanadaMexicoUsa |
Methods inherited from class junit.framework.Assert |
assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, fail, fail, failNotEquals, failNotSame, failSame |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
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
SelectNotInGroupByTest
public SelectNotInGroupByTest()
testDependentPropertySkipped
public void testDependentPropertySkipped()
testIndependentPropertyNotSkipped
public void testIndependentPropertyNotSkipped()
testGroupBySkippedIfUniqueLevel
public void testGroupBySkippedIfUniqueLevel()
testGroupByNotSkippedIfIndependentProperty
public void testGroupByNotSkippedIfIndependentProperty()