phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ankit Singhal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2944) DATE Comparison Broken
Date Tue, 09 Aug 2016 06:13:21 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-2944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15413002#comment-15413002
] 

Ankit Singhal commented on PHOENIX-2944:
----------------------------------------

I'll commit this after QA bot gives a clean run.

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

Mime
View raw message