Issue Details (XML | Word | Printable)

Key: CORE-1910
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 0
Watchers: 0

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

Not valid fields in MERGE's insert clause are allowed

Created: 22/May/08 09:35 PM   Updated: 19/Jan/16 06:05 AM
Component/s: Engine
Affects Version/s: 2.5 Initial, 2.1.0
Fix Version/s: 2.5 Alpha 1

Issue Links:

QA Status: Done successfully

 Description  « Hide
create table t1 (n integer, x integer);
create table t2 (a integer, b integer);

merge into t1 t1
  using (select * from t2) t2
    on t1.n = t2.a
    when matched then
      update set x = t2.b
    when not matched then
      insert (a, x) values (1, 2); -- "a" is not a field of t1

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Adriano dos Santos Fernandes added a comment - 22/May/08 09:38 PM
Wrong fix version.

Pavel Cisar added a comment - 21/Apr/11 09:50 AM
QA test added.