[CALCITE-6544] Calcite's bigquery Dialect date_add and date_sub functions allow 0000 and BC as results

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Bug
• Affects Version/s: 1.37.0
• Fix Version/s: 1.38.0
• Component/s: core
• Assignee: Unassigned
• Reporter: Caican Cai
• Created: 25/Aug/24 12:24
• Updated: 06/Oct/24 15:51
• Resolved: 12/Sep/24 13:21

Description

calcite：

f.checkScalar("date_add(date '0001-01-01', interval '-367' day)",
        "000/-12-31",
        "DATE NOT NULL");

bigquery

date_add(date '0001-01-01', interval '-367' day)

Adding -367 DAY to date 0001-01-01 causes overflow

More details: https://issues.apache.org/jira/browse/CALCITE-6536

Issue Links

• Blocked: CALCITE-6612 Add DATE_SUB function (enabled in Spark library)
• Blocked: CALCITE-6527 Add DATE_ADD function (enabled in Spark library)