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

Snapshot SQL Override Spaces

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Minor Minor
    • 3.4.0.Beta1
    • 3.2.0.CR1, 3.3.1.Final, 3.4.0.Alpha2
    • db2-connector
    • None
    • Moderate

      In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type.

      Bug report

      For bug reports, provide this information, please:

      What Debezium connector do you use and what version?

      3.2 Release

      What is the connector configuration?

       

      What is the captured database version and mode of deployment?

      DB2 Z, DB2 LUW

      What behavior do you expect?

      The list of tables that are snapshot-sql overridden should allow there to be spaces after the commas.  The spaces should be trimmed off.

      What behavior do you see?

      Debezium defines this as a String, not a list.  It separates it into a list using a comma as the delimiter.  Therefore, if there is a space after the comma, that comma is used as the table name and it's not found in the related configuration line, and the replacement SQL is not used.

      Do you see the same behaviour using the latest released Debezium version?

      (Ideally, also verify with latest Alpha/Beta/CR version)

      <Your answer>

      Do you have the connector logs, ideally from start till finish?

      No

      How to reproduce the issue using our tutorial deployment?

      Create a connector, and specify a list of tables for snapshot sql override, and have a space after the commas.

      Feature request or enhancement

      For feature requests or enhancements, provide this information, please:

      Which use case/requirement will be addressed by the proposed feature?

      <Your answer>

      Implementation ideas (optional)

      I have a fix.  It just trims the table name after it is separated. 

              Unassigned Unassigned
              mhejnas_converge Matt Hejnas
              Matt Hejnas
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: