[jira] [Commented] (TRAFODION-2442) timstamp can't compare with date type

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-2442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15858204#comment-15858204 ] 

ASF GitHub Bot commented on TRAFODION-2442:
-------------------------------------------

Github user asfgit closed the pull request at:

    https://github.com/apache/incubator-trafodion/pull/948


> timstamp can't compare with date type
> -------------------------------------
>
>                 Key: TRAFODION-2442
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2442
>             Project: Apache Trafodion
>          Issue Type: Bug
>            Reporter: Joshua Liu
>            Assignee: Anoop Sharma
>
> SQL>select * from timestamp_test1 where a > date '2016-12-13';
> A
> --------------------------
> 2016-12-12 00:00:00.000000
> 2017-01-10 00:00:00.000000
> --- 2 row(s) selected.
> we can see that 2016-12-12 00:00:00.000000 is large than '2016-12-13'
> from the plan, we can see:
> explain select * from timestamp_test1 where a > date '2016-12-13';
> …
> STATEMENT ................ select *
>                            from timestamp_test1
>                            where a > date '2016-12-13';
> …
> …
> executor_predicates .... (A > 65535-138-245 00:149:238.32757 ...0)
> --- SQL operation complete.
> here predicates is A > 65535-138-245 00:149:238.32757 which is abnormal



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)