Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-941

Named, optional and DEFAULT arguments to function calls

    Details

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

      Description

      Investigate whether named parameter passing is in the SQL standard, and implement it in Calcite.

      See https://community.oracle.com/thread/482633?start=0&tstart=0 for an example.

        Activity

        Hide
        julianhyde Julian Hyde added a comment -
        Show
        julianhyde Julian Hyde added a comment - DB2 has supported this since 7.2; see http://www.ibm.com/developerworks/ibmi/library/i-sql-parameter-name-default-value/ . Also note use of the DEFAULT keyword. Also Postgres: see http://www.postgresql.org/docs/9.1/static/sql-createfunction.html and http://www.postgresql.org/docs/9.1/static/sql-syntax-calling-funcs.html . They use ":=" not "=>".
        Show
        julianhyde Julian Hyde added a comment - Documentation: http://calcite.apache.org/docs/reference.html#calling-functions-with-named-and-optional-parameters
        Show
        julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/d012b245 .
        Hide
        jcamachorodriguez Jesus Camacho Rodriguez added a comment -

        Resolved in release 1.5.0 (2015-11-10)

        Show
        jcamachorodriguez Jesus Camacho Rodriguez added a comment - Resolved in release 1.5.0 (2015-11-10)

          People

          • Assignee:
            julianhyde Julian Hyde
            Reporter:
            julianhyde Julian Hyde
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development