Bug #93444 LocalDateTime parameter values altered when client and server timezones differ
Submitted: 2 Dec 2018 16:56 Modified: 25 Sep 2020 21:33
Reporter: Gord Thompson Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:8.0.13 OS:Any
Assigned to: Filipe Silva CPU Architecture:Any

Contributions can be accepted to Open bugs only.

[20 May 2019 17:42] OCA Admin 
Contribution submitted via Github - Fix for #93444 - improve setObject behavior for LocalDate, LocalDateTime and Loc 
(*) Contribution by 巖 阿部 (Github harawata, mysql-connector-j/pull/36): This PR is an attempt to fix [#93444](https://bugs.mysql.com/bug.php?id=93444). i.e.

- Inserted `LocalDate`, `LocalDateTime` and `LocalTime` values are altered when there is timezone difference between server and client.

The basic idea is to eliminate involvement of the legacy date/time classes (e.g. `java.sql.Timestamp`, `java.util.Calendar`) during the process.

Some notes:

- On my environment, there is no new test failure caused by this change.
- Commented-out lines in `StatementTest` are seemingly unsupported conversions. I left them for you to confirm that they all are expected.
- I have sent my signed OCA a few days ago.
- I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

If there is anything you want me to change or clarify, please let me know.

Attachment: git_patch_280113759.txt (text/plain), 35.05 KiB.