Kevin Liew created PHOENIX-2946:
-----------------------------------
Summary: Comparison between date and timestamp always returns true
Key: PHOENIX-2946
URL: https://issues.apache.org/jira/browse/PHOENIX-2946
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.6.0, 4.8.0
Reporter: Kevin Liew
Priority: Minor
{code}
0: jdbc:phoenix:thin:url=http://localhost:876> create table test (dateCol DATE
primary key, timestampCol TIMESTAMP);
No rows affected (2.559 seconds)
0: jdbc:phoenix:thin:url=http://localhost:876> upsert into test values
(TO_DATE('1990-01-01'), NOW());
1 row affected (0.255 seconds)
0: jdbc:phoenix:thin:url=http://localhost:876> select dateCol = timestampCol
from test;
+------------------------------------------+
| DATECOL = TIMESTAMPCOL |
+------------------------------------------+
| true |
+------------------------------------------+
1 row selected (0.019 seconds)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
