mondrian.rolap
Class GroupingSetQueryTest

java.lang.Object
  junit.framework.Assert
      junit.framework.TestCase
          mondrian.test.FoodMartTestCase
              mondrian.rolap.BatchTestCase
                  mondrian.rolap.GroupingSetQueryTest

All Implemented Interfaces:

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

Version:

$Id: //open/mondrian-release/3.0/testsrc/main/mondrian/rolap/GroupingSetQueryTest.java#5 $

Author:

Thiyagu

Nested Class Summary

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

BatchTestCase.Bomb, BatchTestCase.CellRequestConstraint

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

nl

Constructor Summary

GroupingSetQueryTest()

Method Summary

protected void	setUp()
protected void	tearDown()
void	testAggregationOnMembersAndDefaultMemberForDistinctCount()
void	testBug2004202() Testcase for bug 2004202, "Except not working with grouping sets".
void	testGroupingSetForASummaryCanBeGroupedWith2DetailBatch()
void	testGroupingSetForMultipleColumnConstraint()
void	testGroupingSetForMultipleColumnConstraintAndCompoundConstraint()
void	testGroupingSetForMultipleMeasureAndSingleConstraint()
void	testGroupingSetForSingleColumnConstraint()
void	testNotUsingGroupingSet()
void	testNotUsingGroupingSetWhenGroupUsesDifferentAggregateTable()
void	testSQLForTotalOnCJofMembersWithDistinctCount()

Methods inherited from class mondrian.rolap.BatchTestCase

assertNoQuerySql, assertQuerySql, assertQuerySql, assertQuerySql, assertQuerySqlOrNot, assertRequestSql, createBatch, createBatch, createRequest, createRequest, createRequest, createRequest, getCube, getFoodMartConnection, getGroupingSet, getMeasure, makeConstraintCountryState, makeConstraintProductFamilyDepartment, makeConstraintYearQuarterMonth

Methods inherited from class mondrian.test.FoodMartTestCase

allMember, assertAxisReturns, assertAxisThrows, assertBooleanExprReturns, assertExprReturns, assertExprThrows, assertQueriesReturnSimilarResults, assertQueryReturns, assertSize, assertThrows, cubeByName, execute, executeExpr, executeQuery, executeSingletonAxis, fold, genderMembersIncludingAll, getConnection, getDimensionWithName, getTestContext, getTestContext, getTestContext, isDefaultNullMemberRepresentation, isGroupingSetsSupported, member, productMembersPotScrubbersPotsAndPans, storeMembersCAAndOR, storeMembersUsaAndCanada, 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, failNotEquals, failNotSame, failSame

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 TestCase

Throws:

Exception

tearDown

protected void tearDown()
                 throws Exception

Overrides:

tearDown in class TestCase

Throws:

Exception

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

testSQLForTotalOnCJofMembersWithDistinctCount

public void testSQLForTotalOnCJofMembersWithDistinctCount()

testAggregationOnMembersAndDefaultMemberForDistinctCount

public void testAggregationOnMembersAndDefaultMemberForDistinctCount()

testBug2004202

public void testBug2004202()

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