Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5779

Table functions should only accept arguments which are constant in their query block.

    XMLWordPrintableJSON

Details

    • 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

        1. releaseNote.html
          3 kB
          Richard N. Hillegas
        2. derby-5779-04-ab-subqueriesInFromList.diff
          18 kB
          Richard N. Hillegas
        3. derby-5779-04-aa-subqueriesInFromList.diff
          9 kB
          Richard N. Hillegas
        4. derby-5779-03-aa-moreTests.diff
          5 kB
          Richard N. Hillegas
        5. derby-5779-02-aa-forbidReferencesToJoinedTables.diff
          5 kB
          Richard N. Hillegas
        6. derby-5779-01-ab-forbidReferencesInQueryBlock.diff
          8 kB
          Richard N. Hillegas

        Issue Links

          Activity

            People

              rhillegas Richard N. Hillegas
              rhillegas Richard N. Hillegas
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: