You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Kevin Liew (JIRA)" <ji...@apache.org> on 2016/05/28 01:12:12 UTC
[jira] [Created] (PHOENIX-2946) Comparison between date and
timestamp always returns true
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)