public class OffsetFetchNextTest extends BaseJDBCTestCase
<result offset clause>
and <fetch first clause>
.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 |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
OffsetFetchNextTest(java.lang.String name) |
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,
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.
|
assertCallError, assertCheckTable, assertCommitError, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertResults, assertResults, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, chattyPrepare, chattyPrepareCall, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, dumpRs, dumpRs, emptyStatementCache, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, goodStatement, goodUpdate, 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
alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSameNullness, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast
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
private static final java.lang.String LANG_FORMAT_EXCEPTION
private static final java.lang.String LANG_INTEGER_LITERAL_EXPECTED
private static final java.lang.String LANG_INVALID_ROW_COUNT_FIRST
private static final java.lang.String LANG_INVALID_ROW_COUNT_OFFSET
private static final java.lang.String LANG_MISSING_PARMS
private static final java.lang.String LANG_SYNTAX_ERROR
private static final java.lang.String LANG_ROW_COUNT_OFFSET_FIRST_IS_NULL
private static final java.lang.String PERCENT_TOKEN
private static final java.lang.String FIRST_ROWS_ONLY
private static final java.lang.String FIRST_ROW_ONLY
private static final java.lang.String NEXT_ROWS_ONLY
private static final int SQL_STANDARD_VARIANT
private static final int JDBC_VARIANT
private static final int VARIANT_COUNT
public static junit.framework.Test suite()
public static junit.framework.Test baseSuite(java.lang.String suiteName)
private static void createSchemaObjects(java.sql.Statement st) throws java.sql.SQLException
java.sql.SQLException
public void testErrors() throws java.sql.SQLException
java.sql.SQLException
public void testNewKeywordNonReserved() throws java.sql.SQLException
java.sql.SQLException
public void testOffsetFetchFirstReadOnlyForwardOnlyRS() throws java.sql.SQLException
java.sql.SQLException
public void testOffsetFetchFirstUpdatableForwardOnlyRS() throws java.sql.SQLException
java.sql.SQLException
public void testOffsetFetchFirstReadOnlyScrollableRS() throws java.sql.SQLException
java.sql.SQLException
public void testOffsetFetchFirstUpdatableScrollableRS() throws java.sql.SQLException
java.sql.SQLException
public void testValues() throws java.sql.SQLException
java.sql.SQLException
public void testMetadata() throws java.sql.SQLException
java.sql.SQLException
public void testRunTimeStatistics() throws java.sql.SQLException
java.sql.SQLException
public void testBigTable() throws java.sql.SQLException
java.sql.SQLException
public void testRepeatedExecution() throws java.sql.SQLException
PreparedStatement
is executed multiple times (DERBY-4212).java.sql.SQLException
public void testDynamicArgs() throws java.sql.SQLException
java.sql.SQLException
public void testDynamicArgsMetaData() throws java.sql.SQLException
java.sql.SQLException
public void testJDBCLimitOffset() throws java.sql.SQLException
java.sql.SQLException
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.sql.SQLException
java.sql.SQLException
private java.lang.String[] makeVariants(java.lang.String stub, java.lang.String fetchFormat, java.lang.String offset, java.lang.String fetchFirst)
private java.lang.String makeSQLStandardText(java.lang.String stub, java.lang.String fetchFormat, java.lang.String offset, java.lang.String fetchFirst)
private java.lang.String makeJDBCText(java.lang.String stub, java.lang.String offset, java.lang.String fetchFirst)
private java.lang.String substitute(java.lang.String stub, java.lang.String token, java.lang.String replacement)
private void queryAndCheck(java.sql.Statement stm, java.lang.String queryText, java.lang.String[][] expectedRows) throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.