Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
10.9.1.0
-
Normal
-
Patch Available, Release Note Needed
-
Deviation from standard, Wrong query result
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.
Attachments
Attachments
Issue Links
- is related to
-
DERBY-6593 Using a natural join, you can invoke a table function with an argument which is outside the scope of the query block.
- Open
- relates to
-
DERBY-5554 NullPointerException in generated VTI code
- Closed