[ https://issues.apache.org/jira/browse/PHOENIX-2944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ankit Singhal updated PHOENIX-2944: ----------------------------------- Fix Version/s: 4.9.0 > 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.9.0, 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)