drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kristine Hahn (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-4168) NULLIF function documentation should be corrected
Date Fri, 18 Dec 2015 01:21:46 GMT

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

Kristine Hahn resolved DRILL-4168.
----------------------------------
    Resolution: Fixed

Fixed. Thanks!

> 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
>            Assignee: Kristine Hahn
>             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)

Mime
View raw message