| 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 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
Description: I m working on mysql 8.0.23 (workbench 8.0.23 build 365764 CE 64 bits community) error call stored procedure using input date parameter mysql 8 I get this error Error Code: 1525. Incorrect DATE value '' How to repeat: I have coded this simple stored procedure as POC DELIMITER || CREATE PROCEDURE checkInvalidDob( DateOfBirth DATE) BEGIN IF(DateOfBirth is null OR DateOfBirth = "") THEN SIGNAL SQLSTATE VALUE '45000' SET MESSAGE_TEXT = 'Field DateOfBirth not valid: '; END IF; END || DELIMITER ; I get this error Error Code: 1525. Incorrect DATE value '' when i try to test/call SP: call checkInvalidDob('1940-30-01'); call checkInvalidDob('2001-03-01'); call checkInvalidDob('1975-04-04'); call checkInvalideDob('1990-05-05');