caicancai opened a new pull request, #3969: URL: https://github.com/apache/calcite/pull/3969
The following is my recent review of why the BC date is equal to 0000. In calcite, the date function will go through a series of conversions, such as the bigquery date_add function will be converted to DATETIME_PLUS later,and the current adapted DATTIME_PLUS is no exception. After being converted to DATETIME_PLUS, it seems that it will be converted to PLUS operator operation later, and finally enter RexlmpTable.DatetimeArithmeticImplementor to perform parameter type conversion and partial calculation, return normalize(typeName, Expressions.add(trop0, trop1)). Of course, there may be higher levels of abstraction and conversion later, but unfortunately I haven't found it yet. In this process, I found that calcite did not restrict the result set of the date function to the date BC date and 0000. I raised jira and emailed to seek answers: [jira](https://issues.apache.org/jira/browse/CALCITE-6544), there is Julian's explanation in jira, and calcite has its own date rules -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
