mondrian.rolap
Class FastBatchingCellReaderTest

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

All Implemented Interfaces:

junit.framework.Test

public class FastBatchingCellReaderTest
extends BatchTestCase

Test for FastBatchingCellReader.

Since:

24-May-2007

Author:

Thiyagu

Nested Class Summary

static class

FastBatchingCellReaderTest.MyDelegatingInvocationHandler

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

propSaver

Constructor Summary

FastBatchingCellReaderTest()

Method Summary

protected void	setUp()
protected void	tearDown()
void	testAddToCompositeBatchForAggregationBatchAlreadyPartOfACompositeBatch()
void	testAddToCompositeBatchForBothBatchAlreadyPartOfACompositeBatch()
void	testAddToCompositeBatchForBothBatchesNotPartOfCompositeBatch()
void	testAddToCompositeBatchForDetailedBatchAlreadyPartOfACompositeBatch()
void	testAggregateDistinctCount()
void	testAggregateDistinctCount2() As testAggregateDistinctCount(), but (a) calc member includes members from different levels and (b) also display [unit sales].
void	testAggregateDistinctCount3() As testAggregateDistinctCount2(), but with two calc members simultaneously.
void	testAggregateDistinctCount4() Distinct count over aggregate member which contains overlapping members.
void	testAggregateDistinctCount5() Fix a problem when genergating predicates for distinct count aggregate loading and using the aggregate function in the slicer.
void	testAggregateDistinctCount6()
void	testAggregateDistinctCountInDimensionFilter()
void	testCanBatchForBatchesFromSameAggregationButDifferentRollupOption()
void	testCanBatchForBatchWithConstraint()
void	testCanBatchForBatchWithConstraint2()
void	testCanBatchForBatchWithDifferentAggregationTable()
void	testCanBatchForBatchWithDistinctCountInAggregateBatch()
void	testCanBatchForBatchWithDistinctCountInDetailedBatch()
void	testCanBatchForSuperSet() Tests that can batch for batch with super set of contraint column bit key and all values for additional condition.
void	testCanBatchSummaryBatchWithDetailedBatchWithDistinctCount()
void	testCannotBatchTwoBatchesAtTheSameLevel()
void	testCompositeBatchLoadAggregation()
void	testDistinctCountBug1785406_2()
void	testDistinctCountBug1785406() Test case for bug 1785406 to fix "query already contains alias" exception.
void	testDoesDBSupportGroupingSets()
void	testGroupBatchesForGroupableBatches()
void	testGroupBatchesForGroupableBatchesAndNonGroupableBatches()
void	testGroupBatchesForNonGroupableBatchesWithConstraints()
void	testGroupBatchesForNonGroupableBatchesWithSorting()
void	testGroupBatchesForTwoSetOfGroupableBatches()
void	testInMemoryAggMax()
void	testInMemoryAggMin()
void	testInMemoryAggSum()
void	testLoadDistinctSqlMeasure() Checks that in dialects that request it (e.g.
void	testMissingSubtotalBugMetricFilter()
void	testMissingSubtotalBugMultiLevelMetricFilter()
void	testNonSuperSet() Test that can batch for batch with non superset of constraint column bit key and all values for additional condition.
void	testShouldUseGroupingFunctionOnPropertyFalseOnNonSupportedDB()
void	testShouldUseGroupingFunctionOnPropertyFalseOnSupportedDB()
void	testShouldUseGroupingFunctionOnPropertyTrueAndOnNonSupportedDB()
void	testShouldUseGroupingFunctionOnPropertyTrueAndOnSupportedDB()
void	testSuperSetAndNotAllValues() Tests that can batch for batch with super set of constraint column bit key and NOT all values for additional condition.
void	testSuperSetDifferentValues() Tests that Can Batch For Batch With Super Set Of Constraint Column Bit Key And Different Values For Overlapping Columns.

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, getRegistry, makeConstraintCountryState, makeConstraintProductFamilyDepartment, makeConstraintYearQuarterMonth

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, 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

FastBatchingCellReaderTest

public FastBatchingCellReaderTest()

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 FoodMartTestCase

Throws:

Exception

testMissingSubtotalBugMetricFilter

public void testMissingSubtotalBugMetricFilter()

testMissingSubtotalBugMultiLevelMetricFilter

public void testMissingSubtotalBugMultiLevelMetricFilter()

testShouldUseGroupingFunctionOnPropertyTrueAndOnSupportedDB

public void testShouldUseGroupingFunctionOnPropertyTrueAndOnSupportedDB()

testShouldUseGroupingFunctionOnPropertyTrueAndOnNonSupportedDB

public void testShouldUseGroupingFunctionOnPropertyTrueAndOnNonSupportedDB()

testShouldUseGroupingFunctionOnPropertyFalseOnSupportedDB

public void testShouldUseGroupingFunctionOnPropertyFalseOnSupportedDB()

testShouldUseGroupingFunctionOnPropertyFalseOnNonSupportedDB

public void testShouldUseGroupingFunctionOnPropertyFalseOnNonSupportedDB()

testDoesDBSupportGroupingSets

public void testDoesDBSupportGroupingSets()

testGroupBatchesForNonGroupableBatchesWithSorting

public void testGroupBatchesForNonGroupableBatchesWithSorting()

testGroupBatchesForNonGroupableBatchesWithConstraints

public void testGroupBatchesForNonGroupableBatchesWithConstraints()

testGroupBatchesForGroupableBatches

public void testGroupBatchesForGroupableBatches()

testGroupBatchesForGroupableBatchesAndNonGroupableBatches

public void testGroupBatchesForGroupableBatchesAndNonGroupableBatches()

testGroupBatchesForTwoSetOfGroupableBatches

public void testGroupBatchesForTwoSetOfGroupableBatches()

testAddToCompositeBatchForBothBatchesNotPartOfCompositeBatch

public void testAddToCompositeBatchForBothBatchesNotPartOfCompositeBatch()

testAddToCompositeBatchForDetailedBatchAlreadyPartOfACompositeBatch

public void testAddToCompositeBatchForDetailedBatchAlreadyPartOfACompositeBatch()

testAddToCompositeBatchForAggregationBatchAlreadyPartOfACompositeBatch

public void testAddToCompositeBatchForAggregationBatchAlreadyPartOfACompositeBatch()

testAddToCompositeBatchForBothBatchAlreadyPartOfACompositeBatch

public void testAddToCompositeBatchForBothBatchAlreadyPartOfACompositeBatch()

testCanBatchForSuperSet

public void testCanBatchForSuperSet()

Tests that can batch for batch with super set of contraint column bit key and all values for additional condition.

testCanBatchForBatchWithConstraint

public void testCanBatchForBatchWithConstraint()

testCanBatchForBatchWithConstraint2

public void testCanBatchForBatchWithConstraint2()

testCanBatchForBatchWithDistinctCountInDetailedBatch

public void testCanBatchForBatchWithDistinctCountInDetailedBatch()

testCanBatchForBatchWithDistinctCountInAggregateBatch

public void testCanBatchForBatchWithDistinctCountInAggregateBatch()

testCanBatchSummaryBatchWithDetailedBatchWithDistinctCount

public void testCanBatchSummaryBatchWithDetailedBatchWithDistinctCount()

testNonSuperSet

public void testNonSuperSet()

Test that can batch for batch with non superset of constraint column bit key and all values for additional condition.

testSuperSetAndNotAllValues

public void testSuperSetAndNotAllValues()

Tests that can batch for batch with super set of constraint column bit key and NOT all values for additional condition.

testCanBatchForBatchesFromSameAggregationButDifferentRollupOption

public void testCanBatchForBatchesFromSameAggregationButDifferentRollupOption()

testSuperSetDifferentValues

public void testSuperSetDifferentValues()

Tests that Can Batch For Batch With Super Set Of Constraint Column Bit Key And Different Values For Overlapping Columns.

testCanBatchForBatchWithDifferentAggregationTable

public void testCanBatchForBatchWithDifferentAggregationTable()

testCannotBatchTwoBatchesAtTheSameLevel

public void testCannotBatchTwoBatchesAtTheSameLevel()

testCompositeBatchLoadAggregation

public void testCompositeBatchLoadAggregation()
                                       throws Exception

Throws:

Exception

testLoadDistinctSqlMeasure

public void testLoadDistinctSqlMeasure()

Checks that in dialects that request it (e.g. LucidDB), distinct aggregates based on SQL expressions, e.g. count(distinct "col1" + "col2"), count(distinct query), are loaded individually, and separately from the other aggregates.

testAggregateDistinctCount

public void testAggregateDistinctCount()

testAggregateDistinctCount2

public void testAggregateDistinctCount2()

As testAggregateDistinctCount(), but (a) calc member includes members from different levels and (b) also display [unit sales].

testAggregateDistinctCount3

public void testAggregateDistinctCount3()

As testAggregateDistinctCount2(), but with two calc members simultaneously.

testAggregateDistinctCount4

public void testAggregateDistinctCount4()

Distinct count over aggregate member which contains overlapping members. Need to count them twice for rollable measures such as [Unit Sales], but not for distinct-count measures such as [Customer Count].

testAggregateDistinctCount5

public void testAggregateDistinctCount5()

Fix a problem when genergating predicates for distinct count aggregate loading and using the aggregate function in the slicer.

testAggregateDistinctCount6

public void testAggregateDistinctCount6()

testDistinctCountBug1785406

public void testDistinctCountBug1785406()

Test case for bug 1785406 to fix "query already contains alias" exception.

Note: 1785406 is a regression from checkin 9710. Code changes made in 9710 is no longer in use (and removed). So this bug will not occur; however, keeping the test case here to get some coverage for a query with a slicer.

testDistinctCountBug1785406_2

public void testDistinctCountBug1785406_2()

testAggregateDistinctCountInDimensionFilter

public void testAggregateDistinctCountInDimensionFilter()

testInMemoryAggSum

public void testInMemoryAggSum()
                        throws Exception

Throws:

Exception

testInMemoryAggMin

public void testInMemoryAggMin()
                        throws Exception

Throws:

Exception

testInMemoryAggMax

public void testInMemoryAggMax()
                        throws Exception

Throws:

Exception