phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Liew (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2946) Comparison between date and timestamp always returns true
Date Wed, 01 Jun 2016 16:04:59 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-2946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15310539#comment-15310539
] 

Kevin Liew commented on PHOENIX-2946:
-------------------------------------

I forgot to do {code} select * from test {code}
but it shows something like {code}1990-01-01, 2016-06-01 16:03:15.199{code}


> 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
>              Labels: comparison, date, timestamp
>
> {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)

Mime
View raw message