org.apache.derbyTesting.functionTests.tests.lang

Class RoutineTest

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

All Implemented Interfaces:

junit.framework.Test

public class RoutineTest
extends BaseJDBCTestCase

Set of tests for SQL routines. This tests mainly the SQL definition of routines and the server-side behaviour of routines. Calling of procedures is tested in ProcedureTest.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	CANNOT_STUFF_NULL_INTO_PRIMITIVE

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

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)

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

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

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

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, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast

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

CANNOT_STUFF_NULL_INTO_PRIMITIVE

private static final java.lang.String CANNOT_STUFF_NULL_INTO_PRIMITIVE

See Also:

Constant Field Values

Constructor Detail

RoutineTest

public RoutineTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

testFunctionResultDataTypeValidation

public void testFunctionResultDataTypeValidation()
                                          throws java.sql.SQLException

Test that function result data types are resolved correctly for numeric types that Derby supports that are simply mappable or object mappable.

Throws:

java.sql.SQLException

testFunctionReturnsNullOnNullInput

public void testFunctionReturnsNullOnNullInput()
                                        throws java.sql.SQLException

Test that RETURNS NULL ON NULL INPUT works properly with numeric datatypes for null and non-null values.

Throws:

java.sql.SQLException

testFunctionNullHandling

public void testFunctionNullHandling()
                              throws java.sql.SQLException,
                                     java.io.UnsupportedEncodingException

Test that functions handle being called or not called when it is passed a NULL argument correctly. A function can be declared: RETURNS NULL ON NULL INPUT - any argument being NULL means the function is returns NULL without being called. CALLED ON NULL INPUT (default) - function is always called regardless of any arguement being NULL.

Throws:

java.sql.SQLException

java.io.UnsupportedEncodingException

testAggregateArgument

public void testAggregateArgument()
                           throws java.sql.SQLException

Test function with an aggregate argument. DERBY-3649

Throws:

java.sql.SQLException

test_4459

public void test_4459()
               throws java.lang.Exception

Test that we don't get verification errors trying to cram nulls into primitive args. See DERBY-4459.

Throws:

java.lang.Exception

test_5749

public void test_5749()
               throws java.sql.SQLException

DERBY-5749: Too long (non-blank) argument for VARCHAR parameter does not throw as expected.

Throws:

java.sql.SQLException

test_6511

public void test_6511()
               throws java.lang.Exception

DERBY-6511: Make sure that conversions between primitive and wrapper types work properly.

Throws:

java.lang.Exception

vet_6511

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

Throws:

java.lang.Exception

createFunction_6511

private void createFunction_6511(java.sql.Connection conn,
                                 java.lang.String sqlDatatype,
                                 java.lang.String functionName)
                          throws java.lang.Exception

Throws:

java.lang.Exception

dropFunction_6511

private void dropFunction_6511(java.sql.Connection conn,
                               java.lang.String functionName)
                        throws java.lang.Exception

Throws:

java.lang.Exception

vetChaining_6511

private void vetChaining_6511(java.sql.Connection conn,
                              java.lang.String innerFunctionName,
                              java.lang.String outerFunctionName,
                              java.lang.String dataValue)
                       throws java.lang.Exception

Throws:

java.lang.Exception

concat

public static java.lang.String concat(java.lang.String s1,
                                      java.lang.String s2)

same

public static int same(int i)

nullAtNoon

public static java.sql.Time nullAtNoon(java.sql.Time t)

checkCount

public static int checkCount(int count)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

negateInt

public static int negateInt(int arg)

getNullInt

public static java.lang.Integer getNullInt()

p5749

public static void p5749(java.lang.String s)

booleanpToBoolean

public static java.lang.Boolean booleanpToBoolean(boolean val)

booleanToBooleanp

public static boolean booleanToBooleanp(java.lang.Boolean val)
                                 throws java.lang.Exception

Throws:

java.lang.Exception

intToInteger

public static java.lang.Integer intToInteger(int val)

integerToInt

public static int integerToInt(java.lang.Integer val)
                        throws java.lang.Exception

Throws:

java.lang.Exception

longpToLong

public static java.lang.Long longpToLong(long val)

longToLongp

public static long longToLongp(java.lang.Long val)
                        throws java.lang.Exception

Throws:

java.lang.Exception

shortpToInteger

public static java.lang.Integer shortpToInteger(short val)

integerToShortp

public static short integerToShortp(java.lang.Integer val)
                             throws java.lang.Exception

Throws:

java.lang.Exception

floatpToFloat

public static java.lang.Float floatpToFloat(float val)

floatToFloatp

public static float floatToFloatp(java.lang.Float val)
                           throws java.lang.Exception

Throws:

java.lang.Exception

doublepToDouble

public static java.lang.Double doublepToDouble(double val)

doubleToDoublep

public static double doubleToDoublep(java.lang.Double val)
                              throws java.lang.Exception

Throws:

java.lang.Exception