Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4168

NULLIF function documentation should be corrected

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.5.0
    • Component/s: Documentation
    • Labels:
      None

      Description

      As of 1.4.0 NULLIF accepts two arguments.

      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)
      

      Documentation states this:

      NULLIF Syntax
      NULLIF ( expr1[, expr2, ... expr_n] )  <-- can only be 2 
      

        Attachments

          Activity

            People

            • Assignee:
              krishahn Kris Hahn
              Reporter:
              vicky Victoria Markman
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: