drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Barclay (Drill) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2935) Casting varchar to varbinary fails
Date Tue, 30 Jun 2015 00:03:05 GMT

    [ https://issues.apache.org/jira/browse/DRILL-2935?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14606694#comment-14606694
] 

Daniel Barclay (Drill) commented on DRILL-2935:
-----------------------------------------------

Why did or does this seem to be a bug?

In ISO/IEC 9075-2:2011(E) section 6.13 <cast specification>, syntax rule 6 says that
casting from any character string type (CHAR, VARCHAR, or CLOB) to any binary string type
(BINARY, VARBINARY, BLOB) is not valid.

The reported behavior seems to be consistent with that.


> Casting varchar to varbinary fails
> ----------------------------------
>
>                 Key: DRILL-2935
>                 URL: https://issues.apache.org/jira/browse/DRILL-2935
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Data Types
>            Reporter: Rahul Challapalli
>            Assignee: Daniel Barclay (Drill)
>             Fix For: 1.2.0
>
>         Attachments: error.log
>
>
> git.commit.id.abbrev=5fbd274
> The below query fails :
> {code}
> select concat(cast(cast('apache ' as varchar(7)) as varbinary(20)), 'drill') from `dummy.json`;
> Query failed: PARSE ERROR: From line 1, column 15 to line 1, column 66: Cast function
cannot convert value of type VARCHAR(7) to type VARBINARY(20)
> [4b5916d1-6b96-42a0-9afa-80706f2bd263 on qa-node191.qa.lab:31010]
> Error: exception while executing query: Failure while executing query. (state=,code=0)
> {code}
> I attached the error log. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message