db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4375) WEME6.2 : Handful of test fixtures in InbetweenTest are failing with java.sql.SQLException: The syntax of the string representation of a datetime value is incorrect.
Date Thu, 17 Sep 2009 08:30:57 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12756416#action_12756416
] 

Knut Anders Hatlen commented on DERBY-4375:
-------------------------------------------

The javadoc for java.util.Date says:

> In all cases, arguments given to methods for these purposes need not
> fall within the indicated ranges; for example, a date may be
> specified as January 32 and is interpreted as meaning February 1.

This explains the month and day parts of the date. 0/0 is one month
and one day before 1/1. This should however give year -1, not year
2. I found this explanation in the bug database
(http://bugs.sun.com/view_bug.do?bug_id=6278731), where the evaluation
note says:

> GregorianCalendar represents a date with ERA and YEAR. 0 and
> negative year values are converted to (1 - year) with an ERA change
> to support the Julian calendar year numbering.

So the year becomes (1 - year) == (1 - -1) = 2.

> WEME6.2 : Handful of test fixtures in InbetweenTest are failing with java.sql.SQLException:
The syntax of the string representation of a datetime value is incorrect.
> ---------------------------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-4375
>                 URL: https://issues.apache.org/jira/browse/DERBY-4375
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.6.0.0
>         Environment: weme 6.2 
>            Reporter: Mamta A. Satoor
>            Assignee: Mamta A. Satoor
>         Attachments: mamta.java, timeStampDiffValue.java
>
>
> On weme6.2, 8 test fixtures from InBetweenTest are failing with following error
> java.sql.SQLException: The syntax of the string representation of a datetime value is
incorrect.
> The failing test fixtures are 
> 1)testReproductionBeetle5135
> 2)testBeetle4316
> 3)testNestedQueries
> 4)testCheckQueries
> 5)testBigInList
> 6)testInBetween
> 7)testInList
> 8)testBetween
> The stack trace for testBetween looks as follows
> 1) testBetween(org.apache.derbyTesting.functionTests.tests.lang.InbetweenTest)java.sql.SQLException:
The syntax of the string representation of a datetime value is incorrect.
> 	at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedStatement.executeUpdate(Unknown Source)
> 	at org.apache.derbyTesting.functionTests.tests.lang.InbetweenTest.createTestObjects(InbetweenTest.java:195)
> 	at org.apache.derbyTesting.functionTests.tests.lang.InbetweenTest.testBetween(InbetweenTest.java:214)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:195)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:109)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> 	at junit.extensions.TestSetup.run(TestSetup.java:23)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> 	at junit.extensions.TestSetup.run(TestSetup.java:23)
> 	at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
> Caused by: ERROR 22007: The syntax of the string representation of a datetime value is
incorrect.
> 	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> 	at org.apache.derby.iapi.types.DateTimeParser.parseInt(Unknown Source)
> 	at org.apache.derby.iapi.types.SQLTimestamp.parseDateOrTimestamp(Unknown Source)
> 	at org.apache.derby.iapi.types.SQLTimestamp.parseTimestamp(Unknown Source)
> 	at org.apache.derby.iapi.types.SQLTimestamp.<init>(Unknown Source)
> 	at org.apache.derby.iapi.types.SQLChar.getTimestamp(Unknown Source)
> 	at org.apache.derby.iapi.types.SQLChar.getTimestamp(Unknown Source)
> 	at org.apache.derby.iapi.types.SQLTimestamp.setFrom(Unknown Source)
> 	at org.apache.derby.iapi.types.DataType.setValue(Unknown Source)
> 	at org.apache.derby.iapi.types.DataType.normalize(Unknown Source)
> 	at org.apache.derby.iapi.types.DataTypeDescriptor.normalize(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeColumn(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.NormalizeResultSet.normalizeRow(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.DMLWriteResultSet.getNextRowCore(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.executeStmt(Unknown Source)
> 	at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source)
> 	... 39 more
>  

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message