LoptMetadataTest

Overview

Package

Class

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.lucidera.opt.test
Class LoptMetadataTest

java.lang.Object
  junit.framework.Assert
      junit.framework.TestCase
          org.eigenbase.test.DiffTestCase
              net.sf.farrago.test.ResultSetTestCase
                  net.sf.farrago.test.FarragoTestCase
                      net.sf.farrago.test.FarragoSqlToRelTestBase
                          com.lucidera.opt.test.LoptMetadataTest

All Implemented Interfaces:: Test

public class LoptMetadataTest
extends FarragoSqlToRelTestBase
extends FarragoSqlToRelTestBase

LoptMetadataTest tests the relational expression metadata queries relied on by the LucidDB optimizer.

NOTE jvs 11-Apr-2006: We don't actually diff the plans used as input to the metadata queries, because that's not what we're testing here. To see what you're getting while developing new tests (or when old ones break), set trace net.sf.farrago.query.plandump.level=FINE and check the trace output; you'll also be able to see rowcounts and cumulative costs for all expressions.

Version:: $Id: //open/dev/farrago/src/com/lucidera/opt/test/LoptMetadataTest.java#32 $
Author:: John V. Sichi

Nested Class Summary

Nested classes/interfaces inherited from class net.sf.farrago.test.FarragoTestCase
`FarragoTestCase.Cleanup, FarragoTestCase.CleanupFactory`

Field Summary
`private static long`	`COLSTORE_DEPTS_ROWCOUNT`
`private static long`	`COLSTORE_EMPS_ROWCOUNT`
`private static double`	`DEFAULT_EQUAL_SELECTIVITY`
`private static double`	`DEFAULT_ROWCOUNT`
`private static double`	`DEFAULT_SARGABLE_SELECTIVITY`
`private static boolean`	`doneStaticSetup`
`private static double`	`EPSILON`
`private HepProgram`	`program`
`private RexBuilder`	`rexBuilder`
`private RelNode`	`rootRel`
`private static long`	`SALES_EMPS_ROWCOUNT`
`private RelStatSource`	`tableStats`
`private FarragoReposTxnContext`	`txn`

Fields inherited from class net.sf.farrago.test.FarragoTestCase
`allocOwner, connection, preparedStmt, repos, stmt, tracer`

Fields inherited from class net.sf.farrago.test.ResultSetTestCase
`resultSet`

Fields inherited from class org.eigenbase.test.DiffTestCase
`logFile, logOutputStream, refFile`

Constructor Summary
`LoptMetadataTest(String testName)` Creates a new LoptMetadataTest object.

Method Summary
`protected void`	`checkAbstract(FarragoPreparingStmt stmt, RelNode relBefore)`
`private void`	`checkColumn(int ordinal, RexNode rexPredicate, Double selectivity, Double cardinality)`
`private void`	`checkCost(double costExpected, RelOptCost costActual)`
`private void`	`checkDistinctRowCount(String sql, BitSet groupKey, Double expected)`
`private void`	`checkDouble(Double expected, Double value, double epsilon)`
`private void`	`checkNoSimpleColumnOrigin(String sql)`
`private void`	`checkPredicate(int ordinal, SqlBinaryOperator operator, BigDecimal value, Double selectivity, Double cardinality)`
`private void`	`checkRowCount(String table, Double rowCount)`
`private void`	`checkRowCountJoin(String sql, Double expected)`
`static void`	`checkSimpleColumnOrigin(RelColumnOrigin rco, String expectedTableName, String expectedColumnName, boolean expectedDerived)`
`private Set<RelColumnOrigin>`	`checkSimpleColumnOrigin(String sql)`
`private void`	`checkSingleColumnOrigin(String sql, String expectedTableName, String expectedColumnName, boolean expectedDerived)`
`protected void`	`initPlanner(FarragoPreparingStmt stmt)`
`private void`	`localSetUp()`
`private void`	`localTearDown()`
`private RexNode`	`makeAndNode(RexNode a, RexNode b)`
`private RexNode`	`makeIntNode(int ordinal, SqlBinaryOperator operator, BigDecimal value)`
`private RexNode`	`makeOrNode(RexNode a, RexNode b)`
`private RexNode`	`makeSearchNode(int ordinal, RexLiteral value)`
`private RexNode`	`makeStringNode(int ordinal, SqlBinaryOperator operator, String str)`
`private void`	`searchColumn(int ordinal, RexLiteral value, Double selectivity, Double cardinality)`
`protected void`	`setUp()`
`static Test`	`suite()`
`void`	`tearDown()`
`void`	`testCumulativeCostAggregate()`
`void`	`testCumulativeCostFilter()`
`void`	`testCumulativeCostFilteredProjection()`
`void`	`testCumulativeCostFilteredProjectionSort()`
`void`	`testCumulativeCostRowScanWithInputs()`
`void`	`testCumulativeCostSelfJoin()`
`void`	`testCumulativeCostSemiJoin()`
`void`	`testCumulativeCostTable()`
`void`	`testCumulativeCostUnion()`
`void`	`testDistinctRowCountHashJoin()`
`void`	`testDistinctRowCountNonSargableFilter()`
`void`	`testDistinctRowCountNoStatsFilter()`
`void`	`testDistinctRowCountProjectedLcsTable()`
`void`	`testDistinctRowCountSargableFilter()`
`void`	`testDistinctRowCountSargAndNonSargFilters()`
`void`	`testDistinctRowCountTabNoFilter()`
`void`	`testDistinctRowCountUniqueTab()`
`void`	`testEmptyStatistics()`
`void`	`testFilteredStatistics()`
`void`	`testNotUniqueIfRidAboveJoin()`
`void`	`testPopulationHashJoin()`
`void`	`testPopulationNoProjExprs()`
`private void`	`testPopulationProjectedLcsTable(String sql, BitSet groupKey, double expected, double epsilon)`
`void`	`testPopulationProjFuncExpr()`
`void`	`testPopulationProjTimesExpr()`
`void`	`testRowCountDistinctUnion()`
`void`	`testRowCountHashJoin()`
`void`	`testRowCountJoinBigStats()`
`void`	`testRowCountJoinFtrs()`
`void`	`testRowCountJoinLcs()`
`void`	`testRowCountJoinNoColStats()`
`void`	`testRowCountJoinNonEquiJoin()`
`void`	`testRowCountLeftOuterJoinNoColStats()`
`void`	`testRowCountLeftSemiJoin()`
`void`	`testRowCountRightAntiJoin()`
`void`	`testRowCountRightOuterJoinNoColStats()`
`void`	`testRowCountRowScanWithInputs()`
`void`	`testSelectivityJoin()`
`void`	`testSelectivityLcsTableNoStats()`
`void`	`testSimpleColumnOriginProjectedRowScan()`
`void`	`testSimpleColumnOriginsAggregate()`
`void`	`testSimpleColumnOriginsJoin()`
`void`	`testSimpleColumnOriginsProjFilter()`
`void`	`testSimpleColumnOriginsUnion()`
`void`	`testTypedStatistics()`
`void`	`testUniqueKeysProjectedLcsTable()`
`void`	`testUniqueKeysProjectedLcsTableWhenNullsFiltered()`
`void`	`testUniqueRidColumn()`
`private void`	`transformQuery(HepProgram program, String sql)`
`private void`	`transformQuery(String sql)`

Methods inherited from class net.sf.farrago.test.FarragoSqlToRelTestBase
`addRulesAndCheckQuery, checkQuery`

Methods inherited from class net.sf.farrago.test.FarragoTestCase
`forceShutdown, getJdbcUri, getSession, getTestlogRoot, getTestlogRootStatic, newConnection, newJdbcEngineDriver, restoreParameters, restoreParameters, runCleanup, runSqlLineTest, runSqlLineTest, saveParameters, saveParameters, setRefFileDiffMasks, shouldDiff, staticSetUp, staticTearDown, tearDownImpl, wrappedSuite, wrappedSuite`

Methods inherited from class net.sf.farrago.test.ResultSetTestCase
`compareResultList, compareResultLists, compareResultSet, compareResultSetWithDelta, compareResultSetWithPattern, getResultSetCount`

Methods inherited from class org.eigenbase.test.DiffTestCase
`addDiffMask, addIgnorePattern, diffFile, diffLines, diffTestLog, fileContents, openTestLog, openTestLogOutputStream, setGC, setVerbose`

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, format`

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, format

Methods inherited from class java.lang.Object
`clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait`

Field Detail

doneStaticSetup

private static boolean doneStaticSetup

EPSILON

private static final double EPSILON

See Also:: Constant Field Values

SALES_EMPS_ROWCOUNT

private static final long SALES_EMPS_ROWCOUNT

See Also:: Constant Field Values

COLSTORE_EMPS_ROWCOUNT

private static final long COLSTORE_EMPS_ROWCOUNT

See Also:: Constant Field Values

COLSTORE_DEPTS_ROWCOUNT

private static final long COLSTORE_DEPTS_ROWCOUNT

See Also:: Constant Field Values

DEFAULT_EQUAL_SELECTIVITY

private static final double DEFAULT_EQUAL_SELECTIVITY

See Also:: Constant Field Values

DEFAULT_SARGABLE_SELECTIVITY

private static final double DEFAULT_SARGABLE_SELECTIVITY

See Also:: Constant Field Values

DEFAULT_ROWCOUNT

private static final double DEFAULT_ROWCOUNT

See Also:: Constant Field Values

program

private HepProgram program

rootRel

private RelNode rootRel

tableStats

private RelStatSource tableStats

rexBuilder

private RexBuilder rexBuilder

txn

private FarragoReposTxnContext txn

Constructor Detail