db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ramandeep Kaur (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2997) suites.All hangs with failures
Date Thu, 09 Aug 2007 00:18:59 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2997?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12518581
] 

Ramandeep Kaur commented on DERBY-2997:
---------------------------------------

I also looked at changes that went into trunk from 7/9 to 7/10. 
These failures seems to be connected to DERBY-716 checkin (r555032).

They are as following:

------------------------------------------------------------------------
r555137 | kmarsden | 2007-07-10 18:56:40 -0700 (Tue, 10 Jul 2007) | 3 lines

DERBY-2893 Fix update privileges for testColumnPrivileges test.


------------------------------------------------------------------------
r555096 | bpendleton | 2007-07-10 15:06:02 -0700 (Tue, 10 Jul 2007) | 19 lines

DERBY-2351: Certain ORDER BY clauses should be rejected as invalid

This change modifies the ORDER BY clause so that it rejects certain
queries as invalid: specifically, queries which:
a) specify the set quantifier DISTINCT,
b) and also contain an ORDER BY clause which refers to a column
or expression which is not in the query result.

The problem with such queries is that we are told to return only
a single instance of the DISTINCT columns, but since the ORDER BY
clause refers to columns which are not in the DISTINCT set, if there
should be multiple candidate rows from which we choose the DISTINCT
result, we don't know which of those rows to use for the ORDER BY
processing.

When the DISTINCT and ORDER BY clauses are in conflict, Derby should
reject the query. This change modifies Derby to do so.


------------------------------------------------------------------------
r555075 | kmarsden | 2007-07-10 14:00:43 -0700 (Tue, 10 Jul 2007) | 3 lines

DERBY-2893 Fix GrantRevokeTest to use correct user for assertInsertPrivilege


------------------------------------------------------------------------
r555074 | djd | 2007-07-10 13:44:40 -0700 (Tue, 10 Jul 2007) | 2 lines

DERBY-2917 DERBY-2775 Modify creating of system routines to use TypeDescriptors consistently
and not DataTypedDescriptors.
------------------------------------------------------------------------
r555032 | rhillegas | 2007-07-10 11:40:39 -0700 (Tue, 10 Jul 2007) | 1 line

DERBY-716: Commit first increment of VTI work, enabling DDL for table functions and their
invocation in simple SELECTs.
------------------------------------------------------------------------
r555028 | djd | 2007-07-10 11:30:47 -0700 (Tue, 10 Jul 2007) | 4 lines

DERBY-2775 Add some comments to the main type classes to indicate their roles:
TypeId Information about the type without specific attributes
TypeDescriptor Catalog type descriptor
DataTypeDescriptor Runtime type descriptor
------------------------------------------------------------------------
r554996 | bpendleton | 2007-07-10 09:37:04 -0700 (Tue, 10 Jul 2007) | 19 lines

DERBY-2902: can't use Long.MIN_VALUE as the start value for a generated column

When creating a table
    AS IDENTITY (START WITH -9223372036854775808)
fails but
    AS IDENTITY (START WITH -9223372036854775807)
succeeds.

The problem was that the parser was handling the +/- sign separately
from the start value, and was trying to call
Long.parseLong("9223372036854775808") and then negate the return value,
which fails because 9223372036854775808 is greater than Long.MAX_VALUE.

The fix is to push the handling of the "-" sign into the call to
Long.parseLong(), where it is handled correctly. We have to be careful
not to push the "+" sign into parseLong(), though, because it doesn't
accept a leading "+" sign, only a leading "-" sign.


------------------------------------------------------------------------
r554824 | djd | 2007-07-09 21:39:20 -0700 (Mon, 09 Jul 2007) | 2 lines

DERBY-2775 Change ColumnDefinition to have a getType() method and a setNullability() method
to move
towards having an immutable DataTypeDescriptor.
------------------------------------------------------------------------
r554710 | kmarsden | 2007-07-09 10:03:00 -0700 (Mon, 09 Jul 2007) | 3 lines

Reformat LargeDataLocksTest with spaces.  Accidentally committed with mixed tabs/spaces.




> suites.All hangs with failures
> ------------------------------
>
>                 Key: DERBY-2997
>                 URL: https://issues.apache.org/jira/browse/DERBY-2997
>             Project: Derby
>          Issue Type: Bug
>          Components: Test
>    Affects Versions: 10.4.0.0
>         Environment: Windows XP
> JVMS: IBM 142, IBM 15, IBM J2ME Foundation Specification v1.1
>            Reporter: Ramandeep Kaur
>             Fix For: 10.4.0.0
>
>
> suites.All hangs for IBM J2ME Foundation Specification v1.1.
> .........................................
> ......F...................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> ................java.sql.SQLException: Feature not implemented: {0}.
> 	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.EmbedResultSet.closeOnTransactionError(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(Unknown Source)
> 	at org.apache.derby.impl.jdbc.EmbedResultSet.next(Unknown Source)
> 	at org.apache.derbyTesting.functionTests.tests.lang.TableFunctionTest.assertResults(TableFunctionTest.java:562)
> 	at org.apache.derbyTesting.functionTests.tests.lang.TableFunctionTest.assertResults(TableFunctionTest.java:448)
> 	at org.apache.derbyTesting.functionTests.tests.lang.TableFunctionTest.allLegalDatatypesVTIResults(TableFunctionTest.java:366)
> 	at org.apache.derbyTesting.functionTests.tests.lang.TableFunctionTest.testTableFunctions(TableFunctionTest.java:168)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> 	at java.lang.reflect.Method.invoke(Method.java:253)
> 	at junit.framework.TestCase.runTest(TestCase.java:154)
> 	at junit.framework.TestCase.runBare(TestCase.java:127)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> 	at junit.framework.TestResult$1.protect(TestResult.java:106)
> 	at junit.framework.TestResult.runProtected(TestResult.java:124)
> 	at junit.framework.TestResult.run(TestResult.java:109)
> 	at junit.framework.TestCase.run(TestCase.java:118)
> 	at junit.framework.TestSuite.runTest(TestSuite.java:208)
> 	at junit.framework.TestSuite.run(TestSuite.java:203)
> 	at junit.framework.TestSuite.runTest(TestSuite.java:208)
> 	at junit.framework.TestSuite.run(TestSuite.java:203)
> 	at junit.framework.TestSuite.runTest(TestSuite.java:208)
> 	at junit.framework.TestSuite.run(TestSuite.java:203)
> 	at junit.framework.TestSuite.runTest(TestSuite.java:208)
> 	at junit.framework.TestSuite.run(TestSuite.java:203)
> 	at junit.textui.TestRunner.doRun(TestRunner.java:116)
> 	at junit.textui.TestRunner.start(TestRunner.java:172)
> 	at junit.textui.TestRunner.main(TestRunner.java:138)
> Caused by: ERROR 0A000: Feature not implemented: {0}.
> 	at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)
> 	at org.apache.derby.iapi.types.BinaryDecimal.setValueFromResultSet(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.VTIResultSet.populateFromResultSet(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.VTIResultSet.getNextRowCore(Unknown Source)
> 	at org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(Unknown Source)
> 	... 26 more
> F.........................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> ...........F..............................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> .........................................
> ..
> It also had following 3 failures:
> There were 3 failures:
> 1) testColumnPrivileges(org.apache.derbyTesting.functionTests.tests.lang.GrantRevokeTest)junit.framework.AssertionFailedError:
expected no UPDATE permission on table
> 	at org.apache.derbyTesting.functionTests.tests.lang.GrantRevokeTest.assertUpdatePrivilege(GrantRevokeTest.java:1133)
> 	at org.apache.derbyTesting.functionTests.tests.lang.GrantRevokeTest.testColumnPrivileges(GrantRevokeTest.java:170)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> 	at <unknown class>.<unknown method>(Unknown Source)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> 	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)
> 	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 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)
> 	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 junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
> 	at junit.extensions.TestSetup.run(TestSetup.java:23)
> 2) testTableFunctions(org.apache.derbyTesting.functionTests.tests.lang.TableFunctionTest)junit.framework.AssertionFailedError:
Unexpected exception: java.sql.SQLException: Feature not implemented: {0}.
> 	at org.apache.derbyTesting.functionTests.tests.lang.TableFunctionTest.unexpectedThrowable(TableFunctionTest.java:763)
> 	at org.apache.derbyTesting.functionTests.tests.lang.TableFunctionTest.assertResults(TableFunctionTest.java:455)
> 	at org.apache.derbyTesting.functionTests.tests.lang.TableFunctionTest.allLegalDatatypesVTIResults(TableFunctionTest.java:366)
> 	at org.apache.derbyTesting.functionTests.tests.lang.TableFunctionTest.testTableFunctions(TableFunctionTest.java:168)
> 	at java.lang.reflect.AccessibleObject.invokeV(AccessibleObject.java:205)
> 	at <unknown class>.<unknown method>(Unknown Source)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> 3) SetQueryTimeoutTest(org.apache.derbyTesting.functionTests.tests.jdbcapi.JDBCHarnessJavaTest)junit.framework.ComparisonFailure:
Output at line 7 expected:<Statement 1 completed> but was:<Test SetQueryTimeoutTest
FAILED>
> 	at org.apache.derbyTesting.functionTests.util.CanonTestCase.compareCanon(CanonTestCase.java:100)
> 	at org.apache.derbyTesting.functionTests.util.HarnessJavaTest.runTest(HarnessJavaTest.java:91)
> 	at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:95)
> 	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 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)
> For ibm142 and ibm15, it failes with only one new error same as error 1) for IBM J2ME
Foundation Specification v1.1.
> This behavior started on 7/10/2007. The following bugs were checked in on 7/10

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