Issue Details (XML | Word | Printable)

Key: CORE-2274
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Paul Vinkenoog
Votes: 1
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

MERGE non-standard behaviour, accepts multiple matches

Created: 13/Jan/09 11:10 AM   Updated: 13/Jan/09 12:01 PM
Component/s: Engine
Affects Version/s: 2.1.1
Fix Version/s: None

Time Tracking:
Not Specified

Planning Status: Unspecified


 Description  « Hide
If the WHEN MATCHED clause is present and a record in the target table matches multiple records in the source, an exception should be raised ("cardinality violation").

Firebird's behaviour is to execute the UPDATE for every match found, each one of them overwriting the previous one, wasting resources and giving an unpredictable result (i.e., you don't know which of the source records will eventually determine the outcome).


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.