org.apache.derbyTesting.functionTests.tests.lang

Class DistinctTest

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

All Implemented Interfaces:

junit.framework.Test

public class DistinctTest
extends BaseJDBCTestCase

Tests for DISTINCT. These tests mostly assume: no indexes, no order by, no grouping

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
DistinctTest(java.lang.String name)

Method Summary

Modifier and Type	Method and Description
void	assertRowCount(int count, java.sql.ResultSet rs) Assert that the number of rows in the result set matches what we are expecting.
private void	checkDistinctRows(int[] rowcounts) Runs a set of 37 SQL queries on the current data in table t, testing a number of different column combinations, predicates, and subqueries.
static junit.framework.Test	suite()
void	testBasicDistinct()
void	testDistinctElimination() Tests queries where distinct scan is eliminated.
void	testDistinctFiltering()
void	testDistinctIdenticalAndDifferingRows()
void	testDistinctIdenticalNullRows()
void	testDistinctInInsert()
void	testDistinctInsertWithGeneratedColumn() This test demonstrates that using distinct in a query for insert does not cause gaps in numbering in autoincremented columns.
void	testDistinctInValuesClause()
void	testDistinctManyNullRows()
void	testDistinctMixedNullRows()
void	testDistinctPaddingInVarcharIgnored()
void	testDistinctScanForSubquery() Tests for DERBY-504 (select distinct from a subquery)
void	testDistinctSomeNullRows()
void	testDistinctStoreSort()
void	testDistinctSyntaxErrors()
void	testDistinctTwoVaryingRows()
void	testDistinctWithBigInt()
void	testDistinctWithUpdatedRows()
void	testIdenticalRows()
void	testNoData()
void	testOneRow()
void	testResultSetInOrderWhenUsingIndex()

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, setUp, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

DistinctTest

public DistinctTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

testNoData

public void testNoData()
                throws java.sql.SQLException

Throws:

java.sql.SQLException

testOneRow

public void testOneRow()
                throws java.sql.SQLException

Throws:

java.sql.SQLException

testIdenticalRows

public void testIdenticalRows()
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctIdenticalAndDifferingRows

public void testDistinctIdenticalAndDifferingRows()
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctTwoVaryingRows

public void testDistinctTwoVaryingRows()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctIdenticalNullRows

public void testDistinctIdenticalNullRows()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctSomeNullRows

public void testDistinctSomeNullRows()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctManyNullRows

public void testDistinctManyNullRows()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctMixedNullRows

public void testDistinctMixedNullRows()
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctInValuesClause

public void testDistinctInValuesClause()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctSyntaxErrors

public void testDistinctSyntaxErrors()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

testBasicDistinct

public void testBasicDistinct()
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctPaddingInVarcharIgnored

public void testDistinctPaddingInVarcharIgnored()
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctWithBigInt

public void testDistinctWithBigInt()
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctWithUpdatedRows

public void testDistinctWithUpdatedRows()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctInInsert

public void testDistinctInInsert()
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctInsertWithGeneratedColumn

public void testDistinctInsertWithGeneratedColumn()
                                           throws java.sql.SQLException

This test demonstrates that using distinct in a query for insert does not cause gaps in numbering in autoincremented columns. Before DERBY-3 was fixed, there could be gaps.

Throws:

java.sql.SQLException

testResultSetInOrderWhenUsingIndex

public void testResultSetInOrderWhenUsingIndex()
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctStoreSort

public void testDistinctStoreSort()
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

testDistinctScanForSubquery

public void testDistinctScanForSubquery()
                                 throws java.sql.SQLException

Tests for DERBY-504 (select distinct from a subquery)

Throws:

java.sql.SQLException

testDistinctElimination

public void testDistinctElimination()
                             throws java.sql.SQLException

Tests queries where distinct scan is eliminated.

Throws:

java.sql.SQLException

testDistinctFiltering

public void testDistinctFiltering()
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

checkDistinctRows

private void checkDistinctRows(int[] rowcounts)
                        throws java.sql.SQLException

Runs a set of 37 SQL queries on the current data in table t, testing a number of different column combinations, predicates, and subqueries.

Parameters:

rowcounts - an array of integers with the expected row count for each query.

Throws:

java.sql.SQLException

assertRowCount

public void assertRowCount(int count,
                           java.sql.ResultSet rs)
                    throws java.sql.SQLException

Assert that the number of rows in the result set matches what we are expecting. We close the result set here, because we are only interested in the row count here and we assume that the caller is not checking any other aspect of the ResultSet.

Parameters:

count - the number of rows we expect to find

rs - the result set to check

Throws:

java.sql.SQLException