[jira] [Closed] (CALCITE-1620) CAST('' AS BINARY) is supported by Hive, but not by Calcite

["Remus Rusanu (JIRA)" <ji...@apache.org>]

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

Remus Rusanu closed CALCITE-1620.
---------------------------------
       Resolution: Not A Problem
    Fix Version/s: 1.12.0

After CALCITE-1653 this is no longer an issue

> CAST('<string>' AS BINARY) is supported by Hive, but not by Calcite
> -------------------------------------------------------------------
>
>                 Key: CALCITE-1620
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1620
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Remus Rusanu
>            Assignee: Julian Hyde
>             Fix For: 1.12.0
>
>
> Hive supports {{CAST('1' as BINARY)}}. Result is 0x31 (can be tested with {noformat}SELECT HEX(CAST('1' as BINARY));{noformat}. If I'm not mistaken, the CAST result is the UTF-8 encoding of the input string.
> CALCITE 1.11 throws AssertionException during compilation for such an expression:
> {noformat}
> Thread [db11b6e6-8fa7-48b3-82ef-c5b4550327ec main] (Suspended (exception AssertionError))             
>                 ConstantExpression.<init>(Type, Object) line: 50      
>                 Expressions.constant(Object, Type) line: 586             
>                 OptimizeShuttle.visit(UnaryExpression, Expression) line: 279
>                 UnaryExpression.accept(Shuttle) line: 37   
>                 Expressions.acceptExpressions(List<Expression>, Shuttle) line: 3184  
>                 MethodCallExpression.accept(Shuttle) line: 60         
>                 TernaryExpression.accept(Shuttle) line: 45
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)