[jira] [Created] (DERBY-6479) Allow cast of BLOB to other binary types

["Rick Hillegas (JIRA)" <ji...@apache.org>]

Rick Hillegas created DERBY-6479:
------------------------------------

             Summary: Allow cast of BLOB to other binary types
                 Key: DERBY-6479
                 URL: https://issues.apache.org/jira/browse/DERBY-6479
             Project: Derby
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 10.11.0.0
            Reporter: Rick Hillegas


The SQL Standard allows explicit casts between all binary types. See the 2011 edition of the Standard, part 6.13 (cast specification), syntax rule 6. However, Derby doesnt' allow casts of BLOB to other binary types. We should allow this. The following script shows the current behavior:

connect 'jdbc:derby:memory:db;create=true';

create table blobTable( a blob );
create table binaryTable( a varchar( 16 ) for bit data );

-- works

insert into binaryTable select cast( a as varchar( 16 ) for bit data ) from blobTable;

-- fails
insert into blobTable select cast( a as blob ) from binaryTable;




--
This message was sent by Atlassian JIRA
(v6.1.5#6160)