org.apache.derbyTesting.perf.basic.jdbc

Class SelectDistinctTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.junit.JDBCPerfTestCase

org.apache.derbyTesting.perf.basic.jdbc.SelectDistinctTest

All Implemented Interfaces:

junit.framework.Test

public class SelectDistinctTest
extends JDBCPerfTestCase

Performance tests for SELECT DISTINCT.

Field Summary

Fields

Modifier and Type	Field and Description
private static int	EXPECTED_DISTINCT_BINARY5 The number of distinct rows to be expected in the test for CHAR(5) FOR BIT DATA.
private static int	EXPECTED_DISTINCT_CHAR5 The number of distinct rows to be expected in the test for CHAR(5).
private java.sql.PreparedStatement	ps The prepared statement to be used in the test body.
private static java.lang.String	TEST_BINARY5 Name of the test case for CHAR(5) FOR BIT DATA, and the name of the table used by that test.
private static java.lang.String	TEST_CHAR5 Name of the test case for CHAR(5), and the name of the table used by that test.

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Modifier	Constructor and Description
private	SelectDistinctTest(java.lang.String name, int iterations, int repeats) Create a test case.

Method Summary

Modifier and Type	Method and Description
static byte[]	charToBinary(java.lang.String s) Stored function that converts an SQL CHAR value to an SQL CHAR FOR BIT DATA value.
void	selectDistinctBinary5() Test case for SELECT DISTINCT on a CHAR(5) FOR BIT DATA column.
void	selectDistinctChar5() Test case for SELECT DISTINCT on a CHAR(5) column.
protected void	setUp() Set up the test environment.
static junit.framework.Test	suite() Create the suite of all test cases in this class.
protected void	tearDown() Tear down the test environment.

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

runBareOverridable, runTest

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, runScript, runScript, runSQLCommands, setAutoCommit, 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, setName, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

ps

private java.sql.PreparedStatement ps

The prepared statement to be used in the test body.

TEST_CHAR5

private static final java.lang.String TEST_CHAR5

Name of the test case for CHAR(5), and the name of the table used by that test.

See Also:

Constant Field Values

EXPECTED_DISTINCT_CHAR5

private static final int EXPECTED_DISTINCT_CHAR5

The number of distinct rows to be expected in the test for CHAR(5). Since the table contains all permutations of "ABCDE", there should be 5! distinct rows.

See Also:

Constant Field Values

TEST_BINARY5

private static final java.lang.String TEST_BINARY5

Name of the test case for CHAR(5) FOR BIT DATA, and the name of the table used by that test.

See Also:

Constant Field Values

EXPECTED_DISTINCT_BINARY5

private static final int EXPECTED_DISTINCT_BINARY5

The number of distinct rows to be expected in the test for CHAR(5) FOR BIT DATA. Should be the same as in the test for CHAR(5).

See Also:

Constant Field Values

Constructor Detail

SelectDistinctTest

private SelectDistinctTest(java.lang.String name,
                           int iterations,
                           int repeats)

Create a test case.

Parameters:

name - the name of the test method, and the name of the table used in the test

iterations - the number of iterations in each test

repeats - the number of times each test should be repeated

Method Detail

suite

public static junit.framework.Test suite()

Create the suite of all test cases in this class.

Returns:

all test cases in this class

setUp

protected void setUp()
              throws java.sql.SQLException

Set up the test environment.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

tearDown

protected void tearDown()
                 throws java.lang.Exception

Tear down the test environment.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

charToBinary

public static byte[] charToBinary(java.lang.String s)
                           throws java.io.UnsupportedEncodingException

Stored function that converts an SQL CHAR value to an SQL CHAR FOR BIT DATA value.

Parameters:

s - the string to convert to binary data

Returns:

binary UTF-8 representation of the string

Throws:

java.io.UnsupportedEncodingException

selectDistinctChar5

public void selectDistinctChar5()
                         throws java.sql.SQLException

Test case for SELECT DISTINCT on a CHAR(5) column.

Throws:

java.sql.SQLException

selectDistinctBinary5

public void selectDistinctBinary5()
                           throws java.sql.SQLException

Test case for SELECT DISTINCT on a CHAR(5) FOR BIT DATA column.

Throws:

java.sql.SQLException