[ https://issues.apache.org/jira/browse/PHOENIX-2793?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15439984#comment-15439984 ]
ASF GitHub Bot commented on PHOENIX-2793: ----------------------------------------- GitHub user kliewkliew opened a pull request: https://github.com/apache/phoenix/pull/201 PHOENIX-2793 Date-time functions on null dates return no data I cannot reproduce the issue but I added a test case. You can merge this pull request into a Git repository by running: $ git pull https://github.com/kliewkliew/phoenix PHOENIX-2793 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/phoenix/pull/201.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #201 ---- commit 6c9a3f928f31d373f1d7f25117fbffbdf3a6c246 Author: kliewkliew <kliewkl...@users.noreply.github.com> Date: 2016-08-24T16:55:21Z PHOENIX-2793 Date-time functions on null dates return no data ---- > 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: Bug > 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)