You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Joshua Liu (JIRA)" <ji...@apache.org> on 2017/01/12 08:17:04 UTC

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

Joshua Liu created TRAFODION-2442:
-------------------------------------

             Summary: 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



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.4#6332)