[PHOENIX-3809] CURRENT_DATE() (with parentheses) is illegal in Calcite

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Labels: calcite
• Assignee: Ankit Singhal
• Reporter: Ankit Singhal
• Created: 24/Apr/17 12:07
• Updated: 02/May/17 07:14
• Resolved: 02/May/17 07:14

Description

Calcite doesn't allow system functions to be specified with parenthesis who doesn't accept arguments.

For eg:-
CURRENT_DATE() is illegal whereas CURRENT_DATE is expected.

At validation level:- SqlValidatorImpl#validateCall

    if ((call.operandCount() == 0)
        && (operator.getSyntax() == SqlSyntax.FUNCTION_ID)
        && !call.isExpanded()) {
      // For example, "LOCALTIME()" is illegal. (It should be
      // "LOCALTIME", which would have been handled as a
      // SqlIdentifier.)
      throw handleUnresolvedFunction(call, (SqlFunction) operator,
          ImmutableList.<RelDataType>of(), null);
    }

Issue Links

• is blocked by: CALCITE-1766 Support system functions having no args with parenthesis too