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.

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

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
Milestone

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)

@xxchan
Copy link
Member Author

xxchan commented Apr 25, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants