mondrian.rolap.sql
Class SqlQueryTest

java.lang.Object
  extended by junit.framework.Assert
      extended by junit.framework.TestCase
          extended by mondrian.test.FoodMartTestCase
              extended by mondrian.rolap.BatchTestCase
                  extended by mondrian.rolap.sql.SqlQueryTest
All Implemented Interfaces:
Test

public class SqlQueryTest
extends BatchTestCase

Test for SqlQuery

Since:
06-Jun-2007
Version:
$Id: //open/mondrian/testsrc/main/mondrian/rolap/sql/SqlQueryTest.java#26 $
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.FoodMartTestCase
propSaver
 
Constructor Summary
SqlQueryTest()
           
 
Method Summary
protected  void setUp()
           
protected  void tearDown()
           
 void testDoubleInList()
          Verifies that the correct SQL string is generated for literals of SQL type "double".
 void testInvalidSQLMemberLookup()
           
 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, checkNative, checkNative, checkNative, checkNotNative, checkNotNative, checkNotNative, createBatch, createBatch, dialectize, executeQuery, getCube, getFoodMartConnection, getGroupingSet, getMeasure
 
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, 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

SqlQueryTest

public SqlQueryTest()
Method Detail

setUp

protected void setUp()
              throws java.lang.Exception
Overrides:
setUp in class TestCase
Throws:
java.lang.Exception

tearDown

protected void tearDown()
                 throws java.lang.Exception
Overrides:
tearDown in class FoodMartTestCase
Throws:
java.lang.Exception

testToStringForSingleGroupingSetSql

public void testToStringForSingleGroupingSetSql()

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

Get Mondrian at SourceForge.net. Fast, secure and free Open Source software downloads