mondrian.rolap.sql
Class SqlQueryTest

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

All Implemented Interfaces:

Test

public class SqlQueryTest
extends BatchTestCase

Test for SqlQuery

Since:

06-Jun-2007

Version:

$Id: //open/mondrian-release/3.0/testsrc/main/mondrian/rolap/sql/SqlQueryTest.java#2 $

Author:

Thiyagu

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

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	testPredicatesAreNotOptimizedWhenPropertyIsFalse()
void	testPredicatesAreOptimizedWhenAllTheMembersAreIncluded()
void	testPredicatesAreOptimizedWhenPropertyIsTrue()
void	testToStringForGroupingSetSqlWithEmptyGroup()
void	testToStringForMultipleGroupingSetsSql()
void	testToStringForSingleGroupingSetSql()

Methods inherited from class mondrian.rolap.BatchTestCase

assertNoQuerySql, assertQuerySql, assertQuerySql, assertQuerySql, assertQuerySqlOrNot, createBatch, createBatch, getCube, getFoodMartConnection, getGroupingSet, getMeasure

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

SqlQueryTest

public SqlQueryTest()

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

testToStringForSingleGroupingSetSql

public void testToStringForSingleGroupingSetSql()

testPredicatesAreOptimizedWhenPropertyIsTrue

public void testPredicatesAreOptimizedWhenPropertyIsTrue()

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.