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

Standardize handling of tables without primary keys

    XMLWordPrintable

Details

    Description

      The tables without primary keys can contain fields with unique indices. All connectors should handle such cases in the same way

      • if DDL is available for the table then the primary key will be the first uniqe constraint defined either on column or as external contraint
      • if only JDBC metadata are available then getIndexInfo should be used to obtain information about indices - to identify if there is any unique

      If no index is available then the key of the message will be null.

      Attachments

        Issue Links

          duplicates

          Feature Request - Feature requests from customers and/or users DBZ-1225 Handle tables without PK consistently across all relational connectors

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed
          incorporates

          Sub-task - The sub-task of the issue DBZ-832 Add test for Oracle table without PK

          • Minor - To be worked after urgent, high, and medium priorities are resolved. This term is chosen when the severity of the issue is low, or the complexity or effort to correct it may be higher, relatively speaking. For low priority issues, known workarounds exist or are not needed due to the trivial effort needed to address the issue.
          • Closed

          Feature Request - Feature requests from customers and/or users DBZ-1211 Oracle connector error with tables using unique index keys: "key must not be null"

          • Blocker - To be worked above all other priorities. This term is chosen when the severity of the issue is very high, has no workaround, or the effort for the change is comparatively low. Issues that may be very publicly visible and could generate significant media attention may also drive a higher priority.
          • Closed

          Activity

            People

              jpechane Jiri Pechanec
              jpechane Jiri Pechanec
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: