Bug #102549 | error call stored procedure date parameter mysql 8 1525 Error Code: 1525. Incorr | ||
---|---|---|---|
Submitted: | 10 Feb 2021 3:07 | Modified: | 10 Feb 2021 15:58 |
Reporter: | Maurizio Mattioli | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Workbench: SQL Editor | Severity: | S2 (Serious) |
Version: | 8.0.23 | OS: | Windows (10) |
Assigned to: | CPU Architecture: | Any | |
Tags: | date, date-parsing, mysql-8.0, stored-procedures |
[10 Feb 2021 3:07]
Maurizio Mattioli
[10 Feb 2021 13:11]
MySQL Verification Team
Hello Maurizio Mattioli, Thank you for the bug report. I tried to reproduce your issue on windows 10 with workbench 8.0.23 but I am not seeing any issues testing the last 3 calls that you mentioned. First call i.e call checkInvalidDob('1940-30-01'); -- date is not in correct format. Please make sure that the date must be in 'YYYY-MM-DD' format. When I changed it to call checkInvalidDob('1940-01-30'); -- it worked without any issues. Regards, Ashwini Patil
[10 Feb 2021 15:58]
Maurizio Mattioli
Hello thank you for you answer We are 6 mates we are working togheter (mysql/workbench 8.0.23) with remote laptop in milan (italy) and all of us have experience same error and behaviour with this code, is very strange. for example when call checkInvalideDate('2021-02-10'); # YYYY-MM-DD format In workbench of all of us, it occours same error : 1525 Error Code: 1525. Incorrect Date Value '' Could be depends on DateTime Settings of our country (IT-ITA) ? Thanks in advance for support us