Error "invalid stream" can be raised in some cases while matching a computed index [CORE4139] #4466
Labels
affect-version: 2.1.0
affect-version: 2.1.1
affect-version: 2.1.2
affect-version: 2.1.3
affect-version: 2.1.4
affect-version: 2.1.5 Update 1
affect-version: 2.1.5
affect-version: 2.5.0
affect-version: 2.5.1
affect-version: 2.5.2 Update 1
affect-version: 2.5.2
component: engine
fix-version: 2.5.3
priority: major
qa: done successfully
type: bug
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
The text was updated successfully, but these errors were encountered: