description: 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.

=>

Attempts to assign a value to a 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 (which would then allow them to be applied to a user-defined sub-type like sub_type -13 without issue).

description: Attempts to assign a value to a 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 (which would then allow them to be applied to a user-defined sub-type like sub_type -13 without issue).

=>

Attempts to assign a value to a 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 (character set OCTETS) are handled like normal strings, and therefor coerced to blob sub_type text, while they should be coerced to blob sub_type binary instead (which would then allow them to be applied to a user-defined sub-type like sub_type -13 without issue).

description: Attempts to assign a value to a 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 (character set OCTETS) are handled like normal strings, and therefor coerced to blob sub_type text, while they should be coerced to blob sub_type binary instead (which would then allow them to be applied to a user-defined sub-type like sub_type -13 without issue).

=>

Attempts to assign a binary string-literal value to a 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 (character set OCTETS) are handled like normal strings, and therefor coerced to blob sub_type text, while they should be coerced to blob sub_type binary instead (which would then allow them to be applied to a user-defined sub-type like sub_type -13 without issue).

assignee: Adriano dos Santos Fernandes [ asfernandes ]

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 RC 1 [ 10930 ]

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

status: Resolved [ 5 ] => Closed [ 6 ]