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

Oracle-Connector fails parsing a DDL statement (INCREMENT BY START)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Obsolete
    • Major
    • None
    • 1.8.0.Final
    • oracle-connector
    • None
    • False
    • None
    • False

    Description

      While beeing in streaming mode the Oracle-Connector fails to handle the following DDL statement which is valid Oracle-SQL and excutes fine in the Oracle db:

      connect_1           | io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE APP_SAP_REST_UPDATE_INTERFACE_TYPE
      connect_1           |    (      "ID" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE,
      connect_1           |   "TYPE" VARCHAR2(50),
      connect_1           |    PRIMARY KEY ("ID")
      connect_1           |   USING INDEX  ENABLE
      connect_1           |    );'
      

      Attachments

        Activity

          People

            anmohant Anisha Mohanty
            codebude Raffael Herrmann (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: