UnaryArithmeticParameterTest (Apache Derby V10.10 Test Javadoc)

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

All Implemented Interfaces:

junit.framework.Test
```
public class UnaryArithmeticParameterTest
extends BaseJDBCTestCase
```
This tests unary minus and unary plus as dynamic parameters in PreparedStatements.

Field Summary
- Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase
  DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors
Constructor and Description

UnaryArithmeticParameterTest(java.lang.String name)
Public constructor required for running test as standalone JUnit.

Constructors
Constructor and Description
`UnaryArithmeticParameterTest(java.lang.String name)` Public constructor required for running test as standalone JUnit.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`protected void`	`setUp()` Set the fixture up with tables
`static junit.framework.Test`	`suite()` Create a suite of tests.
`protected void`	`tearDown()` Tear-down the fixture by removing the tables
`void`	`testABSWithUnaryMinusAndPlus()` Tests ABS function with Unary plus and Unary minus
`void`	`testBETWEENWithUnaryMinusAndPlus()` Tests BETWEEN with unary minus and unary plus
`void`	`testCastWithUnaryMinusAndPlus()` Tests Casting with unary plus and unary minus
`void`	`testExpectedErrors()` Negative tests for unary minus and unary plus
`void`	`testMAXWithUnaryMinusAndPlus()` Tests MAX function with Unary plus and Unary minus
`void`	`testNOTINWithUnaryMinusAndPlus()` Tests NOT IN with unary minus and unary plus
`void`	`testNullIfWithUnaryMinusAndPlus()` Tests NullIf with unary minus and unary plus
`void`	`testOperatorsWithUnaryMinusAndPlus()` Tests operators with Unary plus and unary Minus
`void`	`testParametersForUnaryMinusAndPlus()` Test using parameters with unary minus and unary plus
`void`	`testSelectWithUnaryMinusAndPlus()` Tests "select case when -?
`void`	`testSQRTWithUnaryMinusAndPlus()` Tests SQRT with unary minus and unary plus

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, 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, toString

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - UnaryArithmeticParameterTest
```
public UnaryArithmeticParameterTest(java.lang.String name)
```
    Public constructor required for running test as standalone JUnit.
- Method Detail
  - suite
```
public static junit.framework.Test suite()
```
    Create a suite of tests.
  - setUp
```
protected void setUp()
              throws java.sql.SQLException
```
    Set the fixture up with tables
    
    Overrides:
    
    setUp in class junit.framework.TestCase
    
    Throws:
    
    java.sql.SQLException
  - tearDown
```
protected void tearDown()
                 throws java.lang.Exception
```
    Tear-down the fixture by removing the tables
    
    Overrides:
    
    tearDown in class BaseJDBCTestCase
    
    Throws:
    
    java.lang.Exception
  - testParametersForUnaryMinusAndPlus
```
public void testParametersForUnaryMinusAndPlus()
                                        throws java.lang.Exception
```
    Test using parameters with unary minus and unary plus
    
    Throws:
    
    java.lang.Exception
  - testABSWithUnaryMinusAndPlus
```
public void testABSWithUnaryMinusAndPlus()
                                  throws java.lang.Exception
```
    Tests ABS function with Unary plus and Unary minus
    
    Throws:
    
    java.lang.Exception
  - testMAXWithUnaryMinusAndPlus
```
public void testMAXWithUnaryMinusAndPlus()
                                  throws java.lang.Exception
```
    Tests MAX function with Unary plus and Unary minus
    
    Throws:
    
    java.lang.Exception
  - testBETWEENWithUnaryMinusAndPlus
```
public void testBETWEENWithUnaryMinusAndPlus()
                                      throws java.lang.Exception
```
    Tests BETWEEN with unary minus and unary plus
    
    Throws:
    
    java.lang.Exception
  - testNOTINWithUnaryMinusAndPlus
```
public void testNOTINWithUnaryMinusAndPlus()
                                    throws java.lang.Exception
```
    Tests NOT IN with unary minus and unary plus
    
    Throws:
    
    java.lang.Exception
  - testOperatorsWithUnaryMinusAndPlus
```
public void testOperatorsWithUnaryMinusAndPlus()
                                        throws java.lang.Exception
```
    Tests operators with Unary plus and unary Minus
    
    Throws:
    
    java.lang.Exception
  - testCastWithUnaryMinusAndPlus
```
public void testCastWithUnaryMinusAndPlus()
                                   throws java.lang.Exception
```
    Tests Casting with unary plus and unary minus
    
    Throws:
    
    java.lang.Exception
  - testNullIfWithUnaryMinusAndPlus
```
public void testNullIfWithUnaryMinusAndPlus()
                                     throws java.lang.Exception
```
    Tests NullIf with unary minus and unary plus
    
    Throws:
    
    java.lang.Exception
  - testSQRTWithUnaryMinusAndPlus
```
public void testSQRTWithUnaryMinusAndPlus()
                                   throws java.lang.Exception
```
    Tests SQRT with unary minus and unary plus
    
    Throws:
    
    java.lang.Exception
  - testSelectWithUnaryMinusAndPlus
```
public void testSelectWithUnaryMinusAndPlus()
                                     throws java.lang.Exception
```
    Tests "select case when -?=c11 then -? else c12 end from t1"
    
    Throws:
    
    java.lang.Exception
  - testExpectedErrors
```
public void testExpectedErrors()
                        throws java.lang.Exception
```
    Negative tests for unary minus and unary plus
    
    Throws:
    
    java.lang.Exception

Class UnaryArithmeticParameterTest

Field Summary

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

Constructor Summary

Method Summary

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

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

Methods inherited from class junit.framework.TestCase

Methods inherited from class java.lang.Object

Constructor Detail

UnaryArithmeticParameterTest

Method Detail

suite

setUp

tearDown

testParametersForUnaryMinusAndPlus

testABSWithUnaryMinusAndPlus

testMAXWithUnaryMinusAndPlus

testBETWEENWithUnaryMinusAndPlus

testNOTINWithUnaryMinusAndPlus

testOperatorsWithUnaryMinusAndPlus

testCastWithUnaryMinusAndPlus

testNullIfWithUnaryMinusAndPlus

testSQRTWithUnaryMinusAndPlus

testSelectWithUnaryMinusAndPlus

testExpectedErrors