[
https://issues.apache.org/jira/browse/DERBY-5779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rick Hillegas updated DERBY-5779:
---------------------------------
Description: Derby lets you invoke a table function in the FROM list of a
query, passing in arguments built out of columns in other tables in the FROM
list. This syntax is illegal and the resulting queries have no meaning under
the SQL Standard. See the discussion on DERBY-5554. We should forbid this
syntax. Similar syntax involving correlated subqueries in the FROM list is
already forbidden. Fixing this will create a backward incompatibility which
requires a release note. (was: Derby lets you invoke a table function/vti in
the FROM list of a query, passing in arguments built out of columns in other
tables in the FROM list. This syntax is illegal and the resulting queries have
no meaning under the SQL Standard. See the discussion on DERBY-5554. We should
forbid this syntax. Similar syntax involving correlated subqueries in the FROM
list is already forbidden. Fixing this will create a backward incompatibility
which requires a release note. In particular, the sample usage for
SYSCS_DIAG.SPACE_TABLE, given in the Reference Manual, will no longer work
after fixing this bug. Changes to SPACE_TABLE are being discussed on
DERBY-5554.)
Summary: Table functions should only accept arguments which are
constant in their query block. (was: Table functions and vtis should only
accept arguments which are constant in their query block.)
> Table functions should only accept arguments which are constant in their
> query block.
> -------------------------------------------------------------------------------------
>
> Key: DERBY-5779
> URL: https://issues.apache.org/jira/browse/DERBY-5779
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.9.1.0
> Reporter: Rick Hillegas
> Assignee: Rick Hillegas
> Attachments: derby-5779-01-ab-forbidReferencesInQueryBlock.diff,
> releaseNote.html
>
>
> Derby lets you invoke a table function in the FROM list of a query, passing
> in arguments built out of columns in other tables in the FROM list. This
> syntax is illegal and the resulting queries have no meaning under the SQL
> Standard. See the discussion on DERBY-5554. We should forbid this syntax.
> Similar syntax involving correlated subqueries in the FROM list is already
> forbidden. Fixing this will create a backward incompatibility which requires
> a release note.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
