You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Deepa Remesh (JIRA)" <de...@db.apache.org> on 2006/03/16 18:56:58 UTC
[jira] Created: (DERBY-1120) DatabaseMetaData.getColumnPrivileges
fails in soft upgrade mode
DatabaseMetaData.getColumnPrivileges fails in soft upgrade mode
---------------------------------------------------------------
Key: DERBY-1120
URL: http://issues.apache.org/jira/browse/DERBY-1120
Project: Derby
Type: Bug
Components: JDBC
Versions: 10.2.0.0
Environment: Soft upgrade from 10.1 to 10.2
Reporter: Deepa Remesh
Priority: Critical
Fix For: 10.2.0.0
This issue was found while upgrading from v10.1 to v10.2. The metadata query for getColumnPrivileges refers to SYS.SYSCOLPERMS which is not available in soft upgrade mode. This was found when I was working on DERBY-1076. I am opening a separate JIRA since this does not seem to be a test issue.
The stack trace for failure is:
SQLSTATE(42X05):ERROR 42X05: Table 'SYS.SYSCOLPERMS' does not exist.
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:311)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(FromBaseTable.java:2382)
at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(FromBaseTable.java:2120)
at org.apache.derby.impl.sql.compile.FromList.bindTables(FromList.java:303)
at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(SelectNode.java:471)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(DMLStatementNode.java:220)
at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java:158)
at org.apache.derby.impl.sql.compile.CursorNode.bind(CursorNode.java:252)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:344)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:118)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:721)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:118)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:62)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:92)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareMetaDataStatement(EmbedConnection.java:1614)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(EmbedDatabaseMetaData.java:3172)
at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getColumnPrivileges(EmbedDatabaseMetaData.java:1798)
at org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getMetaDataRS(metadata.java:113)
at org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata_test.runTest(metadata_test.java:729)
at org.apache.derbyTesting.upgradeTests.phaseTester.main(phaseTester.java:177)
Test metadata finished
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Assigned: (DERBY-1120) DatabaseMetaData.getColumnPrivileges
fails in soft upgrade mode
Posted by "Satheesh Bandaram (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1120?page=all ]
Satheesh Bandaram reassigned DERBY-1120:
----------------------------------------
Assign To: Satheesh Bandaram
> DatabaseMetaData.getColumnPrivileges fails in soft upgrade mode
> ---------------------------------------------------------------
>
> Key: DERBY-1120
> URL: http://issues.apache.org/jira/browse/DERBY-1120
> Project: Derby
> Type: Bug
> Components: JDBC
> Versions: 10.2.0.0
> Environment: Soft upgrade from 10.1 to 10.2
> Reporter: Deepa Remesh
> Assignee: Satheesh Bandaram
> Priority: Critical
> Fix For: 10.2.0.0
>
> This issue was found while upgrading from v10.1 to v10.2. The metadata query for getColumnPrivileges refers to SYS.SYSCOLPERMS which is not available in soft upgrade mode. This was found when I was working on DERBY-1076. I am opening a separate JIRA since this does not seem to be a test issue.
> The stack trace for failure is:
> SQLSTATE(42X05):ERROR 42X05: Table 'SYS.SYSCOLPERMS' does not exist.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:311)
> at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(FromBaseTable.java:2382)
> at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(FromBaseTable.java:2120)
> at org.apache.derby.impl.sql.compile.FromList.bindTables(FromList.java:303)
> at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(SelectNode.java:471)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(DMLStatementNode.java:220)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java:158)
> at org.apache.derby.impl.sql.compile.CursorNode.bind(CursorNode.java:252)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:344)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:118)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:721)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:118)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:62)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:92)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareMetaDataStatement(EmbedConnection.java:1614)
> at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(EmbedDatabaseMetaData.java:3172)
> at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getColumnPrivileges(EmbedDatabaseMetaData.java:1798)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getMetaDataRS(metadata.java:113)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata_test.runTest(metadata_test.java:729)
> at org.apache.derbyTesting.upgradeTests.phaseTester.main(phaseTester.java:177)
> Test metadata finished
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Resolved: (DERBY-1120) DatabaseMetaData.getColumnPrivileges
fails in soft upgrade mode
Posted by "Satheesh Bandaram (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1120?page=all ]
Satheesh Bandaram resolved DERBY-1120:
--------------------------------------
Resolution: Duplicate
Duplicate of DERBY-1124. Patch is posted under DERBY-1124.
> DatabaseMetaData.getColumnPrivileges fails in soft upgrade mode
> ---------------------------------------------------------------
>
> Key: DERBY-1120
> URL: http://issues.apache.org/jira/browse/DERBY-1120
> Project: Derby
> Type: Bug
> Components: JDBC
> Versions: 10.2.0.0
> Environment: Soft upgrade from 10.1 to 10.2
> Reporter: Deepa Remesh
> Priority: Critical
> Fix For: 10.2.0.0
>
> This issue was found while upgrading from v10.1 to v10.2. The metadata query for getColumnPrivileges refers to SYS.SYSCOLPERMS which is not available in soft upgrade mode. This was found when I was working on DERBY-1076. I am opening a separate JIRA since this does not seem to be a test issue.
> The stack trace for failure is:
> SQLSTATE(42X05):ERROR 42X05: Table 'SYS.SYSCOLPERMS' does not exist.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:311)
> at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(FromBaseTable.java:2382)
> at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(FromBaseTable.java:2120)
> at org.apache.derby.impl.sql.compile.FromList.bindTables(FromList.java:303)
> at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(SelectNode.java:471)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(DMLStatementNode.java:220)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java:158)
> at org.apache.derby.impl.sql.compile.CursorNode.bind(CursorNode.java:252)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:344)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:118)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:721)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:118)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:62)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:92)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareMetaDataStatement(EmbedConnection.java:1614)
> at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(EmbedDatabaseMetaData.java:3172)
> at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getColumnPrivileges(EmbedDatabaseMetaData.java:1798)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getMetaDataRS(metadata.java:113)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata_test.runTest(metadata_test.java:729)
> at org.apache.derbyTesting.upgradeTests.phaseTester.main(phaseTester.java:177)
> Test metadata finished
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
[jira] Closed: (DERBY-1120) DatabaseMetaData.getColumnPrivileges
fails in soft upgrade mode
Posted by "Deepa Remesh (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1120?page=all ]
Deepa Remesh closed DERBY-1120:
-------------------------------
> DatabaseMetaData.getColumnPrivileges fails in soft upgrade mode
> ---------------------------------------------------------------
>
> Key: DERBY-1120
> URL: http://issues.apache.org/jira/browse/DERBY-1120
> Project: Derby
> Type: Bug
> Components: JDBC
> Versions: 10.2.0.0
> Environment: Soft upgrade from 10.1 to 10.2
> Reporter: Deepa Remesh
> Assignee: Satheesh Bandaram
> Priority: Critical
> Fix For: 10.2.0.0
>
> This issue was found while upgrading from v10.1 to v10.2. The metadata query for getColumnPrivileges refers to SYS.SYSCOLPERMS which is not available in soft upgrade mode. This was found when I was working on DERBY-1076. I am opening a separate JIRA since this does not seem to be a test issue.
> The stack trace for failure is:
> SQLSTATE(42X05):ERROR 42X05: Table 'SYS.SYSCOLPERMS' does not exist.
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:311)
> at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(FromBaseTable.java:2382)
> at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(FromBaseTable.java:2120)
> at org.apache.derby.impl.sql.compile.FromList.bindTables(FromList.java:303)
> at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(SelectNode.java:471)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(DMLStatementNode.java:220)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java:158)
> at org.apache.derby.impl.sql.compile.CursorNode.bind(CursorNode.java:252)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:344)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:118)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:721)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:118)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:62)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:92)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareMetaDataStatement(EmbedConnection.java:1614)
> at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getPreparedQuery(EmbedDatabaseMetaData.java:3172)
> at org.apache.derby.impl.jdbc.EmbedDatabaseMetaData.getColumnPrivileges(EmbedDatabaseMetaData.java:1798)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata.getMetaDataRS(metadata.java:113)
> at org.apache.derbyTesting.functionTests.tests.jdbcapi.metadata_test.runTest(metadata_test.java:729)
> at org.apache.derbyTesting.upgradeTests.phaseTester.main(phaseTester.java:177)
> Test metadata finished
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira