bad BLR -- invalid stream

[olegenty]

СУБД Yaffil, build 885

две таблицы:

Код: Выделить всё

CREATE TABLE IMAGE (
    IMAGE_ID     INTEGER NOT NULL,
    CRC32        BIGINT NOT NULL,
    HEIGHT       SMALLINT NOT NULL,
    WIDTH        SMALLINT NOT NULL,
    BPP          SMALLINT NOT NULL,
    PLANES       SMALLINT NOT NULL,
    COLORS       SMALLINT NOT NULL,
    IMG_SIZE     INTEGER NOT NULL,
    IMG_TYPE     VARCHAR(50) NOT NULL,
    COMPRESSION  VARCHAR(50) NOT NULL,
    IMAGE        BLOB SUB_TYPE 0 SEGMENT SIZE 1024 NOT NULL
);


CREATE TABLE IMAGE_FILENAME (
    IMAGE_ID       INTEGER NOT NULL,
    FILENAME_HASH  VARCHAR(50) NOT NULL,
    FILENAME       VARCHAR(8192) NOT NULL
);

и запрос:

Код: Выделить всё

select 
    * 
from 
    image i 
where 
    i.image_id in (select 
                            f.image_id
                        from 
                            image_filename f
                        group by f.image_id
                        having count(f.filename) > 1 )

даёт ошибку :

Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
bad BLR -- invalid stream.

или я чего-то не понимаю, или это глюк!

[olegenty]

постановка Firebird 1.5.2 + restore сняла эту проблему.