[
https://issues.apache.org/jira/browse/DERBY-3270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12647079#action_12647079
]
Kathey Marsden commented on DERBY-3270:
---------------------------------------
Here is the full stack trace.
java.sql.SQLException: Schema 'BILL' does not exist
java.sql.SQLException: Schema 'BILL' does not exist
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:45)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:201)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:391)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2201)
at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:81)
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:614)
at
org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(EmbedStatement.java:152)
at Main.doSingleDriver(Main.java:55)
at Main.main(Main.java:71)
Caused by: ERROR 42Y07: Schema 'BILL' does not exist
at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java:286)
at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(DataDictionaryImpl.java:1487)
at
org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(QueryTreeNode.java:1343)
at
org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(QueryTreeNode.java:1276)
at org.apache.derby.impl.sql.compile.TableName.bind(TableName.java:238)
at
org.apache.derby.impl.sql.compile.FromBaseTable.getMatchingColumn(FromBaseTable.java:2524)
at
org.apache.derby.impl.sql.compile.FromList.bindColumnReference(FromList.java:602)
at
org.apache.derby.impl.sql.compile.ColumnReference.bindExpression(ColumnReference.java:349)
at
org.apache.derby.impl.sql.compile.ResultColumn.bindExpression(ResultColumn.java:588)
at
org.apache.derby.impl.sql.compile.ResultColumnList.bindExpressions(ResultColumnList.java:696)
at
org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(SelectNode.java:443)
at
org.apache.derby.impl.sql.compile.FromSubquery.bindExpressions(FromSubquery.java:216)
at
org.apache.derby.impl.sql.compile.FromList.bindExpressions(FromList.java:350)
at
org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(SelectNode.java:427)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(DMLStatementNode.java:227)
at
org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java:140)
at
org.apache.derby.impl.sql.compile.CursorNode.bindStatement(CursorNode.java:236)
at
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:314)
at
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConne
ctionContext.java:796)
at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:606)
... 3 more
> Delayed (on-demand) creation of current user schema makes select from view
> belonging to other schema fail.
> ----------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3270
> URL: https://issues.apache.org/jira/browse/DERBY-3270
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.3.1.4
> Reporter: Dag H. Wanvik
> Priority: Minor
> Attachments: Main.java
>
>
> The enclosed repro fails with error 42Y07 'Schema BILL does not exist', even
> though
> the query does not reference that schema; it selects from joe.myview.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
