mondrian.rolap.sql
Class SelectNotInGroupByTest

java.lang.Object
  extended by junit.framework.Assert
      extended by junit.framework.TestCase
          extended by mondrian.test.FoodMartTestCase
              extended by mondrian.rolap.BatchTestCase
                  extended by mondrian.rolap.sql.SelectNotInGroupByTest
All Implemented Interfaces:
junit.framework.Test

public class SelectNotInGroupByTest
extends BatchTestCase

Test that various values of Dialect.allowsSelectNotInGroupBy() produce correctly optimized SQL.

Author:
Eric McDermid

Nested Class Summary
 
Nested classes/interfaces inherited from class mondrian.rolap.BatchTestCase
BatchTestCase.TestCase
 
Field Summary
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
SelectNotInGroupByTest()
           
 
Method Summary
 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
 
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, warehouseMembersCanadaMexicoUsa
 
Methods inherited from class junit.framework.TestCase
countTestCases, createResult, getName, run, run, runBare, runTest, setName, setUp, toString
 
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
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

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
Constructor Detail

SelectNotInGroupByTest

public SelectNotInGroupByTest()
Method Detail

testDependentPropertySkipped

public void testDependentPropertySkipped()

testIndependentPropertyNotSkipped

public void testIndependentPropertyNotSkipped()

testGroupBySkippedIfUniqueLevel

public void testGroupBySkippedIfUniqueLevel()

testGroupByNotSkippedIfIndependentProperty

public void testGroupByNotSkippedIfIndependentProperty()

Get Mondrian at SourceForge.net. Fast, secure and free Open Source software downloads