Incorrect result with UPDATE OR INSERT ... RETURNING OLD and non-nullable columns [CORE2044]

[firebird-automations]

Submitted by: @asfernandes

Is related to QA361

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.

Commits: fdfe98f

[firebird-automations]

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

[firebird-automations]

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 Beta 1 [ 10251 ]

[firebird-automations]

Modified by: @pcisar

Link: This issue is related to QA361 [ QA361 ]

[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