New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
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: