MySQL Bugs: #115622: mysql -5.7.43 STR_TO

Bug #115622	mysql -5.7.43 STR_TO_DATE
Submitted:	17 Jul 2024 8:24	Modified:	17 Jul 2024 9:48
Reporter:	xiaokun li	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Server: Windows	Severity:	S6 (Debug Builds)
Version:	5.7.43	OS:	Windows (select STR_TO_DATE('164701','%H%i%s') as time)
Assigned to:		CPU Architecture:	Other
Tags:	'%H%i%s') as time can not formate, select STR_TO_DATE('164701'

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
select STR_TO_DATE('164701','%H%i%s') as time ;

when I formate this time , it return null;
 
but on the other version (such as  5.7.40/ 5.7.44) it work well

How to repeat:
just use follow sql;

select STR_TO_DATE('164701','%H%i%s') as time ;

Suggested fix:
tell me the reason

Hi Mr. li,

Thank you very much for your bug report.

However, version 5.7 is not supported for many years already.

Unsupported.