Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-6222

TIME with precision greater than 3 leads to data loss

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 2.1.3.Final, 2.2.0.Alpha3
    • sqlserver-connector
    • None
    • False
    • None
    • False

      When a TIME column specifies a precision greater than 3, there will be data loss for any micro or nanoseconds because SqlServerChangeTablePointer#getColumnData relies on using ResultSet#getTime which only supports millisecond precision.

      Could we return a Timestamp or a LocalTime value instead that will carry a much more precise precision value so that the micro or nano second precision isn't lost?

              Unassigned Unassigned
              ccranfor@redhat.com Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: