Error "invalid stream" can be raised in some cases while matching a computed index [CORE4139]

[firebird-automations]

Submitted by: @dyemanov

Votes: 1

Test case:

create table A (ID int);
create table B (ID int);
create index IDX on A computed by (ID);

select min( (select 1 from A where cast(ID as int) = http://B.ID) ) from B
-- ERROR: bad BLR -- invalid stream.

This error is not present if computed index is not created or if CAST is omitted inside the query.

Commits: 123415b FirebirdSQL/fbt-repository@06db666 FirebirdSQL/fbt-repository@dd21f7d

====== Test Details ======

Confirmed fail on WI-V2.5.2.26540:
Statement failed, SQLSTATE = HY000
bad BLR -- invalid stream

[firebird-automations]

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

[firebird-automations]

Modified by: @dyemanov

status: Open [ 1 ] => In Progress [ 3 ]

[firebird-automations]

Modified by: @dyemanov

status: In Progress [ 3 ] => Open [ 1 ]

[firebird-automations]

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.3 [ 10461 ]

[firebird-automations]

Commented by: Dzirt (dzirt)

After this fix does not work this:

recreate table G ( ID Integer, OBJECT_ID computed by (ID) );
commit;
insert into G( OBJECT_ID ) values( 1 );

with message

This column cannot be updated because it is derived from an SQL function or expression.
attempted update of read-only column.

[firebird-automations]

Commented by: @dyemanov

It's the result of CORE3874, not this one.

[firebird-automations]

Modified by: @pavel-zotov

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

QA Status: Done successfully

[firebird-automations]

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-automations]

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

Test Details: Confirmed fail on WI-V2.5.2.26540:
Statement failed, SQLSTATE = HY000
bad BLR -- invalid stream