[CALCITE-947] Allow optional parameters to have default values other than NULL

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Julian Hyde
• Created: 31/Oct/15 21:54
• Updated: 27/Oct/20 03:28

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.