[PHOENIX-2944] DATE Comparison Broken

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 4.7.0
• Fix Version/s: 4.9.0, 4.8.1
• Labels: Phoenix
• Flags: Important
• Assignee: Saurabh Seth
• Reporter: Aaron Stephens
• Created: 26/May/16 22:20
• Updated: 28/Sep/16 05:15
• Resolved: 16/Aug/16 05:04

Description

It appears that comparisons involving the DATE type are broken. See examples below:

> 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)