public class ArithmeticTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
private static java.lang.String |
BIGINT |
private static java.lang.String |
DECIMAL |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
ArithmeticTest(java.lang.String name) |
Modifier and Type | Method and Description |
---|---|
private void |
doBasically(java.lang.String tableName,
java.lang.String type)
Test basic arithmetic operations.
|
private void |
doMixedTypeImpl(java.lang.String tableName,
java.lang.String type,
java.math.BigInteger i)
Test mixed types.i.e. int and bigint, or int and smallint.
|
private void |
doOverflow(java.lang.String tableName,
java.lang.String type,
java.math.BigInteger negativeBoundary,
java.math.BigInteger positiveBoundary)
Test overflow on some types.
|
static junit.framework.Test |
suite() |
void |
testMixedType()
Test mixed types.i.e. int and bigint, or int and smallint.
|
void |
testNumericDataType()
Arithmetic on a numeric data type.
|
void |
testPrecedenceAndAssociativity() |
void |
testTypes()
Test arithmetic on different types.
|
void |
testWrongType()
Test the arithmetic operators on a type we know they don't work on.
|
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 BIGINT
private static final java.lang.String DECIMAL
public static junit.framework.Test suite()
public void testTypes() throws java.sql.SQLException
java.sql.SQLException
private void doBasically(java.lang.String tableName, java.lang.String type) throws java.sql.SQLException
tableName
- the name of table to test.
If a table with the same name has existed,
it will be dropped.type
- the type to test. i.e. "smallint" or "bigint".java.sql.SQLException
private void doOverflow(java.lang.String tableName, java.lang.String type, java.math.BigInteger negativeBoundary, java.math.BigInteger positiveBoundary) throws java.sql.SQLException
tableName
- the name of table to test.
If a table with the same name has existed,
it will be dropped.type
- the type to test. i.e. "smallint" or "bigint".negativeBoundary
- the negative boundary for the data typepositiveBoundary
- the positive boundary for the data typejava.sql.SQLException
private void doMixedTypeImpl(java.lang.String tableName, java.lang.String type, java.math.BigInteger i) throws java.sql.SQLException
tableName
- the name of table to test.type
- the type to test. i.e. "smallint" or "bigint".i
- an integer number to test with.java.sql.SQLException
public void testMixedType() throws java.sql.SQLException
java.sql.SQLException
public void testWrongType() throws java.sql.SQLException
java.sql.SQLException
public void testNumericDataType() throws java.sql.SQLException
java.sql.SQLException
public void testPrecedenceAndAssociativity() throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.