Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Shared MySQL CDC source doesn't handle timezone correctly #16496

Closed
xxchan opened this issue Apr 25, 2024 · 1 comment · Fixed by #16732
Closed

Shared MySQL CDC source doesn't handle timezone correctly #16496

xxchan opened this issue Apr 25, 2024 · 1 comment · Fixed by #16732
Assignees
@yuhao-su
Milestone
release-1.9

Comments

@xxchan
Copy link
Member

xxchan commented Apr 25, 2024 

          Hmmm, this test succeeds in CI, but failed for me locally. `tt1` is ok, but `tt1_shared` has a different result. Any ideas?

failed to run `e2e_test/source_inline/cdc/mysql/mysql_create_drop.slt`

Caused by:
    query result mismatch:
    [SQL] select * from tt1_shared;
    [Diff] (-expected|+actual)
    -   1 2023-10-23 10:00:00+00:00
    +   1 2023-10-23 02:00:00+00:00
    at e2e_test/source_inline/cdc/mysql/mysql_create_drop.slt:177

Originally posted by @xxchan in #16449 (comment)
@github-actions github-actions bot added this to the release-1.9 milestone Apr 25, 2024
@xxchan xxchan mentioned this issue Apr 25, 2024
Merged
9 tasks
@xxchan
Copy link
Member Author

xxchan commented Apr 25, 2024 •
edited

Need someone else to reproduce this. 🙏

To test this locally

  1. Add your MySQL to risedev user profile
  2. risedev d <profile-with-mysql>
  3. risedev slt e2e_test/source_inline/cdc/mysql/mysql_create_drop.slt

@yuhao-su yuhao-su mentioned this issue May 13, 2024
Merged
9 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@yuhao-su yuhao-su

Labels
None yet
Projects
None yet
Milestone
release-1.9
Development

Successfully merging a pull request may close this issue.

fix: mysql cdc read timezone and correct mysql test image risingwavelabs/risingwave
2 participants
@yuhao-su @xxchan