org.apache.derbyTesting.functionTests.tests.lang

Class OffsetFetchNextTest

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

All Implemented Interfaces:

junit.framework.Test

public class OffsetFetchNextTest
extends BaseJDBCTestCase

Test and .

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	FIRST_ROW_ONLY
private static java.lang.String	FIRST_ROWS_ONLY
private static int	JDBC_VARIANT
private static java.lang.String	LANG_FORMAT_EXCEPTION
private static java.lang.String	LANG_INTEGER_LITERAL_EXPECTED
private static java.lang.String	LANG_INVALID_ROW_COUNT_FIRST
private static java.lang.String	LANG_INVALID_ROW_COUNT_OFFSET
private static java.lang.String	LANG_MISSING_PARMS
private static java.lang.String	LANG_ROW_COUNT_OFFSET_FIRST_IS_NULL
private static java.lang.String	LANG_SYNTAX_ERROR
private static java.lang.String	NEXT_ROWS_ONLY
private static java.lang.String	PERCENT_TOKEN
private static int	SQL_STANDARD_VARIANT
private static int	VARIANT_COUNT

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	baseSuite(java.lang.String suiteName)
private static void	createSchemaObjects(java.sql.Statement st) Creates tables used by the tests (never modified, we use rollback after changes).
private java.lang.String	makeJDBCText(java.lang.String stub, java.lang.String offset, java.lang.String fetchFirst) Substitute JDBC limit/offset syntax into a stub statement, given an offset and fetch count.
private java.lang.String	makeSQLStandardText(java.lang.String stub, java.lang.String fetchFormat, java.lang.String offset, java.lang.String fetchFirst) Substitute the SQL Standard syntax into a stub statement, given an offset and fetch count.
private java.lang.String[]	makeVariants(java.lang.String stub, java.lang.String fetchFormat, java.lang.String offset, java.lang.String fetchFirst) Make the SQL Standard and JDBC limit/offset variants of a stub statement, plugging in the given offset and fetch count.
private void	queryAndCheck(java.sql.Statement stm, java.lang.String queryText, java.lang.String[][] expectedRows)
private java.lang.String	substitute(java.lang.String stub, java.lang.String token, int replacement)
private java.lang.String	substitute(java.lang.String stub, java.lang.String token, java.lang.String replacement)
static junit.framework.Test	suite()
void	testBigTable() Test against a bigger table
void	testDynamicArgs() Test dynamic arguments
void	testDynamicArgsMetaData() Test dynamic arguments
void	testErrors() Negative tests.
void	testJDBCLimitOffset() Test some additional corner cases in JDBC limit/offset syntax.
void	testMetadata() Positive tests, result set metadata
void	testNewKeywordNonReserved() Positive tests.
void	testOffsetFetchFirstReadOnlyForwardOnlyRS() Positive tests.
void	testOffsetFetchFirstReadOnlyScrollableRS() Positive tests with scrollable read-only.
void	testOffsetFetchFirstUpdatableForwardOnlyRS() Positive tests.
void	testOffsetFetchFirstUpdatableScrollableRS() Positive tests with SUR (Scrollable updatable result set).
void	testRepeatedExecution() Test that the values of offset and fetch first are not forgotten if a PreparedStatement is executed multiple times (DERBY-4212).
void	testRunTimeStatistics() Test that we see correct traces of the filtering in the statistics
void	testValues()
private void	vetStatement(java.sql.Statement stmt, java.lang.String sqlState, java.lang.String stub, java.lang.String fetchFormat, java.lang.String offset, java.lang.String fetchFirst, java.lang.String[][] expectedResults) Run a statement with both SQL Standard and JDBC limit/offset syntax.

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

Field Detail

LANG_FORMAT_EXCEPTION

private static final java.lang.String LANG_FORMAT_EXCEPTION

See Also:

Constant Field Values

LANG_INTEGER_LITERAL_EXPECTED

private static final java.lang.String LANG_INTEGER_LITERAL_EXPECTED

See Also:

Constant Field Values

LANG_INVALID_ROW_COUNT_FIRST

private static final java.lang.String LANG_INVALID_ROW_COUNT_FIRST

See Also:

Constant Field Values

LANG_INVALID_ROW_COUNT_OFFSET

private static final java.lang.String LANG_INVALID_ROW_COUNT_OFFSET

See Also:

Constant Field Values

LANG_MISSING_PARMS

private static final java.lang.String LANG_MISSING_PARMS

See Also:

Constant Field Values

LANG_SYNTAX_ERROR

private static final java.lang.String LANG_SYNTAX_ERROR

See Also:

Constant Field Values

LANG_ROW_COUNT_OFFSET_FIRST_IS_NULL

private static final java.lang.String LANG_ROW_COUNT_OFFSET_FIRST_IS_NULL

See Also:

Constant Field Values

PERCENT_TOKEN

private static final java.lang.String PERCENT_TOKEN

See Also:

Constant Field Values

FIRST_ROWS_ONLY

private static final java.lang.String FIRST_ROWS_ONLY

See Also:

Constant Field Values

FIRST_ROW_ONLY

private static final java.lang.String FIRST_ROW_ONLY

See Also:

Constant Field Values

NEXT_ROWS_ONLY

private static final java.lang.String NEXT_ROWS_ONLY

See Also:

Constant Field Values

SQL_STANDARD_VARIANT

private static final int SQL_STANDARD_VARIANT

See Also:

Constant Field Values

JDBC_VARIANT

private static final int JDBC_VARIANT

See Also:

Constant Field Values

VARIANT_COUNT

private static final int VARIANT_COUNT

See Also:

Constant Field Values

Constructor Detail

OffsetFetchNextTest

public OffsetFetchNextTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

baseSuite

public static junit.framework.Test baseSuite(java.lang.String suiteName)

createSchemaObjects

private static void createSchemaObjects(java.sql.Statement st)
                                 throws java.sql.SQLException

Creates tables used by the tests (never modified, we use rollback after changes).

Throws:

java.sql.SQLException

testErrors

public void testErrors()
                throws java.lang.Exception

Negative tests. Test various invalid OFFSET and FETCH NEXT clauses.

Throws:

java.lang.Exception

testNewKeywordNonReserved

public void testNewKeywordNonReserved()
                               throws java.lang.Exception

Positive tests. Check that the new keyword OFFSET introduced is not reserved so we don't risk breaking existing apps.

Throws:

java.lang.Exception

testOffsetFetchFirstReadOnlyForwardOnlyRS

public void testOffsetFetchFirstReadOnlyForwardOnlyRS()
                                               throws java.lang.Exception

Positive tests.

Throws:

java.lang.Exception

testOffsetFetchFirstUpdatableForwardOnlyRS

public void testOffsetFetchFirstUpdatableForwardOnlyRS()
                                                throws java.lang.Exception

Positive tests.

Throws:

java.lang.Exception

testOffsetFetchFirstReadOnlyScrollableRS

public void testOffsetFetchFirstReadOnlyScrollableRS()
                                              throws java.lang.Exception

Positive tests with scrollable read-only.

Throws:

java.lang.Exception

testOffsetFetchFirstUpdatableScrollableRS

public void testOffsetFetchFirstUpdatableScrollableRS()
                                               throws java.lang.Exception

Positive tests with SUR (Scrollable updatable result set).

Throws:

java.lang.Exception

testValues

public void testValues()
                throws java.lang.Exception

Throws:

java.lang.Exception

testMetadata

public void testMetadata()
                  throws java.lang.Exception

Positive tests, result set metadata

Throws:

java.lang.Exception

testRunTimeStatistics

public void testRunTimeStatistics()
                           throws java.lang.Exception

Test that we see correct traces of the filtering in the statistics

Throws:

java.lang.Exception

testBigTable

public void testBigTable()
                  throws java.lang.Exception

Test against a bigger table

Throws:

java.lang.Exception

testRepeatedExecution

public void testRepeatedExecution()
                           throws java.lang.Exception

Test that the values of offset and fetch first are not forgotten if a PreparedStatement is executed multiple times (DERBY-4212).

Throws:

java.lang.Exception

testDynamicArgs

public void testDynamicArgs()
                     throws java.lang.Exception

Test dynamic arguments

Throws:

java.lang.Exception

testDynamicArgsMetaData

public void testDynamicArgsMetaData()
                             throws java.lang.Exception

Test dynamic arguments

Throws:

java.lang.Exception

testJDBCLimitOffset

public void testJDBCLimitOffset()
                         throws java.lang.Exception

Test some additional corner cases in JDBC limit/offset syntax.

Throws:

java.lang.Exception

vetStatement

private void vetStatement(java.sql.Statement stmt,
                          java.lang.String sqlState,
                          java.lang.String stub,
                          java.lang.String fetchFormat,
                          java.lang.String offset,
                          java.lang.String fetchFirst,
                          java.lang.String[][] expectedResults)
                   throws java.lang.Exception

Run a statement with both SQL Standard and JDBC limit/offset syntax. Verify that we get the expected error or results. The statement has a % literal at the point where the offset/fetchFirst and limit/offset clauses are to be inserted.

Throws:

java.lang.Exception

makeVariants

private java.lang.String[] makeVariants(java.lang.String stub,
                                        java.lang.String fetchFormat,
                                        java.lang.String offset,
                                        java.lang.String fetchFirst)
                                 throws java.lang.Exception

Make the SQL Standard and JDBC limit/offset variants of a stub statement, plugging in the given offset and fetch count.

Throws:

java.lang.Exception

makeSQLStandardText

private java.lang.String makeSQLStandardText(java.lang.String stub,
                                             java.lang.String fetchFormat,
                                             java.lang.String offset,
                                             java.lang.String fetchFirst)
                                      throws java.lang.Exception

Substitute the SQL Standard syntax into a stub statement, given an offset and fetch count.

Throws:

java.lang.Exception

makeJDBCText

private java.lang.String makeJDBCText(java.lang.String stub,
                                      java.lang.String offset,
                                      java.lang.String fetchFirst)
                               throws java.lang.Exception

Substitute JDBC limit/offset syntax into a stub statement, given an offset and fetch count.

Throws:

java.lang.Exception

substitute

private java.lang.String substitute(java.lang.String stub,
                                    java.lang.String token,
                                    int replacement)
                             throws java.lang.Exception

Throws:

java.lang.Exception

substitute

private java.lang.String substitute(java.lang.String stub,
                                    java.lang.String token,
                                    java.lang.String replacement)
                             throws java.lang.Exception

Throws:

java.lang.Exception

queryAndCheck

private void queryAndCheck(java.sql.Statement stm,
                           java.lang.String queryText,
                           java.lang.String[][] expectedRows)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException