[ https://issues.apache.org/jira/browse/PHOENIX-2944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15414670#comment-15414670 ]
Saurabh Seth commented on PHOENIX-2944: --------------------------------------- Thanks [~an...@apache.org]. I'm assuming there isn't any more work required on this patch. I have added 4 test methods to an existing end2end test. The QA bot doesn't seem to count these. And the javadoc warnings seem unrelated as well. > DATE Comparison Broken > ---------------------- > > Key: PHOENIX-2944 > URL: https://issues.apache.org/jira/browse/PHOENIX-2944 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.7.0 > Reporter: Aaron Stephens > Assignee: Saurabh Seth > Priority: Critical > Labels: Phoenix > Fix For: 4.8.1 > > Attachments: PHOENIX-2944.patch > > > It appears that comparisons involving the DATE type are broken. See examples > below: > {noformat} > > select DATE '2016-05-10 00:00:00' > DATE '2016-05-11 00:00:00'; > > > +-------+ > > | true | > > +-------+ > > | true | > > +-------+ > > 1 row selected (0.001 seconds) > > select TIMESTAMP '2016-05-10 00:00:00' > DATE '2016-05-11 00:00:00'; > > > +-------+ > > | true | > > +-------+ > > | true | > > +-------+ > > 1 row selected (0.001 seconds) > > select DATE '2016-05-10 00:00:00' > TIMESTAMP '2016-05-11 00:00:00'; > > > +-------+ > > | true | > > +-------+ > > | true | > > +-------+ > 1 row selected (0.001 seconds) > > select TIMESTAMP '2016-05-10 00:00:00' > TIMESTAMP '2016-05-11 00:00:00'; > > > +--------+ > > | false | > > +--------+ > > | false | > > +--------+ > > 1 row selected (0.001 seconds) > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)