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/testsrc/main/mondrian/rolap/sql/SqlQueryTest.java#26 $
- Author:
- Thiyagu
Fields inherited from class mondrian.rolap.BatchTestCase |
cubeNameSales, fieldGender, fieldProductDepartment, fieldProductFamily, fieldValueProductDepartment, fieldValuesGender, fieldValuesProductFamily, fieldValuesYear, fieldYear, measureUnitSales, tableCustomer, tableProductClass, tableTime |
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.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 |
SqlQueryTest
public SqlQueryTest()
setUp
protected void setUp()
throws Exception
- Overrides:
setUp
in class TestCase
- Throws:
Exception
tearDown
protected void tearDown()
throws Exception
- Overrides:
tearDown
in class FoodMartTestCase
- Throws:
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()