[
https://issues.apache.org/jira/browse/CALCITE-5450?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde resolved CALCITE-5450.
----------------------------------
Fix Version/s: 1.33.0
Resolution: Fixed
Fixed in
[13ef58|https://github.com/apache/calcite/commit/13ef58b50655ce63d88f60c736c5fae4701a8300];
thanks for the fix, [~oliverlee] and [~tanclary]!
> Add support for WEEK(WEEKDAY) for custom time frames to relevant functions
> --------------------------------------------------------------------------
>
> Key: CALCITE-5450
> URL: https://issues.apache.org/jira/browse/CALCITE-5450
> Project: Calcite
> Issue Type: Improvement
> Reporter: Oliver Lee
> Assignee: Oliver Lee
> Priority: Minor
> Fix For: 1.33.0
>
>
> Some BigQuery functions, such as {{EXTRACT}} and {{{}DATE_TRUNC{}}}, accept
> the operand {{{}WEEK(weekday){}}}, where {{weekday}} is one of {{{}SUNDAY,
> MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY{}}}. After this
> change, any function that accepts {{WEEK}} or {{ISOWEEK}} timeframe will also
> accept {{WEEK(SUNDAY)}} etc.
>
> Note that {{WEEK}} is equivalent to {{WEEK(SUNDAY)}} and {{ISOWEEK}} is
> equivalent to {{{}WEEK(MONDAY){}}}.
> In this change we also allow {{WEEKS}} as a synonym for {{{}WEEK{}}}, and
> {{QUARTERS}} as a synonym for {{{}QUARTER{}}}.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
