Support SQL mode of `NO_ZERO_IN_DATE`, `NO_ZERO_DATE`, and `ERROR_FOR_DIVISION_BY_ZERO`

pingcap / tiflash

The analytical engine for TiDB and TiDB Cloud. Try free: https://tidbcloud.com/free-trial

https://docs.pingcap.com/tidb/stable/tiflash-overview

Apache License 2.0

937 stars 409 forks source link

Support SQL mode of `NO_ZERO_IN_DATE`, `NO_ZERO_DATE`, and `ERROR_FOR_DIVISION_BY_ZERO` #9106

Open gengliqi opened 1 month ago

gengliqi commented 1 month ago

Enhancement

Some functions of TiFlash do not handle sql mode well. These functions should be reviewed and support SQL mode. Currently, we only consider the NO_ZERO_IN_DATE, NO_ZERO_DATE, and ERROR_FOR_DIVISION_BY_ZERO sql mode.

[ ] NO_ZERO_IN_DATE and NO_ZERO_DATE
[ ] ERROR_FOR_DIVISION_BY_ZERO https://github.com/pingcap/tiflash/pull/9107