[
https://issues.apache.org/jira/browse/PHOENIX-2793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15453651#comment-15453651
]
James Taylor commented on PHOENIX-2793:
---------------------------------------
[~samarthjain] - would you mind reviewing and committing the test that [~kliew]
added?
> Date-time functions on null dates return no data
> ------------------------------------------------
>
> Key: PHOENIX-2793
> URL: https://issues.apache.org/jira/browse/PHOENIX-2793
> Project: Phoenix
> Issue Type: Test
> Affects Versions: 4.4.0
> Environment: HDP 2.3.4
> Reporter: Kevin Liew
> Assignee: Kevin Liew
> Priority: Minor
> Labels: date, function, time, timestamp
>
> {code:sql}select month(at1.DATE_col5) from at1 where date_col5 is null{code}
> returns zero rows but should return one null row for each null row in
> at1.DATE_col5
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
