[CONJ-777] CLONE - Handle zeroDateTimeBehavior Created: 2020-04-07  Updated: 2022-08-16  Resolved: 2022-08-16

Status: Closed
Project: MariaDB Connector/J
Component/s: Other
Affects Version/s: None
Fix Version/s: N/A

Type: Task Priority: Trivial
Reporter: M Assignee: Diego Dupin
Resolution: Not a Bug Votes: 0
Labels: None

Issue Links:
Relates
relates to CONJ-204 Handle zeroDateTimeBehavior Closed

 Description   

Add the mysql "zeroDateTimeBehavior" option to consider date '0000-00-00 00:00:00' like null .

 Comments   
Comment by M [ 2020-04-07 ]

CONJ-204 jira says zeroDateTimeBehavior=convertToNull is not supported by mysql. However mysql8.0 seems to be support that see https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-configuration-properties.html#zeroDateTimeBehavior.

There is also a mysql bugfix for this at https://bugs.mysql.com/bug.php?id=91065 if that helps in the merge process.

Can this be fixed in Connector/J for mariadb? If there are any alternatives, please let me know.

Comment by Diego Dupin [ 2020-09-18 ]

This has been implemented in 1.4.0: current implementation consider '0000-00-00 00:00:00' as null (but for getString where '0000-00-00 00:00:00' is returned)
This correspond to CONVERT_TO_NULL value for option `zeroDateTimeBehavior`.
What is currently wrong ?

Comment by Diego Dupin [ 2022-08-16 ]

closing since i implemented and no response

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