Skip to content

Added workaround to fix the debezium timestamp for DATETIME4, DATETIM…#1057

Merged
subkanthi merged 4 commits into2.7.0from
1056-datetime-columns-with-non-utc-tz-on-source-and-target-are-not-replicated-properly-for-datetime4-6
May 18, 2025
Merged

Added workaround to fix the debezium timestamp for DATETIME4, DATETIM…#1057
subkanthi merged 4 commits into2.7.0from
1056-datetime-columns-with-non-utc-tz-on-source-and-target-are-not-replicated-properly-for-datetime4-6

Conversation

@subkanthi
Copy link
Copy Markdown
Collaborator

@subkanthi subkanthi commented May 12, 2025

closes: #1056

@subkanthi
Copy link
Copy Markdown
Collaborator Author

subkanthi commented May 13, 2025 •
edited
Loading

MySQL:

create table temporal_types_DATETIME4(Typevarchar(50) not null,Minimum_Value datetime(4) not null);
insert into temporal_types_DATETIME4 values('DATETIME(4)', '2022-09-29 01:48:25.1');

d77814370786 :) select * from temporal_types_DATETIME5;

SELECT *
FROM temporal_types_DATETIME5

Query id: 235105e3-17c1-44a4-9d7b-ca80a8c1d5db

┌─my_row_id─┬─Type────────┬─────────────Minimum_Value─┬────────────_version─┬─is_deleted─┐
│         1 │ DATETIME(5) │ 2022-09-29 01:48:25.10000 │ 1922366984196980800 │          0 │
└───────────┴─────────────┴───────────────────────────┴─────────────────────┴────────────┘

1 row in set. Elapsed: 0.001 sec.

@subkanthi subkanthi merged commit f5be57d into 2.7.0 May 18, 2025
8 of 9 checks passed
@subkanthi subkanthi deleted the 1056-datetime-columns-with-non-utc-tz-on-source-and-target-are-not-replicated-properly-for-datetime4-6 branch May 18, 2025 19:19
@subkanthi subkanthi mentioned this pull request Feb 12, 2026
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

No reviews

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

1 participant

@subkanthi