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

Oracle DDL ALTER TABLE ADD CONSTRAINT fails to be parsed

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 3.0.5.Final
    • 3.0.4.Final
    • oracle-connector
    • None

      Given this SQL:

      ALTER TABLE MY_BASEPRICE_WAGEINDEX ADD(
    CONSTRAINT MY_BASEPREICE_WAGEINDEX_PK PRIMARY KEY (MY BASEPRICE_WAGEINDEX_GUID) USING INDEX MY_BASEPRICE_WAGEINDEX_PK ENABLE VALIDATE,
    CONSTRAINT MY_BASEPRICE_WAGEINDEX_UNQ UNIQUE (COMPANY_GUID, PLAN_GUID, START_DATE) USING INDEX MY_BASEPRICE_WAGEINDEX_UNQ ENABLE VALIDATE);

      Results in the error:

      no viable alternative at input 'ADD (CONSTRAINT MY_BASEPRICE_WAGEINDEX_PK PRIARY KEY ...

              ccranfor@redhat.com Chris Cranford
              ccranfor@redhat.com Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: