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

Allow optional parameters to have default values other than NULL

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      As of CALCITE-941 user-defined functions can have optional parameters and you can omit them or use the DEFAULT keyword. But the default value must be NULL, and therefore the parameter must have an optional type.

      This case would remove that restriction and allow default values which are literals, or calls to system functions (e.g. USER) or references to other parameters, or expressions composed thereof.

        Activity

        There are no comments yet on this issue.

          People

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

            Dates

            • Created:
              Updated:

              Development