|
If you were logged in you would be able to see more operations.
|
|
|
| Planning Status: |
Unspecified
|
|
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
|
|
Description
|
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
|
Show » |
|
Bug
Closed
Major
Not valid fields in MERGE's insert clause are allowed
