"BLOB not found" error from "delete returning"

[Dimitry Sibiryakov]

Testcase:

create table test (a integer, b blob);
insert into test values(1, 'abc') returning *;
commit;
insert into test select a+100,b from test returning *;
delete from test where a>=100 returning *;

Every query returns correct data except the last one:

SQL> delete from test where a>=100 returning *;

A B
============ =================
101 83:1
==============================================================================
B:
Statement failed, SQLSTATE = HY000
BLOB not found

Is it expected or a bug?

--
WBR, SD.

[Dimitry Sibiryakov]

'Dimitry Sibiryakov' via firebird-support wrote 01.05.2024 16:42:
>   Is it expected or a bug?

JFYI: it is kinda expected. What is worse it was me who implemented this
behaviour.

--
WBR, SD.