mondrian.rolap

Class GroupingSetQueryTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

mondrian.test.PropertyRestoringTestCase

mondrian.test.FoodMartTestCase

mondrian.rolap.BatchTestCase

mondrian.rolap.GroupingSetQueryTest

All Implemented Interfaces:

junit.framework.Test

public class GroupingSetQueryTest
extends BatchTestCase

Test support for generating SQL queries with the GROUPING SETS construct, if the DBMS supports it.

Since:

08-Jun-2007

Author:

Thiyagu

Nested Class Summary

Nested classes/interfaces inherited from class mondrian.rolap.BatchTestCase

BatchTestCase.Bomb, BatchTestCase.CellRequestConstraint, BatchTestCase.TestCase, BatchTestCase.TestListener

Field Summary

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.PropertyRestoringTestCase

propSaver

Constructor Summary

Constructors

Constructor and Description
GroupingSetQueryTest()

Method Summary

Modifier and Type	Method and Description
protected void	setUp()
protected void	tearDown()
void	testBug2004202() Testcase for bug 2004202, "Except not working with grouping sets".
void	testGroupingSetForASummaryCanBeGroupedWith2DetailBatch()
void	testGroupingSetForMultipleColumnConstraint()
void	testGroupingSetForMultipleColumnConstraintAndCompoundConstraint()
void	testGroupingSetForMultipleMeasureAndSingleConstraint()
void	testGroupingSetForSingleColumnConstraint()
void	testGroupingSetsWithAggregateOverDefaultMember()
void	testNotUsingGroupingSet()
void	testNotUsingGroupingSetWhenGroupUsesDifferentAggregateTable()

Methods inherited from class mondrian.rolap.BatchTestCase

assertNative, assertNoQuerySql, assertNotNative, assertQuerySql, assertQuerySql, assertQuerySql, assertQuerySqlOrNot, assertRequestSql, assertRequestSql, checkNative, checkNative, checkNative, checkNotNative, checkNotNative, checkNotNative, clearAndHardenCache, createBatch, createBatch, createRequest, createRequest, createRequest, createRequest, dialectize, executeQuery, getCube, getFoodMartConnection, getGroupingSet, getMeasure, getRegistry, makeConstraintCountryState, makeConstraintProductFamilyDepartment, makeConstraintYearQuarterMonth, 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, verifySameNativeAndNot, warehouseMembersCanadaMexicoUsa

Methods inherited from class junit.framework.TestCase

countTestCases, createResult, getName, run, run, runBare, runTest, setName, 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

Constructor Detail

GroupingSetQueryTest

public GroupingSetQueryTest()

Method Detail

setUp

protected void setUp()
              throws Exception

Overrides:

setUp in class junit.framework.TestCase

Throws:

Exception

tearDown

protected void tearDown()
                 throws Exception

Overrides:

tearDown in class PropertyRestoringTestCase

Throws:

Exception

testGroupingSetsWithAggregateOverDefaultMember

public void testGroupingSetsWithAggregateOverDefaultMember()

testGroupingSetForSingleColumnConstraint

public void testGroupingSetForSingleColumnConstraint()

testNotUsingGroupingSetWhenGroupUsesDifferentAggregateTable

public void testNotUsingGroupingSetWhenGroupUsesDifferentAggregateTable()

testNotUsingGroupingSet

public void testNotUsingGroupingSet()

testGroupingSetForMultipleMeasureAndSingleConstraint

public void testGroupingSetForMultipleMeasureAndSingleConstraint()

testGroupingSetForASummaryCanBeGroupedWith2DetailBatch

public void testGroupingSetForASummaryCanBeGroupedWith2DetailBatch()

testGroupingSetForMultipleColumnConstraint

public void testGroupingSetForMultipleColumnConstraint()

testGroupingSetForMultipleColumnConstraintAndCompoundConstraint

public void testGroupingSetForMultipleColumnConstraintAndCompoundConstraint()

testBug2004202

public void testBug2004202()

Testcase for bug 2004202, "Except not working with grouping sets".