Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 34258 invoked from network); 14 Sep 2009 18:55:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 14 Sep 2009 18:55:23 -0000 Received: (qmail 78112 invoked by uid 500); 14 Sep 2009 18:55:22 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 78074 invoked by uid 500); 14 Sep 2009 18:55:22 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 78058 invoked by uid 99); 14 Sep 2009 18:55:22 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Sep 2009 18:55:22 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 14 Sep 2009 18:55:18 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 7C8D8234C1E9 for ; Mon, 14 Sep 2009 11:54:57 -0700 (PDT) Message-ID: <1144374633.1252954497509.JavaMail.jira@brutus> Date: Mon, 14 Sep 2009 11:54:57 -0700 (PDT) From: "Mamta A. Satoor (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Created: (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. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org 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.(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.