Type Conversion in Expression Evaluation
TiDB behaves the same as MySQL: https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
Type Conversion in Expression Evaluationwas last updated 2/11/2022, 3:01:49 AM: Remove aliases from v5.4 (#7559)
You are viewing the documentation of an older version of the TiDB database (TiDB v5.4). It is recommended that you use the latest LTS version of the TiDB database.
TiDB behaves the same as MySQL: https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html