Loading...

XML

Word

Printable

Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: 2.6.3.Final, 2.7.0.Beta2
Affects Version/s: 2.6.2.Final, 2.7.0.Beta1
Component/s: sqlserver-connector
Labels:
None

Blocked:
False
Blocked Reason:
None
Ready:
False
Git Pull Request:
https://github.com/debezium/debezium/pull/5603
Intelligence Requested:
Market:

SFDC Cases Counter:
SFDC Cases Open:
SFDC Cases Links:

The SqlServerDefaultValueConverter uses ResultSet#getTime rather than ResultSet#getTimestamp which unnecessarily truncates precision beyond TIME(3).
See https://debezium.zulipchat.com/#narrow/stream/348252-community-sqlserver/topic/value.20for.20column.20of.20TIME.20datatype.20not.20geting.20loaded.20properly/near/443328357

causes

DBZ-7949 JDBC sink time tests fail due to increased precision with SQL Server

Closed

is duplicated by

DBZ-6222 TIME with precision greater than 3 leads to data loss

Closed

links to

RHEA-2024:139598 Red Hat build of Debezium 2.5.4 release

Assignee:: Chris Cranford

Reporter:: Chris Cranford

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Created:: 2024/06/07 5:54 PM

Updated:: 2024/10/09 12:22 PM

Resolved:: 2024/06/10 12:31 PM