| java.lang.Object
 org.apache.derbyTesting.functionTests.tests.lang.timestampArith
| timestampArith | | public class timestampArith (Code) | | Test the JDBC TIMESTAMPADD and TIMESTAMPDIFF escape functions.
Things to test:
+ Test each interval type with timestamp, date, and time inputs.
+ Test diff with all 9 combinations of datetime input types (timestamp - timestamp, timestamp - date, etc).
+ Test PreparedStatements with parameters, '?', in each argument, and Statements. (Statements are prepared
internally so we do not also have to test PrepardStatements without parameters).
+ Test with null inputs.
+ Test with input string that is convertible to timestamp.
+ Test with invalid interval type.
+ Test with invalid arguments in the date time arguments.
+ Test TIMESTAMPADD with an invalid type in the count argument.
+ Test overflow cases.
|
| Inner Class :abstract class OneTest | |
| Inner Class :class OneDiffTest extends OneTest | |
| Inner Class :class OneStringDiffTest extends OneDiffTest | |
| Inner Class :class OneAddTest extends OneTest | |
| Inner Class :class OneStringAddTest extends OneAddTest | |
| errorCount | | int errorCount(Code) | | |
|
|