[#CORE-1910] Not valid fields in MERGE's insert clause are allowed

Firebird Core

Not valid fields in MERGE's insert clause are allowed

Created: 22/May/08 09:35 PM Updated: 22/May/08 09:38 PM

Return to search

Issue 47 of 131 issue(s)

<< Previous | CORE-1910 | Next >>

Component/s:

Engine

Affects Version/s:

2.5 Initial, 2.1.0

Fix Version/s:

2.5 Alpha 1

Time Tracking:

Not Specified

Planning Status:

Unspecified

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

Work Log

Change History

Version Control

Sort Order:

Adriano dos Santos Fernandes made changes - 22/May/08 09:37 PM

Field	Original Value	New Value
Fix Version/s		2.1.1 [ 10223 ]
Resolution		Fixed [ 1 ]
Assignee		Adriano dos Santos Fernandes [ asfernandes ]
Status	Open [ 1 ]	Resolved [ 5 ]

[ Permalink | « Hide ]

Adriano dos Santos Fernandes added a comment - 22/May/08 09:38 PM

Wrong fix version.

Adriano dos Santos Fernandes made changes - 22/May/08 09:38 PM

Fix Version/s		2.5 Alpha 1 [ 10224 ]
Fix Version/s	2.1.1 [ 10223 ]