Class SqlQueryTest


  • public class SqlQueryTest
    extends BatchTestCase
    Test for SqlQuery.
    Since:
    06-Jun-2007
    Author:
    Thiyagu
    • Constructor Detail

      • SqlQueryTest

        public SqlQueryTest()
    • Method Detail

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

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