Bug #98605 Front Port Fix of Bug 71084 to 8.x

• Submitted: 14 Feb 2020 13:39
• Modified: 18 Feb 2020 8:16
• Reporter: Sunit C
• Status: Duplicate
• Category: Connector / J
• Severity: S2 (Serious)
• Version: 8.0.19
• OS: MacOS
• CPU Architecture: Any
• Tags: connector, date, java

[14 Feb 2020 13:39] Sunit C

Description:
We had this issue in MySQL 5.7.x with Java 11 and Spring Boot 2.2.x. - https://bugs.mysql.com/bug.php?id=71084

However it got fixed when we upgraded Connector/J to  5.1.48

Recently we upgraded our MySQL database from 5.7 to 8.0.x

This issue is occurring again using Connector/J 8.0.19.

We will need to front port fixes from the bug - https://bugs.mysql.com/bug.php?id=71084 to Connector J 8.0.x

How to repeat:
In a Spring boot 2.2.x with Java 11, try saving a date from application.

Java Field is "java.util.LocalDate"
Database Field type is "DATE"

e.g if you try to save date as 2020-01-01, it gets saved as 2019-12-31

Suggested fix:
front port fixes from the bug - https://bugs.mysql.com/bug.php?id=71084 to Connector J 8.0.x

Front port fixes from 5.1.35 to 8.0.x

[18 Feb 2020 8:16] Alexander Soklakov

Hi Sunit,

This is a duplicate of Bug#91112.