Re https://issues.apache.org/jira/browse/CALCITE-6544. Is it possible that BigQuery’s DATE_ADD can return BC dates because BigQuery’s DATE data type has a different range of allowable values than Calcite’s? In other words, it’s not a difference with the DATE_ADD function.
Julian > On Aug 26, 2024, at 8:37 AM, Cancai Cai <caic68...@gmail.com> wrote: > > Thanks for your reply. > > Yes, I also located here, and I finally debugged to > https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/adapter/enumerable/RexImpTable.java#L3802 > but I don’t know how to continue. > > I find it hard to believe that > https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/util/BuiltInMethod.java#L517 > is the processing of the data_add function, because its name is add_months > not date_add > >> 2024年8月26日 23:19，Norman Jordan <norman.jor...@improving.com.INVALID> 写道： >> >> this leads to here: >> https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/util/BuiltInMethod.java#L517 >> [https://opengraph.githubassets.com/6af4884a9b80dd1ac5b81e610caea8c9e34bcc847d0e172706a503b58f4f1557/apache/calcite]<https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/util/BuiltInMethod.java#L517> >> calcite/core/src/main/java/org/apache/calcite/util/BuiltInMethod.java at >> main · >
