|
If you were logged in you would be able to see more operations.
|
|
|
| Planning Status: |
Unspecified
|
|
Test case:
create table t (
n integer primary key,
x1 integer not null,
x2 integer
);
update or insert into t
values (1, 1, 1)
returning old.n, old.x1, old.x2, new.n, new.x1, new.x2;
CONSTANT CONSTANT CONSTANT N X1 X2
============ ============ ============ ============ ============ ============
0 0 <null> 1 1 1
First two columns should return NULL.
|
|
Description
|
Test case:
create table t (
n integer primary key,
x1 integer not null,
x2 integer
);
update or insert into t
values (1, 1, 1)
returning old.n, old.x1, old.x2, new.n, new.x1, new.x2;
CONSTANT CONSTANT CONSTANT N X1 X2
============ ============ ============ ============ ============ ============
0 0 <null> 1 1 1
First two columns should return NULL.
|
Show » |
|
Bug
Closed
Major
Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns
