[jira] [Updated] (HIVE-14619) CASE folding can produce wrong expression

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

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

Jesus Camacho Rodriguez updated HIVE-14619:
-------------------------------------------
    Status: Patch Available  (was: In Progress)

> CASE folding can produce wrong expression
> -----------------------------------------
>
>                 Key: HIVE-14619
>                 URL: https://issues.apache.org/jira/browse/HIVE-14619
>             Project: Hive
>          Issue Type: Bug
>          Components: CBO
>    Affects Versions: 2.1.0
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>            Priority: Critical
>
> This is a case that was not covered in the testsuite. For the following query:
> {code:sql}
> select (CASE WHEN key = value THEN '1' WHEN true THEN '0' ELSE NULL END)
> from src
> {code}
> Currently, we end up folding the select expression to '0', as we fail bail out in the second statement and fail to account that there are two different possible values for the CASE expression ('1' and '0').



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