Bug #109796 | STR_TO_DATE() invalid input doesn't returns NULL but invalid DATE | ||
---|---|---|---|
Submitted: | 26 Jan 2023 21:17 | Modified: | 1 May 10:12 |
Reporter: | Sébastien F. | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S2 (Serious) |
Version: | 8.0.32, 5.7 | OS: | Ubuntu |
Assigned to: | CPU Architecture: | Any | |
Tags: | date str_to_date |
[26 Jan 2023 21:17]
Sébastien F.
[27 Jan 2023 6:47]
MySQL Verification Team
Hello Sébastien F., Thank you for the report and test case. Verified as described. regards, Umesh
[1 May 10:12]
Sébastien F.
When I execute the SQL snippet on MySQL 8.0.37 I now get the awaited values. Can we consider this bug corrected ?
[21 May 12:29]
Roy Lyseng
It looks like a duplicate of 108782, which was fixed in 8.0.35.