[jira] [Comment Edited] (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:comment-tabpanel&focusedCommentId=13901472#comment-13901472 ] 

Rick Hillegas edited comment on DERBY-6479 at 2/14/14 2:51 PM:
---------------------------------------------------------------

Our documentation on casts seems to be confused. The 10.10 Reference Guide section titled "CAST function" asserts the opposite of the facts. It says that you can cast other binary types to BLOB and you can only cast BLOB to BLOB.


was (Author: rhillegas):
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)