org.apache.derbyTesting.functionTests.tests.lang

Class ArithmeticTest

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

All Implemented Interfaces:

junit.framework.Test

public class ArithmeticTest
extends BaseJDBCTestCase

Test case for arithmetic.sql. It tests the arithmetic operators.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	BIGINT
private static java.lang.String	DECIMAL

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

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.

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

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, emptyStatementCache, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, 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, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemProperty, sleep, sleepAtLeastOneTick, traceit

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

BIGINT

private static final java.lang.String BIGINT

See Also:

Constant Field Values

DECIMAL

private static final java.lang.String DECIMAL

See Also:

Constant Field Values

Constructor Detail

ArithmeticTest

public ArithmeticTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

testTypes

public void testTypes()
               throws java.sql.SQLException

Test arithmetic on different types. i.e. int and bigint, or int and smallint.

Throws:

java.sql.SQLException

doBasically

private void doBasically(java.lang.String tableName,
                         java.lang.String type)
                  throws java.sql.SQLException

Test basic arithmetic operations. i.e. int and bigint, or int and smallint.

Parameters:

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

Throws:

java.sql.SQLException

doOverflow

private void doOverflow(java.lang.String tableName,
                        java.lang.String type,
                        java.math.BigInteger negativeBoundary,
                        java.math.BigInteger positiveBoundary)
                 throws java.sql.SQLException

Test overflow on some types. i.e. int and bigint, or int and smallint.

Parameters:

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 type

positiveBoundary - the positive boundary for the data type

Throws:

java.sql.SQLException

doMixedTypeImpl

private void doMixedTypeImpl(java.lang.String tableName,
                             java.lang.String type,
                             java.math.BigInteger i)
                      throws java.sql.SQLException

Test mixed types.i.e. int and bigint, or int and smallint.

Parameters:

tableName - the name of table to test.

type - the type to test. i.e. "smallint" or "bigint".

i - an integer number to test with.

Throws:

java.sql.SQLException

testMixedType

public void testMixedType()
                   throws java.sql.SQLException

Test mixed types.i.e. int and bigint, or int and smallint.

Throws:

java.sql.SQLException

testWrongType

public void testWrongType()
                   throws java.sql.SQLException

Test the arithmetic operators on a type we know they don't work on.

Throws:

java.sql.SQLException

testNumericDataType

public void testNumericDataType()
                         throws java.sql.SQLException

Arithmetic on a numeric data type.

Throws:

java.sql.SQLException

testPrecedenceAndAssociativity

public void testPrecedenceAndAssociativity()
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException