Regression: The subquery in the insert list expressions ignore the changes made earlier in the same executable block. [CORE5337] #5613
Comments
Modified by: @sim1984summary: Regression: The cursor does not see the changes made earlier in the same executable block. => Regression: The cursor ignore the changes made earlier in the same executable block. |
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Modified by: @hvladsummary: Regression: The cursor ignore the changes made earlier in the same executable block. => Regression: The subquery in the insert list expressions ignore the changes made earlier in the same executable block. |
|
Commented by: @hvlad The issue occurs with the following conditions: Standalone subqueries are not affected. |
|
Commented by: @hvlad Fix is committed into master (v4). |
|
Commented by: @sim1984 Will this fix ported to 3.0.1? |
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0.1 [ 10730 ] Fix Version: 4.0 Alpha 1 [ 10731 ] |
… returning clause. Fixed also regression for #5613 regarding UPDATE OR INSERT.
Submitted by: @sim1984
WI-V6.3.0.32483 Firebird 3.0
CREATE TABLE TEST (
ID INTEGER NOT NULL,
VAL INTEGER NOT NULL
);
execute block
as
begin
insert into test (id, val) values (1, 100);
insert into test (id, val) values (2, (select val from test where id = 1));
end
The insert failed because a column definition includes validation constraints.
validation error for column "TEST"."VAL", value "*** null ***".
However, here is a code works without error.
execute block
as
declare v integer;
begin
insert into test (id, val) values (1, 100);
select val from test where id = 1 into :v;
insert into test (id, val) values (2, :v);
end
This ticket is related with CORE3362.
Commits: d5ff6d8 d8f43da
The text was updated successfully, but these errors were encountered: