Fabiano Bonin wrote:

>
> select result from sp_test
> OK
>
> select substring(result from 1 for 10) from sp_test
> OK

Both should throw.

> select (select substring(result from 1 for 10) from sp_test) from rdb$database
> Error - invalid BLOB ID
>
> select cast(result as varchar(10)) from sp_test
> Error - conversion error from string BLOB

Quite expected, as text blobs are not compatible with strings.

All the queries work fine in v2.1 due to its blob related features.


Dmitry