You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Rick Hillegas (JIRA)" <ji...@apache.org> on 2014/07/10 14:26:04 UTC

[jira] [Created] (DERBY-6656) Re-enable views as the source data sets of MERGE statements

Rick Hillegas created DERBY-6656:
------------------------------------

             Summary: Re-enable views as the source data sets of MERGE statements
                 Key: DERBY-6656
                 URL: https://issues.apache.org/jira/browse/DERBY-6656
             Project: Derby
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 10.11.0.0
            Reporter: Rick Hillegas


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.



--
This message was sent by Atlassian JIRA
(v6.2#6252)