Subject Re: [firebird-support] Firebird 2.1 RC1
Author Dmitry Yemanov
Jean Derrie Rigo wrote:
>
> I have a VIEW with UNION statement and on the SELECT's
> statements exists a BLOB field. In the last versions works fine, but on this
> new RC1, I just get the message:
>
> Unsuccessful execution caused by system error that does not preclude
> successful execution of subsequent statements.
>
> Datatype BLOB is not supported for sorting operation.

This will be fixed in RC2.

> I don't have any ORDER BY, GROUP BY on the SELECT's.

UNION DISTINCT implies sorting.


Dmitry