默认就包含严格模式。ticdc好像强制设置会话级的sql_mode了。
[2026/07/30 08:57:15.403 +08:00] [INFO] [helper.go:277] [“sink uri is configured”] [dsn=“my_sync:******@tcp(10.0.40.122:4001)/?interpolateParams=true&multiSt
atements=true&allow_auto_random_explicit_insert=1&charset=utf8mb4&foreign_key_checks=0&maxAllowedPacket=0&readTimeout=2m&sql_mode=%22NO_ENGINE_SUBSTITUTION%2
CALLOW_INVALID_DATES%2CIGNORE_SPACE%2CONLY_FULL_GROUP_BY%2CNO_AUTO_VALUE_ON_ZERO%22&tidb_cdc_write_source=1&tidb_enable_external_ts_read=%22OFF%22&tidb_place
ment_mode=%22ignore%22&tidb_txn_mode=optimistic&timeout=2m&transaction_isolation=%22READ-COMMITTED%22&writeTimeout=2m”]
MySQL [test]> SELECT @@sql_mode;
±------------------------------------------------------------------------------------------------------------------------------------------+
| @@sql_mode |
±------------------------------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
±------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)