Incorrect ROW_COUNT value with indexed retrieval and subquery [CORE2117] #2549
Labels
affect-version: 2.0.0
affect-version: 2.0.1
affect-version: 2.0.2
affect-version: 2.0.3
affect-version: 2.0.4
affect-version: 2.1.0
affect-version: 2.1.1
affect-version: 2.5 Alpha 1
affect-version: 2.5 Initial
component: engine
fix-version: 2.1.2
fix-version: 2.5 Beta 1
priority: major
qa: done successfully
type: bug
Submitted by: @asfernandes
Is related to QA226
Test case:
create table t (n integer);
insert into t values (1);
insert into t values (2);
insert into t values (3);
commit;
create index t_n on t (n);
set term !;
execute block returns (n integer)
as
declare x integer;
begin
update t set n = n where n = -1;
n = row_count;
suspend;
update t set n = n where n = (select -1 from rdb$database);
n = row_count;
suspend;
update t set n = n where n = -1;
n = row_count;
suspend;
for select 1 from t where n = -1 into x do
begin
end
n = row_count;
suspend;
for select 1 from t where n = (select -1 from rdb$database) into x do
begin
end
n = row_count;
suspend;
delete from t where n = (select -1 from rdb$database);
n = row_count;
suspend;
end!
set term ;!
Returns:
0
1
0
0
1
1
Should return:
0
0
0
0
0
0
Commits: 2223e6a 0793554
The text was updated successfully, but these errors were encountered: