db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-3270) Delayed (on-demand) creation of current user schema makes select from view belonging to other schema fail.
Date Tue, 25 Nov 2008 16:19:44 GMT

    [ https://issues.apache.org/jira/browse/DERBY-3270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12650612#action_12650612

Bryan Pendleton commented on DERBY-3270:

Assuming all the tests pass, I think Dag's suggested fix sounds promising.

In the code itself, the terms "origCompilationSchema" and "currCompilationSchema"
seem perhaps too generic. It would be interesting to consider whether the
code is any more self-evident if we used the terms "statementCompilationSchema"
and "expandedViewCompilationSchema" or something like that. Perhaps that
aids in comprehension, or perhaps it just crufts up the code even more.

Views, triggers, procedures, constraints and other "deferred" compilation
objects in the language seem to be thorny. They involve little snippets of SQL which
are parsed and compiled at awkward times in processing, and the rules for
how to interpret the ambiguities that arise are complex. It would be nice if we
can figure out ways to treat these various cases in common, so as Dag observed
mimic'ing what we do for generated columns in view processing seems on the
face of it appealing.

> 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:
>            Reporter: Dag H. Wanvik
>            Assignee: Kathey Marsden
>            Priority: Minor
>         Attachments: derby-3270-dhw-2.diff, derby-3270-dhw-2.stat, derby-3270-dhw.diff,
derby-3270-dhw.stat, derby-3270_diff.txt, 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.

View raw message