Uploaded image for project: 'StreamSets Data Collector'
  1. StreamSets Data Collector
  2. SDC-15021

Ignore SELECT FOR UPDATE op in Oracle CDC when parsing is enabled

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Resolved
    • Priority: P3 (Limited Impact)
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.19.0
    • Component/s: None
    • Labels:
    • Doc Impact:
      Yes
    • Doc Impact Details:
      SELECT FOR UPDATE operation will be ignored when "Parse SQL" is enabled. When "Parse SQL" is disabled, records with the raw SQL statement will be created, even for SELECT FOR UPDATE ops.
    • Testing Status:
      STF Testing Required
    • Team:
      Data Plane
    • Stage:
      Oracle CDC Client origin

      Description

      The rationale for ignoring these ops when "Parse SQL" is checked is that the current SQL parsers for Oracle CDC do not actually support SELECT FOR UPDATE statements (they are throwing errors: SDC-14987). And we do not want at this moment for the parsers to support them, since they are not needed for data replication with Oracle CDC.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              toni Toni Martinez
              Reporter:
              hugo Hugo Prol
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: