ERROR 1105 (HY000): strconv.Atoi: parsing "Q": invalid syntax

[sayJason]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

SELECT CAST('4#,8?Q' AS DATE); -- ERROR 1105 (HY000): strconv.Atoi: parsing "Q": invalid syntax

2. What did you expect to see? (Required)

Return null.

3. What did you see instead (Required)

Return an error.

4. What is your TiDB version? (Required)

Release Version: v6.6.0
Edition: Community
Git Commit Hash: f4ca082
Git Branch: heads/refs/tags/v6.6.0
UTC Build Time: 2023-02-17 14:49:02
GoVersion: go1.19.5
Race Enabled: false
TiKV Min Version: 6.2.0-alpha
Check Table Before Drop: false
Store: tikv