[
https://issues.apache.org/jira/browse/PHOENIX-3512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15874131#comment-15874131
]
Sergey Soldatov commented on PHOENIX-3512:
------------------------------------------
[~Jeongdae Kim] Thank you for the contribution. But the refactoring in the
patch causes problems with queries like 'select col1 from table where col1 is
null'. For string column col1 it generates the phoenix query 'select col1 from
table where col1 is' and of course it fails. Could you please check it?
> PhoenixStorageHandler makes erroneous query string when handling between
> clauses with date constants.
> -----------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-3512
> URL: https://issues.apache.org/jira/browse/PHOENIX-3512
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.8.0
> Reporter: Jeongdae Kim
> Assignee: Jeongdae Kim
> Labels: HivePhoenix
> Attachments: PHOENIX-3512.patch
>
>
> ex) l_shipdate BETWEEN '1992-01-02' AND '1992-02-02' --> l_shipdate between
> to_date('694278000000') and to_date('696956400000')
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
