[ https://issues.apache.org/jira/browse/PHOENIX-2793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15456559#comment-15456559 ]
ASF GitHub Bot commented on PHOENIX-2793: ----------------------------------------- Github user kliewkliew commented on the issue: https://github.com/apache/phoenix/pull/201 https://github.com/apache/phoenix/commit/06d37e534d1e07e8206eaefb82dd7bf3f50455b0 > 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)