Error "invalid stream" can be raised in some cases while matching a computed
index
----------------------------------------------------------------------------------
Key: CORE-4139
URL: http://tracker.firebirdsql.org/browse/CORE-4139
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.2 Update 1, 2.1.5 Update 1, 2.5.2, 2.1.5, 2.5.1,
2.1.4, 2.5.0, 2.1.3, 2.1.2, 2.1.1, 2.1.0
Reporter: Dmitry Yemanov
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) = 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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:
Build for Windows Store.
http://p.sf.net/sfu/windows-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
