[PR] [CALCITE-6761] StarRocks generates incorrect SQL for certain units in the EXTRACT function [calcite]

[via GitHub]

xiaochen-zhou opened a new pull request, #4122:
URL: https://github.com/apache/calcite/pull/4122

   StarRocks does not support the following `EXTRACT` unit syntax, and 
`StarRocksSqlDialect` may require some adjustments to accommodate this.
   
   
![image](https://github.com/user-attachments/assets/d11d927c-6051-426d-b742-73359f950c48)
   
   
   For example:
   
   ```
   SELECT EXTRACT(DOW FROM DATE '2023-12-01');
   
   SELECT EXTRACT(DOY FROM DATE '2023-12-01');
   ```
   
   To ensure compatibility during the StarRocks dialect conversion, the above 
syntax can be translated as follows:
   
   ```
   SELECT DAYOFWEEK(DATE '2023-12-01');
   
   SELECT DAYOFYEAR(DATE '2023-12-01');
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@calcite.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org