Sysvar: consolidate the 'SQL Mode' used by the internal sessions
Open
type/enhancement
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
Currently, there are quite a lot of 'internal SQLs' used by TiDB, the execution of those internal SQLs might be affected by the SQL mode in global scope, which leads to some bugs:
* [#43488](https://github.com/pingcap/tidb/issues/43488) and [#43392](https://github.com/pingcap/tidb/issues/43392)
IMO we should review all the internal SQLs and the values of SQL mode, make it consolidate without being affected by user settings to avoid those bugs in the future.
Contributor guide
Assessment
This issue has not been assessed yet.