public class InsertTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
private static java.lang.String |
PARAMETER_IN_SELECT_LIST |
private static java.lang.String |
TOO_MANY_RESULT_COLUMNS |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
InsertTest(java.lang.String name) |
Modifier and Type | Method and Description |
---|---|
private void |
derby6786QueriesToRun(java.sql.Statement s,
java.lang.String insertInto) |
static junit.framework.Test |
suite() |
void |
testDerby6443()
Regression test case for DERBY-6443.
|
void |
testDerby6786Case1() |
void |
testDerby6786InsertIntoSelectCase2() |
void |
testInsertFromExceptOrIntersect()
INSERT used to fail with a NullPointerException if the source was an
EXCEPT operation or an INTERSECT operation.
|
void |
testInsertFromSelectWithParameters()
Regression test for DERBY-4671.
|
void |
testInsertIntoSelectFromWithLongVarchar()
Regression test case for DERBY-4348 where an INSERT INTO ..
|
void |
testInsertTooManyDefaultColumns()
Regression test case for DERBY-4449.
|
void |
zztestDerby6786InsertIntoSelectCase3() |
void |
zztestDerby6788() |
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 PARAMETER_IN_SELECT_LIST
private static final java.lang.String TOO_MANY_RESULT_COLUMNS
public static junit.framework.Test suite()
public void zztestDerby6788() throws java.sql.SQLException
java.sql.SQLException
public void testDerby6786Case1() throws java.sql.SQLException
java.sql.SQLException
public void testDerby6786InsertIntoSelectCase2() throws java.sql.SQLException
java.sql.SQLException
public void zztestDerby6786InsertIntoSelectCase3() throws java.sql.SQLException
java.sql.SQLException
private void derby6786QueriesToRun(java.sql.Statement s, java.lang.String insertInto) throws java.sql.SQLException
java.sql.SQLException
public void testInsertIntoSelectFromWithLongVarchar() throws java.sql.SQLException
java.sql.SQLException
public void testInsertFromExceptOrIntersect() throws java.sql.SQLException
java.sql.SQLException
public void testInsertFromSelectWithParameters() throws java.sql.SQLException
java.sql.SQLException
public void testInsertTooManyDefaultColumns() throws java.sql.SQLException
java.sql.SQLException
public void testDerby6443() throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.