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

Snapshotting does not work for hstore in Map mode

XMLWordPrintable

    • False
    • None
    • False

      Issue reproduction

      ```
      create table foo (id int primary key, hs public.hstore DEFAULT ''::public.hstore NOT NULL);
      insert into foo values (18, 'a=>1'::hstore);
      ```

      Start debezium with "hstore.handling.mode": "map"

      I can see a crash: Unexpected value for JDBC type 1111 and column config hstore(2147483647, 0) NOT NULL: class=java.util.HashMap

      This is related to the fact that, in snapshot mode, the hstore column arrives in convertHStore function as a Map. In stream mode, it's not the case.

      I did not see any issue in JSON mode.

      PR: https://github.com/debezium/debezium/pull/4490

              Unassigned Unassigned
              bertrand.paquet@gmail.com Bertrand Paquet (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: