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