v.21.7Improvement

Make String-to-Int Parser Stricter

Make String-to-Int parser stricter so that toInt64('+') will throw. #24475 (Amos Bird).
Made the string-to-integer parser stricter in ClickHouse so that functions like toInt64('+') will now throw an error instead of silently converting.

Why it matters

This feature improves input validation by preventing invalid or ambiguous string inputs, such as a standalone '+' sign, from being incorrectly parsed as valid integers. It helps users catch data issues early, ensuring data integrity and reducing unexpected behavior during type conversion.

How to use it

No explicit action is required from users. The stricter parsing behavior is applied automatically when using string-to-integer conversion functions like toInt64 starting with this version of ClickHouse.