[
https://issues.apache.org/jira/browse/DERBY-6479?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13901472#comment-13901472
]
Rick Hillegas commented on DERBY-6479:
--------------------------------------
Once this change is made, we should update the table in the 10.10 Reference
Guide section titled "CAST function".
> 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)
