XplainStatisticsTest (Apache Derby V10.10 Test Javadoc)

java.lang.Object
- junit.framework.Assert
- - junit.framework.TestCase
  - - org.apache.derbyTesting.junit.BaseTestCase
    - - org.apache.derbyTesting.junit.BaseJDBCTestCase
      - org.apache.derbyTesting.functionTests.tests.lang.XplainStatisticsTest

All Implemented Interfaces:

junit.framework.Test
```
public class XplainStatisticsTest
extends BaseJDBCTestCase
```
This suite contains a set of tests for the new XPLAIN style of runtime statistics capturing which was added as part of DERBY-2487 and also a set of tests within tests generated under DERBY-2487 are added as part of DERBY-4587-PlanExporter tool. There are a large number of tests which follow the pattern of: - enable capture - execute a single statement - stop capture - verify that the right stuff was captured FIXME -- some general to-do items that I don't want to forget: - should resultSetNumber be its own column in sysxplain_resultsets? - need MORE tests of xplain-only mode - need a test of external sorting/merging - need to cross-check the result set types, and verify that they're all tested at least once

Nested Class Summary

Nested Classes
Modifier and Type	Class and Description
`private static class`	`XplainStatisticsTest.AbstractMTThread` Abstract class for a thread executing a database action (i.e. a query).
`private static class`	`XplainStatisticsTest.MTSimpleInvalidate` Thread for invalidating the COUNTRIES table in a loop.
`private static class`	`XplainStatisticsTest.MTSimpleSelect` Thread for selecting from the COUNTRIES table in a loop, with the XPLAIN- functionality enabled.

Field Summary

Fields
Modifier and Type Field and Description

private static java.lang.String[] tableNames

private static long timeSuiteStarted
- Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase
  DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Fields
Modifier and Type	Field and Description
`private static java.lang.String[]`	`tableNames`
`private static long`	`timeSuiteStarted`

Constructor Summary

Constructors
Constructor and Description

XplainStatisticsTest(java.lang.String name)

Constructors
Constructor and Description
`XplainStatisticsTest(java.lang.String name)`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`private static void`	`clearXplainOnlyMode(java.sql.Statement s)`
`private int`	`countNode(java.lang.String file)` Added by DERBY-4587 count the # of <node> elements
`private static void`	`createSchemaObjects(java.sql.Statement st)` Creates a variety of tables used by the various tests.
`private static void`	`disableXplainStyle(java.sql.Statement s)`
`private void`	`dumpResultSets(java.sql.Statement s)`
`private void`	`dumpStatements(java.sql.Statement s)`
`private static void`	`enableXplainOnlyMode(java.sql.Statement s)`
`private static void`	`enableXplainStyle(java.sql.Statement s)`
`private static void`	`enableXplainStyleWithTiming(java.sql.Statement s)`
`private java.lang.Object`	`getADocument(java.lang.String file)` Added by DERBY-4587
`private java.lang.String`	`getNodeAttribute(java.lang.String file, java.lang.String attribute, int node)` Added by DERBY-4587 gets attributes other than "name"
`private java.lang.String`	`getNodeName(java.lang.String file)` Added by DERBY-4587 gets the "name" attributes of all nodes separated by a "\|"
`private long`	`getNonNegativeLong(java.sql.ResultSet rs, java.lang.String cName)`
`private java.sql.Timestamp`	`getNonNullTimestamp(java.sql.ResultSet rs, java.lang.String cName)`
`private java.lang.String`	`getStmtID(java.sql.Statement s)` Added by DERBY-4587 Returns the stmt_id for this particular statement
`private java.lang.String[]`	`getStmtIDArray(java.sql.Statement s, int length)` Added by DERBY-4587 Returns the stmt_id for this particular statement
`private java.lang.String`	`getStmtIDByName(java.sql.Statement s, java.lang.String sName)`
`private static boolean`	`hasTable(java.sql.Statement s, java.lang.String schemaName, java.lang.String tableName)`
`private java.lang.String`	`readStatement(java.lang.String file)` Added by DERBY-4587 gets the <statement> element from the XML
`protected void`	`setUp()`
`static junit.framework.Test`	`suite()`
`void`	`testAggregationResultSet()` A simple test of an AGGREGATION result set.
`void`	`testAlwaysEmptyResultSet()` Test that run-time statistics are recorded even if the query has a predicate that always evaluates to false.
`void`	`testConstraintScan()` Verify XPLAIN style handling of a CONSTRAINT scan.
`void`	`testDDLCreateTable()` A simple test of capturing statistics for a DDL statement.
`void`	`testDeleteResultSet()` A simple test of an DELETE result set.
`void`	`testDistinctAggregateSortProps()` Verify XPLAIN style handling of DISTINCT_AGGREGATE sort properties.
`void`	`testGroupBySortProps()` Verify XPLAIN style handling of sort properties.
`void`	`testIndexScan()` Verify XPLAIN style handling of an INDEX scan.
`void`	`testInsertResultSet()` A simple test of an INSERT result set.
`void`	`testMaxFromIndex()` A simple test of the INDEX_KEY_OPT special situation.
`void`	`testOuterJoin()` A simple test of a LEFT OUTER JOIN and EMPTY_RIGHT_ROWS values.
`void`	`testPlanExporterEncoding()` Test that queries that contain non-ASCII characters are not garbled by the plan exporter tool.
`void`	`testPlanExporterHandlingSpecialCharacters()` Test that queries that contain characters with a special meaning in XML are not garbled by the plan exporter tool.
`void`	`testPlanExporterIllegalFileAccess()`
`void`	`testPlanExporterSchemaExistence()`
`void`	`testPlanExporterSpecialCharactersInSchema()` Verify that the plan exporter doesn't choke on special characters in the name of the XPLAIN schema.
`void`	`testScanDeletedRows()` A simple test of a non-zero value for numDeletedRowsVisited.
`void`	`testScanPositions()` A simple test to verify that startPosition and stopPosition work.
`void`	`testSimpleQuery()` Verify that XPLAIN style captures basic statistics and timings.
`void`	`testSimpleQueryMultiWithInvalidation()` Tests that invalidation of a statement after compile-time doesn't result in duplicate entries in the XPLAIN-table(s).
`void`	`testSimpleXplainOnly()`
`void`	`testSortResultSet()` A simple test of a SORT result set.
`void`	`testTableNotValid()` A simple test of table with the wrong 'shape'.
`void`	`testUnionQuery()` A simple test of a UNION query.
`void`	`testUpdateResultSet()` A simple test of an UPDATE result set.
`void`	`testXplainOnlyExecutePrepared()`
`void`	`testXplainOnlyPrepared()`
`private void`	`verifyNonNullDRDA_ID(java.sql.Statement s)`
`private void`	`verifySensibleResultSetTimings(java.sql.Statement s)` Make some basic first-order checks on the RESULTSET_TIMINGS rows.
`private void`	`verifySensibleStatementTimings(java.sql.Statement s)` Make some basic first-order checks on the STATEMENT_TIMINGS rows.
`private static void`	`verifyXplainUnset(java.sql.Statement s)`

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase
assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, emptyStatementCache, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runBareOverridable, runScript, runScript, runSQLCommands, setAutoCommit, tearDown, usingDB2Client, usingDerbyNetClient, usingEmbedded

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase
alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemProperty, sleep, sleepAtLeastOneTick, traceit

Methods inherited from class junit.framework.TestCase
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, countTestCases, createResult, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, run, runTest, setName, toString

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

- Field Detail
  - timeSuiteStarted
```
private static long timeSuiteStarted
```
  - tableNames
```
private static java.lang.String[] tableNames
```
- Constructor Detail
  - XplainStatisticsTest
```
public XplainStatisticsTest(java.lang.String name)
```
- Method Detail
  - suite
```
public static junit.framework.Test suite()
```
  - setUp
```
protected void setUp()
              throws java.sql.SQLException
```
    Overrides:
    
    setUp in class junit.framework.TestCase
    
    Throws:
    
    java.sql.SQLException
  - createSchemaObjects
```
private static void createSchemaObjects(java.sql.Statement st)
                                 throws java.sql.SQLException
```
    Creates a variety of tables used by the various tests. The tests use the same basic schema as the 'toursdb' sample database, with a much smaller set of data. We really only populate the COUNTRIES table; the other tables have few or no rows.
    
    Throws:
    
    java.sql.SQLException
  - hasTable
```
private static boolean hasTable(java.sql.Statement s,
                                java.lang.String schemaName,
                                java.lang.String tableName)
                         throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - enableXplainStyle
```
private static void enableXplainStyle(java.sql.Statement s)
                               throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - enableXplainStyleWithTiming
```
private static void enableXplainStyleWithTiming(java.sql.Statement s)
                                         throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - enableXplainOnlyMode
```
private static void enableXplainOnlyMode(java.sql.Statement s)
                                  throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - clearXplainOnlyMode
```
private static void clearXplainOnlyMode(java.sql.Statement s)
                                 throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - disableXplainStyle
```
private static void disableXplainStyle(java.sql.Statement s)
                                throws java.lang.Exception
```
    Parameters:
    
    s -
    
    Throws:
    
    java.lang.Exception
  - verifyXplainUnset
```
private static void verifyXplainUnset(java.sql.Statement s)
                               throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - verifyNonNullDRDA_ID
```
private void verifyNonNullDRDA_ID(java.sql.Statement s)
                           throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - dumpResultSets
```
private void dumpResultSets(java.sql.Statement s)
                     throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - dumpStatements
```
private void dumpStatements(java.sql.Statement s)
                     throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - getStmtID
```
private java.lang.String getStmtID(java.sql.Statement s)
                            throws java.sql.SQLException
```
    Added by DERBY-4587 Returns the stmt_id for this particular statement
    
    Parameters:
    
    s - Statement
    
    Returns:
    
    stmt_id
    
    Throws:
    
    java.sql.SQLException
  - getStmtIDArray
```
private java.lang.String[] getStmtIDArray(java.sql.Statement s,
                                          int length)
                                   throws java.sql.SQLException
```
    Added by DERBY-4587 Returns the stmt_id for this particular statement
    
    Parameters:
    
    s - Statement
    
    Returns:
    
    stmt_id
    
    Throws:
    
    java.sql.SQLException
  - getADocument
```
private java.lang.Object getADocument(java.lang.String file)
                               throws java.lang.Exception
```
    Added by DERBY-4587
    
    Parameters:
    
    file - name of the XML file - without extension
    
    Returns:
    
    a Document object
    
    Throws:
    
    java.lang.Exception
  - readStatement
```
private java.lang.String readStatement(java.lang.String file)
                                throws java.lang.Exception
```
    Added by DERBY-4587 gets the <statement> element from the XML
    
    Parameters:
    
    file - XML file
    
    Returns:
    
    statement mentioned in the XML
    
    Throws:
    
    java.lang.Exception
  - countNode
```
private int countNode(java.lang.String file)
               throws java.lang.Exception
```
    Added by DERBY-4587 count the # of <node> elements
    
    Parameters:
    
    file - XML file
    
    Returns:
    
    node count
    
    Throws:
    
    java.lang.Exception
  - getNodeName
```
private java.lang.String getNodeName(java.lang.String file)
                              throws java.lang.Exception
```
    Added by DERBY-4587 gets the "name" attributes of all nodes separated by a "|"
    
    Parameters:
    
    file - XML file
    
    Returns:
    
    "name" attribute's value of all nodes eg: "PROJECTION|TABLESCAN|"
    
    Throws:
    
    java.lang.Exception
  - getNodeAttribute
```
private java.lang.String getNodeAttribute(java.lang.String file,
                                          java.lang.String attribute,
                                          int node)
                                   throws java.lang.Exception
```
    Added by DERBY-4587 gets attributes other than "name"
    
    Parameters:
    
    file - XML file
    
    attribute - name of the attribute
    
    node - node which this attribute belongs to
    
    Returns:
    
    if attribute doesn't exist "" else value of the attribute
    
    Throws:
    
    java.lang.Exception
  - testPlanExporterSchemaExistence
```
public void testPlanExporterSchemaExistence()
                                     throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testPlanExporterIllegalFileAccess
```
public void testPlanExporterIllegalFileAccess()
                                       throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testPlanExporterSpecialCharactersInSchema
```
public void testPlanExporterSpecialCharactersInSchema()
                                               throws java.lang.Exception
```
    Verify that the plan exporter doesn't choke on special characters in the name of the XPLAIN schema. Regression test case for DERBY-4904.
    
    Throws:
    
    java.lang.Exception
  - testSimpleQueryMultiWithInvalidation
```
public void testSimpleQueryMultiWithInvalidation()
                                          throws java.lang.Exception
```
    Tests that invalidation of a statement after compile-time doesn't result in duplicate entries in the XPLAIN-table(s).
    This test is timing-dependent, and may not trigger the bug under all circumstances.
    See DERBY-4849.
    
    Throws:
    
    java.lang.Exception - if something goes wrong
  - testSimpleQuery
```
public void testSimpleQuery()
                     throws java.lang.Exception
```
    Verify that XPLAIN style captures basic statistics and timings. This test runs SELECT Country FROM Countries WHERE Region = 'Central America' and verifies that there are some reasonable values captured into the XPLAIN system tables.
    
    Throws:
    
    java.io.IOException
    
    java.security.PrivilegedActionException
    
    java.net.MalformedURLException
    
    java.lang.Exception
  - getStmtIDByName
```
private java.lang.String getStmtIDByName(java.sql.Statement s,
                                         java.lang.String sName)
                                  throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testSimpleXplainOnly
```
public void testSimpleXplainOnly()
                          throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testXplainOnlyExecutePrepared
```
public void testXplainOnlyExecutePrepared()
                                   throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testXplainOnlyPrepared
```
public void testXplainOnlyPrepared()
                            throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - verifySensibleStatementTimings
```
private void verifySensibleStatementTimings(java.sql.Statement s)
                                     throws java.sql.SQLException
```
    Make some basic first-order checks on the STATEMENT_TIMINGS rows. This method runs through the rows in the STATEMENT_TIMINGS table and makes some very high-level reasonableness checks: 1) The values for PARSE_TIME, BIND_TIME, OPTIMIZE_TIME, GENERATE_TIME, COMPILE_TIME, and EXECUTE_TIME should all be non-negative integer values. 2) The values of PARSE_TIME, BIND_TIME, OPTIMIZE_TIME, and GENERATE_TIME, summed together, should equal the value of COMPILE_TIME. 3) The values of BEGIN_COMP_TIME, END_COMP_TIME, BEGIN_EXE_TIME, and END_EXE_TIME should all be valid times, and should all be greater than the time when we started running these tests. 4) END_COMP_TIME should be G.E. BEGIN_COMP_TIME, BEGIN_EXE_TIME should be G.E. END_COMP_TIME, and END_EXE_TIME should be G.E. BEGIN_EXE_TIME
    
    Throws:
    
    java.sql.SQLException
  - verifySensibleResultSetTimings
```
private void verifySensibleResultSetTimings(java.sql.Statement s)
                                     throws java.sql.SQLException
```
    Make some basic first-order checks on the RESULTSET_TIMINGS rows. This method runs through the rows in the RESULTSET_TIMINGS table and makes some very simple checks for reasonableness of the values: 1) For each row in RESULTSETS, there should be a row in RESULTSET_TIMINGS 2) There should be non-negative values for CONSTRUCTOR_TIME, OPEN_TIME, NEXT_TIME, CLOSE_TIME, and EXECUTE_TIME. 3) If the result set has a non-zero value for RETURNED_ROWS, then there should be a non-negative value for AVG_NEXT_TIME_PER_ROW; conversely if the result set did not have any returned rows, then AVG_NEXT_TIME_PER_ROW should be null. 4) If the result set is a PROJECTION, then PROJECTION_TIME and RESTRICTION_TIME should have valid non-negative values; otherwise those columns should be NULL. 5) If the result set is a MATERIALIZE, then TEMP_CONG_CREATE_TIME and TEMP_CONG_FETCH_TIME should have valid non-negative values; otherwise those columns should be null.
    
    Throws:
    
    java.sql.SQLException
  - getNonNegativeLong
```
private long getNonNegativeLong(java.sql.ResultSet rs,
                                java.lang.String cName)
                         throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - getNonNullTimestamp
```
private java.sql.Timestamp getNonNullTimestamp(java.sql.ResultSet rs,
                                               java.lang.String cName)
                                        throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testIndexScan
```
public void testIndexScan()
                   throws java.lang.Exception
```
    Verify XPLAIN style handling of an INDEX scan. This test runs a query against FLIGHTS using the dest_airport index, and verifies the captured query plan statistics.
    
    Throws:
    
    java.lang.Exception
  - testConstraintScan
```
public void testConstraintScan()
                        throws java.lang.Exception
```
    Verify XPLAIN style handling of a CONSTRAINT scan. This test runs a query against COUNTRIES using the COUNTRY_ISO_CODE constraint, and verifies the captured query plan statistics.
    
    Throws:
    
    java.lang.Exception
  - testGroupBySortProps
```
public void testGroupBySortProps()
                          throws java.lang.Exception
```
    Verify XPLAIN style handling of sort properties. This test runs a simple query against the COUNTRIES table and verifies that reasonable values are captured for the sort properties.
    
    Throws:
    
    java.lang.Exception
  - testDistinctAggregateSortProps
```
public void testDistinctAggregateSortProps()
                                    throws java.lang.Exception
```
    Verify XPLAIN style handling of DISTINCT_AGGREGATE sort properties. This test runs a query which involves a distinct aggreagte and verifies that the DISTINCT_AGGREGATE field in SORT_PROPS gets set.
    
    Throws:
    
    java.lang.Exception
  - testAggregationResultSet
```
public void testAggregationResultSet()
                              throws java.lang.Exception
```
    A simple test of an AGGREGATION result set.
    
    Throws:
    
    java.lang.Exception
  - testInsertResultSet
```
public void testInsertResultSet()
                         throws java.lang.Exception
```
    A simple test of an INSERT result set.
    
    Throws:
    
    java.lang.Exception
  - testUpdateResultSet
```
public void testUpdateResultSet()
                         throws java.lang.Exception
```
    A simple test of an UPDATE result set.
    
    Throws:
    
    java.lang.Exception
  - testDeleteResultSet
```
public void testDeleteResultSet()
                         throws java.lang.Exception
```
    A simple test of an DELETE result set.
    
    Throws:
    
    java.lang.Exception
  - testSortResultSet
```
public void testSortResultSet()
                       throws java.lang.Exception
```
    A simple test of a SORT result set.
    
    Throws:
    
    java.lang.Exception
  - testUnionQuery
```
public void testUnionQuery()
                    throws java.lang.Exception
```
    A simple test of a UNION query.
    
    Throws:
    
    java.lang.Exception
  - testDDLCreateTable
```
public void testDDLCreateTable()
                        throws java.lang.Exception
```
    A simple test of capturing statistics for a DDL statement.
    
    Throws:
    
    java.lang.Exception
  - testMaxFromIndex
```
public void testMaxFromIndex()
                      throws java.lang.Exception
```
    A simple test of the INDEX_KEY_OPT special situation.
    
    Throws:
    
    java.lang.Exception
  - testOuterJoin
```
public void testOuterJoin()
                   throws java.lang.Exception
```
    A simple test of a LEFT OUTER JOIN and EMPTY_RIGHT_ROWS values.
    
    Throws:
    
    java.lang.Exception
  - testScanPositions
```
public void testScanPositions()
                       throws java.lang.Exception
```
    A simple test to verify that startPosition and stopPosition work.
    
    Throws:
    
    java.lang.Exception
  - testScanDeletedRows
```
public void testScanDeletedRows()
                         throws java.lang.Exception
```
    A simple test of a non-zero value for numDeletedRowsVisited.
    
    Throws:
    
    java.lang.Exception
  - testAlwaysEmptyResultSet
```
public void testAlwaysEmptyResultSet()
                              throws java.lang.Exception
```
    Test that run-time statistics are recorded even if the query has a predicate that always evaluates to false. Before DERBY-6268, the logic that saved the statistics would be short-circuited in such queries.
    
    Throws:
    
    java.lang.Exception
  - testTableNotValid
```
public void testTableNotValid()
                       throws java.sql.SQLException
```
    A simple test of table with the wrong 'shape'.
    
    Throws:
    
    java.sql.SQLException
  - testPlanExporterEncoding
```
public void testPlanExporterEncoding()
                              throws java.lang.Exception
```
    Test that queries that contain non-ASCII characters are not garbled by the plan exporter tool. Regression test case for DERBY-4902.
    
    Throws:
    
    java.lang.Exception
  - testPlanExporterHandlingSpecialCharacters
```
public void testPlanExporterHandlingSpecialCharacters()
                                               throws java.lang.Exception
```
    Test that queries that contain characters with a special meaning in XML are not garbled by the plan exporter tool. Regression test case for DERBY-4903.
    
    Throws:
    
    java.lang.Exception

Class XplainStatisticsTest

Nested Class Summary

Field Summary

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase

Constructor Summary

Method Summary

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase

Methods inherited from class junit.framework.TestCase

Methods inherited from class java.lang.Object

Field Detail

timeSuiteStarted

tableNames

Constructor Detail

XplainStatisticsTest

Method Detail

suite

setUp

createSchemaObjects

hasTable

enableXplainStyle

enableXplainStyleWithTiming

enableXplainOnlyMode

clearXplainOnlyMode

disableXplainStyle

verifyXplainUnset

verifyNonNullDRDA_ID

dumpResultSets

dumpStatements

getStmtID

getStmtIDArray

getADocument

readStatement

countNode

getNodeName

getNodeAttribute

testPlanExporterSchemaExistence

testPlanExporterIllegalFileAccess

testPlanExporterSpecialCharactersInSchema

testSimpleQueryMultiWithInvalidation

testSimpleQuery

getStmtIDByName

testSimpleXplainOnly

testXplainOnlyExecutePrepared

testXplainOnlyPrepared

verifySensibleStatementTimings

verifySensibleResultSetTimings

getNonNegativeLong

getNonNullTimestamp

testIndexScan

testConstraintScan

testGroupBySortProps

testDistinctAggregateSortProps

testAggregationResultSet

testInsertResultSet

testUpdateResultSet

testDeleteResultSet

testSortResultSet

testUnionQuery

testDDLCreateTable

testMaxFromIndex

testOuterJoin

testScanPositions

testScanDeletedRows

testAlwaysEmptyResultSet

testTableNotValid

testPlanExporterEncoding

testPlanExporterHandlingSpecialCharacters