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:

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

Fields

Modifier and Type	Field and 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 and Description
SelectNotInGroupByTest()

Method Summary

Methods

Modifier and Type	Method and 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

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()