public class RoutineTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
private static java.lang.String |
CANNOT_STUFF_NULL_INTO_PRIMITIVE |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
RoutineTest(java.lang.String name) |
Modifier and Type | Method and Description |
---|---|
static java.lang.Boolean |
booleanpToBoolean(boolean val) |
static boolean |
booleanToBooleanp(java.lang.Boolean val) |
static int |
checkCount(int count) |
static java.lang.String |
concat(java.lang.String s1,
java.lang.String s2) |
private void |
createFunction_6511(java.sql.Connection conn,
java.lang.String sqlDatatype,
java.lang.String functionName) |
static java.lang.Double |
doublepToDouble(double val) |
static double |
doubleToDoublep(java.lang.Double val) |
private void |
dropFunction_6511(java.sql.Connection conn,
java.lang.String functionName) |
static java.lang.Float |
floatpToFloat(float val) |
static float |
floatToFloatp(java.lang.Float val) |
static java.lang.Integer |
getNullInt() |
static int |
integerToInt(java.lang.Integer val) |
static short |
integerToShortp(java.lang.Integer val) |
static java.lang.Integer |
intToInteger(int val) |
static java.lang.Long |
longpToLong(long val) |
static long |
longToLongp(java.lang.Long val) |
static int |
negateInt(int arg) |
static java.sql.Time |
nullAtNoon(java.sql.Time t) |
static void |
p5749(java.lang.String s) |
static int |
same(int i) |
static java.lang.Integer |
shortpToInteger(short val) |
static junit.framework.Test |
suite() |
void |
test_4459()
Test that we don't get verification errors trying to cram nulls
into primitive args.
|
void |
test_5749()
DERBY-5749: Too long (non-blank) argument for VARCHAR parameter does not
throw as expected.
|
void |
test_6511()
DERBY-6511: Make sure that conversions between primitive and wrapper
types work properly.
|
void |
testAggregateArgument()
Test function with an aggregate argument.
|
void |
testFunctionNullHandling()
Test that functions handle being called or not called
when it is passed a NULL argument correctly.
|
void |
testFunctionResultDataTypeValidation()
Test that function result data types are resolved correctly for numeric
types that Derby supports that are simply mappable or object mappable.
|
void |
testFunctionReturnsNullOnNullInput()
Test that RETURNS NULL ON NULL INPUT works properly with
numeric datatypes for null and non-null values.
|
private void |
vet_6511(java.sql.Connection conn,
java.lang.String sqlDatatype,
java.lang.String primitiveToWrapperName,
java.lang.String wrapperToPrimitiveName,
java.lang.String dataValue) |
private void |
vetChaining_6511(java.sql.Connection conn,
java.lang.String innerFunctionName,
java.lang.String outerFunctionName,
java.lang.String dataValue) |
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 CANNOT_STUFF_NULL_INTO_PRIMITIVE
public static junit.framework.Test suite()
public void testFunctionResultDataTypeValidation() throws java.sql.SQLException
java.sql.SQLException
public void testFunctionReturnsNullOnNullInput() throws java.sql.SQLException
java.sql.SQLException
public void testFunctionNullHandling() throws java.sql.SQLException, java.io.UnsupportedEncodingException
java.sql.SQLException
java.io.UnsupportedEncodingException
public void testAggregateArgument() throws java.sql.SQLException
java.sql.SQLException
public void test_4459() throws java.lang.Exception
java.lang.Exception
public void test_5749() throws java.sql.SQLException
java.sql.SQLException
public void test_6511() throws java.lang.Exception
java.lang.Exception
private void vet_6511(java.sql.Connection conn, java.lang.String sqlDatatype, java.lang.String primitiveToWrapperName, java.lang.String wrapperToPrimitiveName, java.lang.String dataValue) throws java.lang.Exception
java.lang.Exception
private void createFunction_6511(java.sql.Connection conn, java.lang.String sqlDatatype, java.lang.String functionName) throws java.lang.Exception
java.lang.Exception
private void dropFunction_6511(java.sql.Connection conn, java.lang.String functionName) throws java.lang.Exception
java.lang.Exception
private void vetChaining_6511(java.sql.Connection conn, java.lang.String innerFunctionName, java.lang.String outerFunctionName, java.lang.String dataValue) throws java.lang.Exception
java.lang.Exception
public static java.lang.String concat(java.lang.String s1, java.lang.String s2)
public static int same(int i)
public static java.sql.Time nullAtNoon(java.sql.Time t)
public static int checkCount(int count) throws java.sql.SQLException
java.sql.SQLException
public static int negateInt(int arg)
public static java.lang.Integer getNullInt()
public static void p5749(java.lang.String s)
public static java.lang.Boolean booleanpToBoolean(boolean val)
public static boolean booleanToBooleanp(java.lang.Boolean val) throws java.lang.Exception
java.lang.Exception
public static java.lang.Integer intToInteger(int val)
public static int integerToInt(java.lang.Integer val) throws java.lang.Exception
java.lang.Exception
public static java.lang.Long longpToLong(long val)
public static long longToLongp(java.lang.Long val) throws java.lang.Exception
java.lang.Exception
public static java.lang.Integer shortpToInteger(short val)
public static short integerToShortp(java.lang.Integer val) throws java.lang.Exception
java.lang.Exception
public static java.lang.Float floatpToFloat(float val)
public static float floatToFloatp(java.lang.Float val) throws java.lang.Exception
java.lang.Exception
public static java.lang.Double doublepToDouble(double val)
public static double doubleToDoublep(java.lang.Double val) throws java.lang.Exception
java.lang.Exception
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.