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

Re-enable views as the source data sets of MERGE statements

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.11.1.1
    • Fix Version/s: None
    • Component/s: SQL
    • Labels:
      None
    • Urgency:
      Normal

      Description

      The SQL Standard allows views as the source data sets of MERGE statements. However, we disabled this feature because of namespace resolution problems (see DERBY-6652). Namespace resolution for the MERGE statement needs to be overhauled. Some of the issues are described on DERBY-3155. When the namespace problems are fixed comprehensively, we may be able to allow the use of synonyms and subqueries and perhaps, also, the use of correlation names for columns.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                rhillegas Richard N. Hillegas
              • Votes:
                2 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated: