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:
None 
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
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');
[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