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) Projected comparison between date and timestamp columns always returns true
Date Thu, 08 Sep 2016 18:29:20 GMT

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

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

Thanks [~giacomotaylor], I'm glad to see this fixed.

> Projected comparison between date and timestamp columns 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
>            Assignee: James Taylor
>            Priority: Minor
>              Labels: comparison, date, timestamp
>             Fix For: 4.9.0, 4.8.1
>
>         Attachments: PHOENIX-2946_v2.patch, PHOENIX-2946_v3.patch, PHOENIX-2946_v4.patch,
PHOENIX-2946_v5.patch, PHOENIX-2946_v6.patch
>
>
> {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