[DERBY-6657] Need to document the fact that views can't be the source data sets of MERGE statements

• 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
• Urgency: Normal
• Assignee: Camilla Haase
• Reporter: Richard N. Hillegas
• Created: 10/Jul/14 12:36
• Updated: 09/Sep/16 09:53
• Resolved: 10/Jul/14 15:29

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"

Issue Links

• relates to: DERBY-6652 Compilation error using a view as the source data set for a MERGE statement