[Enhancement] Support a new time parsing format

[zclllyybb]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Description

mysql> insert into httplogs1 values('20/Jul/2023:15:50:05 +0800', '[1.1.1.1](http://1.1.1.1/)', 'req', 200, 1000);
ERROR 1105 (HY000): errCode = 2, detailMessage = ([172.21.16.12](http://172.21.16.12/))[INTERNAL_ERROR]Invalid value 20/Jul/2023:15:50:05 +0800 in strict mode for function CAST, source column String, from type String to type DateTimeV2

Solution

Support to parse datelike type literal which date part is with format like 20/Jul/2023. It should be deal in both BE & FE for insert into and streamload. When support it in BE, performance rollback may be noteworthy.

Are you willing to submit PR?

• [ ] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[felixwluo]

will pick

[zclllyybb]

will pick

Sure! u can add my wechat torch-wood_ for more information.

[guochao521]

I want to try it

[tudouzhao]

I want to have a try, too!

[Tech-Circle-48]

i can try it