[jira] [Created] (PHOENIX-1707) Compare (where) between DATE<> UNSIGNED_DATE raise NPE

[Lavrenty Eskin (JIRA)]

Lavrenty Eskin created PHOENIX-1707:
---------------------------------------

             Summary: Compare (where) between DATE<> UNSIGNED_DATE raise NPE
                 Key: PHOENIX-1707
                 URL: https://issues.apache.org/jira/browse/PHOENIX-1707
             Project: Phoenix
          Issue Type: Bug
         Environment: Phoenix 4.3, hbase 0.98
            Reporter: Lavrenty Eskin


select
    FLOOR(REGDATE, 'DAY'),                                <<== UNSIGNED_DATE
   TO_DATE('2015-03-06', 'yyyy-MM-dd')              <<== DATE
from
    "ALARMSHISTORY" as "ALARMSHISTORY"
where
 FLOOR(REGDATE, 'DAY') = TO_DATE('2015-03-06', 'yyyy-MM-dd'); <<== raise 
java.lang.NullPointerException

(!) There are no NULLs in REGDATE

Ways to resolve:
a) Implement TO_UNSIGNED_DATE function
b) Implement correct compare function DATE<> UNSIGNED_DATE




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)