chunjun icon indicating copy to clipboard operation
chunjun copied to clipboard

[feature-1217][chunjun-connector] DateTime type conversion fails in different modes

Open kinoxyz1 opened this issue 2 years ago • 2 comments

DateTime type conversion fails in different modes

Purpose of this pull request

Which issue you fix

Fixes #1217

Checklist:

  • [x] I have executed the 'mvn spotless:apply' command to format my code.
  • [x] I have a meaningful commit message (including the issue id, the template of commit message is '[label-type-#issue-id][fixed-module] a meaningful commit message.')
  • [x] I have performed a self-review of my own code.
  • [ ] I have commented my code, particularly in hard-to-understand areas.
  • [ ] I have made corresponding changes to the documentation.
  • [ ] I have added tests that prove my fix is effective or that my feature works.
  • [x] New and existing unit tests pass locally with my changes.
  • [ ] I have checked my code and corrected any misspellings.
  • [x] My commit is only one. (If there are multiple commits, you can use 'git squash' to compress multiple commits into one.)

kinoxyz1 avatar Sep 19 '22 03:09 kinoxyz1

CR @PaddyMelody @yanghuaiGit @ll076110 @chaozwn

FlechazoW avatar Sep 20 '22 04:09 FlechazoW

In my opinion, this code does not need to be modified. This code works fine in my environment,The mysql DateTime type should correspond to the java.sql.Timestamp. What version of mysql do you have?

Paddy0523 avatar Sep 21 '22 08:09 Paddy0523

In my opinion, this code does not need to be modified. This code works fine in my environment,The mysql DateTime type should correspond to the java.sql.Timestamp. What version of mysql do you have?

My mysql version is 5.7.39-0ubuntu0.18.04.2-log, in YarnSession mode, this type conversion problem occurs.

kinoxyz1 avatar Oct 10 '22 16:10 kinoxyz1