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

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            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 - 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 "=>".
            Hide
            Permalink
            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 - Documentation: http://calcite.apache.org/docs/reference.html#calling-functions-with-named-and-optional-parameters
            Hide
            Permalink
            julianhyde Julian Hyde added a comment -

            Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/d012b245.

            Show
            julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/d012b245 .
            Hide
            Permalink
            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