[CALCITE-5554] Add DAYOFWEEK and DAYOFYEAR as valid synonyms of DOW, DOY

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.35.0
• Labels: pull-request-available
• Assignee: Tanner Clary
• Reporter: Tanner Clary
• Created: 03/Mar/23 07:05
• Updated: 06/Nov/23 19:38
• Resolved: 18/Mar/23 16:27

Description

Currently, a query such as: EXTRACT(DAYOFWEEK FROM DATE '2008-12-25'); is invalid while EXTRACT(DOW FROM DATE '2008-12-25') is acceptable. BigQuery (and perhaps other dialects) accept the non-abbreviated version as a valid time unit. After this change, DAYOFWEEK and DAYOFYEAR would both be synonyms of DOW and DOY, respectively.

Relevant BigQuery Docs

Any comments, questions, or suggestions for the linked PR are highly appreciated.

Issue Links

• is related to: CALCITE-2539 Several test case not passed in CalciteSqlOperatorTest.java
• relates to: CALCITE-6092 Invalid test cases in CAST String to Time
• links to: GitHub Pull Request #3094