[
https://issues.apache.org/jira/browse/DERBY-4375?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12755492#action_12755492
]
Bryan Pendleton commented on DERBY-4375:
----------------------------------------
I agree, I don't think that statement existed in the old test. The
corresponding section
of the old test looked like this:
-insert into bt2 values (8, -800.0, '1992-03-22', '03:22:28', '2007-01-04
16:17:23.303', '2992-01-02');
-insert into bt2 values (1, 200.0, '1998-03-22', '13:22:28', '2007-01-04
16:17:36.912', '3999-08-08');
-insert into bt2 values (-8, 800, '3999-08-08', '02:28:22', '2007-01-05
16:03:52.364', '1992-01-02');
-insert into bt2 values (18, 180.00, '2007-02-23', '15:47:27', null, null);
-insert into bt2 values (22, 202.010, '2007-02-23', '15:47:27', null, null);
-insert into bt2 values (23, 322.002, null, '15:47:28', null, null);
-insert into bt2 values (28, 82, null, '15:47:28', '2007-02-23 15:47:27.544',
null);
I think that the SQLToJUnit tool did something strange with the
'xxxxxxFILTERED-TIMESTAMPxxxxx'
data in the 'inbetween.out' file as it was converting it to JUnit, and I didn't
catch this during
the code review (probably because the test passed on all the platforms I was
running).
What do you think we should do here? It's certainly a strange timestamp; is the
WEME
platform justified in complaining about it?
If you change the timestamp to '2007-02-23 15:47:27.544', (the value from the
original test),
does the test then pass?
If so, that seems like a reasonable fix to me.
> 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
>
> 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.
