str_to_date() Microseconds with leading zeros are not converted correctly in TiDB

[ramanich1]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

SET sql_mode = default;
select str_to_date("2003-01-02 10:11:12.0012", "%Y-%m-%d %H:%i:%S.%f") as a;

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

+----------------------------+
| a                          |
+----------------------------+
| 2003-01-02 10:11:12.001200 |
+----------------------------+
1 row in set (0.00 sec)

3. What did you see instead (Required)

+----------------------------+
| a                          |
+----------------------------+
| 2003-01-02 10:11:12.120000 |
+----------------------------+
1 row in set (0.00 sec)

4. What is your TiDB version? (Required)

----------------------------------------------------------------------------------------------------------------------------+
| Release Version: v5.4.0-alpha-67-g17edc5758
Edition: Community
Git Commit Hash: 17edc5758fbf865cada7e156318c41d3ee8a7501
Git Branch: master
UTC Build Time: 2021-11-16 02:57:45
GoVersion: go1.17.2
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |

[github-actions]

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.