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)