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)
