[Firebird-devel] Possible bug: using UPPER(text_blob) LIKE ? raises isc_convert_error

[Roman R. <rro...@us...>]

Hi,

Let's have following table:

CREATE TABLE ClassMapp (
    oid INTEGER NOT NULL,
    classname BLOB SUB_TYPE 1
);
INSERT INTO ClassMap(oid, classname) VALUES(1, 'test');

then following prepared statement raises  isc_convert_error (335544334)
"conversion error from string "BLOB" in isc_dsql_fetch:

SELECT oid FROM ClassMap WHERE UPPER(classname) LIKE ?

If UPPER cannot be used with text blobs, then statement preparation should
fail, not fetch.

Tested with latest version of JayBird and FB 1.5 RC3 (build 3481) on Windows
2k. Test case can be found in CVS:
client-java/src/test/org/firebirdsql/jdbc/TestFBBlobParams.java

Best regards,
Roman Rokytskyy