mondrian.rolap.sql

Class SqlQueryTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

mondrian.test.PropertyRestoringTestCase

mondrian.test.FoodMartTestCase

mondrian.rolap.BatchTestCase

mondrian.rolap.sql.SqlQueryTest

All Implemented Interfaces:

junit.framework.Test

public class SqlQueryTest
extends BatchTestCase

Test for SqlQuery.

Since:

06-Jun-2007

Author:

Thiyagu

Nested Class Summary

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

BatchTestCase.TestCase

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

Method Summary

Modifier and Type	Method and Description
protected void	setUp()
protected void	tearDown()
void	testApproxRowCountOverridesCount() This test makes sure that a level which specifies an approxRowCount property prevents Mondrian from executing a count() sql query.
void	testAvgAggregator() This is a test for MONDRIAN-1869
void	testDoubleInList() Verifies that the correct SQL string is generated for literals of SQL type "double".
void	testInvalidSqlMemberLookup() Testcase for bug MONDRIAN-457, "Strange SQL condition appears when executing query".
void	testLimitedRollupMemberRetrievableFromCache()
void	testOrderBy()
void	testPredicatesAreNotOptimizedWhenPropertyIsFalse()
void	testPredicatesAreOptimizedWhenAllTheMembersAreIncluded()
void	testPredicatesAreOptimizedWhenPropertyIsTrue()
void	testTableNameIsIncludedWithParentChildQuery()
void	testToStringForForcedIndexHint()
void	testToStringForGroupingSetSqlWithEmptyGroup()
void	testToStringForMultipleGroupingSetsSql()
void	testToStringForSingleGroupingSetSql()

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

SqlQueryTest

public SqlQueryTest()

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

testToStringForSingleGroupingSetSql

public void testToStringForSingleGroupingSetSql()

testOrderBy

public void testOrderBy()
                 throws SQLException

Throws:

SQLException

testToStringForForcedIndexHint

public void testToStringForForcedIndexHint()

testPredicatesAreOptimizedWhenPropertyIsTrue

public void testPredicatesAreOptimizedWhenPropertyIsTrue()

testTableNameIsIncludedWithParentChildQuery

public void testTableNameIsIncludedWithParentChildQuery()

testPredicatesAreNotOptimizedWhenPropertyIsFalse

public void testPredicatesAreNotOptimizedWhenPropertyIsFalse()

testPredicatesAreOptimizedWhenAllTheMembersAreIncluded

public void testPredicatesAreOptimizedWhenAllTheMembersAreIncluded()

testToStringForGroupingSetSqlWithEmptyGroup

public void testToStringForGroupingSetSqlWithEmptyGroup()

testToStringForMultipleGroupingSetsSql

public void testToStringForMultipleGroupingSetsSql()

testDoubleInList

public void testDoubleInList()

Verifies that the correct SQL string is generated for literals of SQL type "double".

Mondrian only generates SQL DOUBLE values in a special format for LucidDB; therefore, this test is a no-op on other databases.

testInvalidSqlMemberLookup

public void testInvalidSqlMemberLookup()

Testcase for bug MONDRIAN-457, "Strange SQL condition appears when executing query". The fix implemented MatchType.EXACT_SCHEMA, which only queries known schema objects. This prevents SQL such as "UPPER(`store`.`store_country`) = UPPER('Time.Weekly')" from being generated.

testApproxRowCountOverridesCount

public void testApproxRowCountOverridesCount()

This test makes sure that a level which specifies an approxRowCount property prevents Mondrian from executing a count() sql query. It was discovered in bug MONDRIAN-711 that the aggregate tables predicates optimization code was not considering the approxRowCount property. It is fixed and this test will ensure it won't happen again.

testLimitedRollupMemberRetrievableFromCache

public void testLimitedRollupMemberRetrievableFromCache()
                                                 throws Exception

Throws:

Exception

testAvgAggregator

public void testAvgAggregator()

This is a test for MONDRIAN-1869

Avg Aggregates need to be computed in SQL to get correct values.