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

Error when define default value avro in decimal columns

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • 1.7.1.Final
    • 1.6.0.Final, 1.7.0.Final
    • postgresql-connector
    • None
    • False
    • False

    Description

      when decimal.handling.mode is defined to string an error is throwed.

      org.apache.kafka.connect.errors.DataException: Invalid Java object for schema type STRING: class java.math.BigDecimal for field: "null"
      

      This error is throwed when PostgreSQL database has decimal columns with default  values.

       

      CREATE TABLE public.dados_contexto_lote_recurso (
          id text NOT NULL,
          qtd_guias_glosadas bigint NOT NULL,
          todo_contexto_trabalhado boolean NOT NULL,
          contexto_lote_recurso text NOT NULL,
          total_glosa_guias numeric DEFAULT 0
      );

       

      In debezium 1.5.X- works.

      Attachments

        Activity

          People

            Unassigned Unassigned
            henriquelsmota Henrique Luiz da Silva Mota (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: