Not valid fields in MERGE's insert clause are allowed [CORE1910]

[firebird-automations]

Submitted by: @asfernandes

Is related to QA347

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

Commits: 71bd20b

[firebird-automations]

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1.1 [ 10223 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Commented by: @asfernandes

Wrong fix version.

[firebird-automations]

Modified by: @asfernandes

Fix Version: 2.5 Alpha 1 [ 10224 ]

Fix Version: 2.1.1 [ 10223 ] =>

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA347 [ QA347 ]

[firebird-automations]

Commented by: @pcisar

QA test added.

[firebird-automations]

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test => Done successfully