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

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

     [ https://issues.apache.org/jira/browse/DERBY-6479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rick Hillegas updated DERBY-6479:
---------------------------------

    Issue & fix info: Repro attached,Workaround attached

> 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)