[
https://issues.apache.org/jira/browse/CALCITE-1620?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15878907#comment-15878907
]
Remus Rusanu commented on CALCITE-1620:
---------------------------------------
CALCITE-1653 makes this obsolete. Using the Hive executor during constant
simplification yields the same result as in Hive.
> 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
>
> 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)
