[jira] [Created] (SPARK-10508) incorrect evaluation of search case expression

["N Campbell (JIRA)" <ji...@apache.org>]

N Campbell created SPARK-10508:
----------------------------------

             Summary: incorrect evaluation of search case expression
                 Key: SPARK-10508
                 URL: https://issues.apache.org/jira/browse/SPARK-10508
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 1.3.1
            Reporter: N Campbell


The following case expression never evaluates to 'test1' when cdec is -1 or 10 as it will for Hive 0.13. Instead is returns 'other' for all rows.

select rnum, cdec, case when cdec in ( -1,10,0.1 )  then 'test1' else 'other' end from tdec 

create table  if not exists TDEC ( RNUM int , CDEC decimal(7, 2 )    )
TERMINATED BY '\n' 
 STORED AS orc  ;


0|\N
1|-1.00
2|0.00
3|1.00
4|0.10
5|10.00




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

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