[jira] [Assigned] (IMPALA-7890) Wrong expression type for addition with invalid cast

["Paul Rogers (JIRA)" <ji...@apache.org>]

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

Paul Rogers reassigned IMPALA-7890:
-----------------------------------

    Assignee:     (was: Paul Rogers)

> Wrong expression type for addition with invalid cast
> ----------------------------------------------------
>
>                 Key: IMPALA-7890
>                 URL: https://issues.apache.org/jira/browse/IMPALA-7890
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>    Affects Versions: Impala 3.0
>            Reporter: Paul Rogers
>            Priority: Minor
>
> Consider this SQL statement:
> {code:sql}
> SELECT 1 + CAST('123' AS SMALLINT) FROM alltypestiny
> {code}
> This runs as expected and produces the value of 124 as an INT as expected.
> Now consider this version:
> {code:sql}
> SELECT 1 + CAST('ABC' AS SMALLINT) FROM alltypestiny
> {code}
> This version analyzes OK. The analyzer detects that the cast is invalid and leaves the AST in its original form. However, the analyzer sets the type of the expression to {{SMALLINT}} rather than the proper {{INT}}.
> (Impala uses conservative type propagation rules: if either operand of addition is {{SMALLINT}}, the result should be {{INT}}.)
> Would have expected the analyzer to either:
> * Fail the query when it detected the cast failure, or
> * Leave the AST unchanged and leave the expression type unchanged at {{INT}}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org