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

wal2json CITEXT columns set to empty strings

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 0.9.0.Beta1
    • 0.8.3.Final, 0.9.0.Alpha2
    • postgresql-connector
    • None
    • Hide
      • Create a table with a CITEXT column and some data
      • Create a debezium-postgres connector to read that table with the wal2json plugin
      • Observe correct CITEXT columns at snapshot, when op=r
      • Create and update some rows in postgres
      • Observe incorrectly empty strings for CITEXT columns in streamed changes
      Show
      Create a table with a CITEXT column and some data Create a debezium-postgres connector to read that table with the wal2json plugin Observe correct CITEXT columns at snapshot, when op=r Create and update some rows in postgres Observe incorrectly empty strings for CITEXT columns in streamed changes

    Description

      PostgreSQL connector with wal2json correctly reads CITEXT columns when snapshotting. But when streaming changes, the column values in the resulting kafka message are always empty strings!

      Reproduced with versions 0.8.1.Final, 0.8.3.Final and 0.9.0.Alpha2.

      Attachments

        Activity

          People

            Unassigned Unassigned
            moilanen.tapani@gmail.com Tapani Moilanen (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: