[jira] [Updated] (DRILL-4168) NULLIF function documentation should be corrected

["Venki Korukanti (JIRA)" <ji...@apache.org>]

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

Venki Korukanti updated DRILL-4168:
-----------------------------------
    Fix Version/s:     (was: 1.4.0)
                   1.5.0

> NULLIF function documentation should be corrected
> -------------------------------------------------
>
>                 Key: DRILL-4168
>                 URL: https://issues.apache.org/jira/browse/DRILL-4168
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Documentation
>            Reporter: Victoria Markman
>             Fix For: 1.5.0
>
>
> As of 1.4.0 NULLIF accepts two arguments.
> {code}
> 0: jdbc:drill:schema=dfs> select nullif(c_integer, c_bigint, c_double, 123.123) from v1;
> Error: VALIDATION ERROR: From line 1, column 8 to line 1, column 53: Invalid number of arguments to function 'NULLIF'. Was expecting 2 arguments
> [Error Id: 93203c41-cc8d-45fe-9e8f-b46233d10ff9 on atsqa4-133.qa.lab:31010] (state=,code=0)
> {code}
> Documentation states this:
> {code}
> NULLIF Syntax
> NULLIF ( expr1[, expr2, ... expr_n] )  <-- can only be 2 
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)