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

Incorrect type retrieved by stream producer for column TIMESTAMP (0) WITH TIME ZONE

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 0.7.3
    • None
    • postgresql-connector
    • None

    Description

      We obtain the correct type during snapshotting, but during stream reading a column of type TIMESTAMP (0) WITH TIME ZONE is handled as timestamp instead of timestamptz (with both, wal2json and decoderbufs).

      To reproduce, see "time_table" in postgres_create_tables.ddl and its usage in RecordsStreamProducerIT.shouldReceiveChangesForInsertsWithDifferentDataTypes(). A superfluous schema refresh is triggered there.

      Also note that the column "tsp" which is triggering this refresh isn't populated with test data and it's also not part of the assertion. This should be adjusted.

      Attachments

        Activity

          People

            jpechane Jiri Pechanec
            gunnar.morling Gunnar Morling
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: