[ODBC-379] ODBC rejects DATETIME value 0-00-00 00:00:00 Created: 2023-01-17  Updated: 2023-02-02

Status: Open
Project: MariaDB Connector/ODBC
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: markus makela Assignee: Lawrin Novitsky
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MXS-2709 ETL / Data Migration Service Closed

 Description   

The DATETIME value 0-00-00 00:00:00 is rejected by the driver with the following error:

[ma-3.1.12][10.10.2-MariaDB-log]Invalid character value for cast specification

MariaDB itself seems to accept this and treat it as if it was 0000-00-00 00:00:00.

This happens when the value is given as a C-string instead of the ODBC date type.


Generated at Thu Feb 08 03:28:16 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.