[jira] [Created] (HIVE-17413) predicate involving CAST affects value returned by the SELECT statement

["Jim Hopper (JIRA)" <ji...@apache.org>]

Jim Hopper created HIVE-17413:
---------------------------------

             Summary: predicate involving CAST affects value returned by the SELECT statement
                 Key: HIVE-17413
                 URL: https://issues.apache.org/jira/browse/HIVE-17413
             Project: Hive
          Issue Type: Bug
          Components: Hive
    Affects Versions: 1.2.1
            Reporter: Jim Hopper
            Priority: Critical


steps to reproduce:

{code}
create table t stored as orc as
select cast('2017-08-29 00:01:26' as timestamp) as ts;
{code}

{code}
select ts from t;
{code}

{code}
ts
2017-08-29 00:01:26
{code}

{code}
select ts from t where cast(ts as date) = '2017-08-29';
{code}

{code}
ts
2017-08-29 00:00:00
{code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)