You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2016/08/31 22:59:20 UTC

[jira] [Updated] (PHOENIX-2793) Date-time functions on null dates return no data

     [ https://issues.apache.org/jira/browse/PHOENIX-2793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor updated PHOENIX-2793:
----------------------------------
    Issue Type: Test  (was: Bug)

> 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)