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

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

Paul Rogers created IMPALA-7890:
-----------------------------------

             Summary: 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
            Assignee: Paul Rogers


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