mysqlconnector unable to process the date like: 2025-01-00 in MariaDB

[LinusLiuMS]

Software versions
MySqlConnector version: 2.2.7
Server type (MySQL, MariaDB, Aurora, etc.) and version: mariaDB 11.4
.NET version: 4.7.2
(Optional) ORM NuGet packages and versions:

Describe the bug
In the MariaDB server, we have table with column as date type. And we have inserted data like: 2025-01-00 as value for the date column,
++ in mariadb client tool: like HeidiSQL, we can read the data without any issue.
++ But when using Azure Data Factory which is using MySQLconnector, it is failing with error as below:
Type=System.FormatException,Message=Couldn't interpret value as a valid DateTime: l\u0007\u0001\u0000,Source=MySqlConnector,''Type=System.ArgumentOutOfRangeException,Message=Year, Month, and Day parameters describe an un-representable DateTime.

Exception
Full exception message and call stack (if applicable)
at MySqlConnector.Core.BinaryRow.ReadDateTime(ReadOnlySpan`1 value) in /_/src/MySqlConnector/Core/BinaryRow.cs:line 193,'","FailureInitiator":"Source"},"MsgId":null,"ExceptionType":null,"Source":null,"StackTrace":null,"InnerEventInfos":[]}\r\n
Code sample

/* A concise code sample to reproduce the bug */

Expected behavior
It may pass the invalid value as null but will not throw exception which caused ADF job to fail.

Additional context
Add any other context about the problem here.

[bgrainger]

Does adding Allow Zero Date Time=true; to your connection string help?

https://mysqlconnector.net/connection-options/#AllowZeroDateTime

[bgrainger]

It might not help if ADF is expecting DateTime values to be returned, because Allow Zero Date Time will make MySqlConnector start returning MySqlDateTime objects instead. But if ADF needs a DateTime value, your database is incompatible with it because 2025-01-00 is not a valid DateTime.

Consider storing only valid DateTime values in your database instead.