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

Need to document the fact that views can't be the source data sets of MERGE statements

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.11.1.1
    • Fix Version/s: 10.11.1.1
    • Component/s: Documentation
    • Labels:
      None
    • Urgency:
      Normal

      Description

      The work on DERBY-6652 now prevents views from being used as the source data sets of MERGE statements. We should adjust the Reference Guide section on the MERGE statement accordingly. This statement in rrefsqljmerge.dita:

      "sourceTable must identify a base table, a view, or a table function, and it may not be a synonym"

      should be changed to

      "sourceTable must identify a base table or a table function, and it may not be a synonym"

        Attachments

        1. DERBY-6657.diff
          0.8 kB
          Camilla Haase
        2. rrefsqljmerge.html
          13 kB
          Camilla Haase

          Issue Links

            Activity

              People

              • Assignee:
                chaase3 Camilla Haase
                Reporter:
                rhillegas Richard N. Hillegas
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: