[ https://issues.apache.org/jira/browse/PHOENIX-2946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15474347#comment-15474347 ]
James Taylor commented on PHOENIX-2946: --------------------------------------- Improvements to test coverage for TIMESTAMP has been moved to PHOENIX-3255. > 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 > > > {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)