Class SqlQueryTest


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

      • SqlQueryTest

        public SqlQueryTest()
    • Method Detail

      • setUp

        protected void setUp()
                      throws java.lang.Exception
        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()
      • testOrderBy

        public void testOrderBy()
                         throws java.sql.SQLException
        Throws:
        java.sql.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.

      • 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 java.lang.Exception
        Throws:
        java.lang.Exception
      • testAvgAggregator

        public void testAvgAggregator()
        This is a test for MONDRIAN-1869

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