Benchao Li created CALCITE-5118: ----------------------------------- Summary: SqlDatePartFunction#rewriteCall should check operands length Key: CALCITE-5118 URL: https://issues.apache.org/jira/browse/CALCITE-5118 Project: Calcite Issue Type: Improvement Components: core Affects Versions: 1.30.0 Reporter: Benchao Li Assignee: Benchao Li Fix For: 1.31.0
{{SqlDatePartFunction#rewriteCall}} does not check operands length for now, and it will be rewrite to {{EXTRACT}} unconditionally before validation. E.g. {code:sql} select week(); -- will throw ArrayIndexOutOfBoundsException select week(date '2022-04-27', 1); -- will just ignore second param {code} -- This message was sent by Atlassian Jira (v8.20.7#820007)