[ https://issues.apache.org/jira/browse/PHOENIX-2946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15472481#comment-15472481 ]
ASF GitHub Bot commented on PHOENIX-2946: ----------------------------------------- Github user kliewkliew closed the pull request at: https://github.com/apache/phoenix/pull/206 > 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: Kevin Liew > Priority: Minor > Labels: comparison, date, timestamp > Fix For: 4.9.0, 4.8.1 > > Attachments: PHOENIX-2946_v2.patch, PHOENIX-2946_v3.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)