Using binary string literal to assign to user-defined blob sub-types yield
conversion error "filter not found to convert type 1 to type -13"
--------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-6389
URL: http://tracker.firebirdsql.org/browse/CORE-6389
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.6, 4.0 Beta 2, 2.5.9
Reporter: Mark Rotteveel
Attempts to assign a value to an user-defined blob sub-type yields a conversion
error.
SQL> create table blob13(id integer generated by default as identity primary
key, blobfield blob sub_type -13);
SQL> insert into blob13 (blobfield) values (x'ab01');
Statement failed, SQLSTATE = HY000
filter not found to convert type 1 to type -13
SQL>
Workaround: add an explicit cast to either blob sub_type binary or blob
sub_type -13
It looks like binary string literals are handled like normal strings, and
therefor coerced to blob sub_type text, while they should be coerced to blob
sub_type binary instead.
--
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
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
