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

Standardize handling of tables without primary keys

    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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  jpechanec Jiri Pechanec
                  Reporter:
                  jpechanec Jiri Pechanec
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: