casting Time to Year gives the wrong result

[YangKeao]

Bug Report

1. Minimal reproduce step (Required)

select cast(cast('22:03' as time) as year);

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

mysql> select cast(cast('22:03' as time) as year);
+-------------------------------------+
| cast(cast('22:03' as time) as year) |
+-------------------------------------+
|                                2023 |
+-------------------------------------+
1 row in set (0.00 sec)

3. What did you see instead (Required)

mysql> select cast(cast('22:03' as time) as year);
+-------------------------------------+
| cast(cast('22:03' as time) as year) |
+-------------------------------------+
|                              220300 |
+-------------------------------------+
1 row in set (0.00 sec)

4. What is your TiDB version? (Required)

+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()                                                                                                                                                                              |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: None
Edition: Community
Git Commit Hash: None
Git Branch: None
UTC Build Time: None
GoVersion: go1.21.3
Race Enabled: false
Check Table Before Drop: false
Store: unistore |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)