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

Schema is using dbname in namespace instead of the logical server name

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 0.9.0.Beta1
    • sqlserver-connector
    • None

      The inner schema created is using the dbname ("database_name" in the example below) in the namespace instead if the logical server.name ("logical_cluster_name" in the example).

      See:

      {
        "type": "record",
        "name": "Envelope",
        "namespace": "logical_cluster_name.dbo.table_name",
        "fields": [
          {
            "name": "before",
            "type": [
              "null",
              {
                "type": "record",
                "name": "Value",
                "namespace": "logical_cluster_name.database_name.dbo.table_name",
                "fields": [
                  {
                    "name": "intUserID",
                    "type": "int"
                  },
                  [...]
                ],
                "connect.name": "logical_cluster_name.database_name.dbo.table_name.Value"
              }
            ],
            "default": null
          },
          {
            "name": "after",
            "type": [
              "null",
              "logical_cluster_name.database_name.dbo.table_name.Value"
            ],
            "default": null
          },
          {
            "name": "source",
            "type": {
              "type": "record",
              "name": "Source",
              "namespace": "io.debezium.connector.sqlserver",
              "fields": [
                {
                  "name": "version",
                  "type": [
                    "null",
                    "string"
                  ],
                  "default": null
                },
                {
                  "name": "connector",
                  "type": [
                    "null",
                    "string"
                  ],
                  "default": null
                },
                {
                  "name": "name",
                  "type": "string"
                },
                {
                  "name": "ts_ms",
                  "type": [
                    "null",
                    "long"
                  ],
                  "default": null
                },
                {
                  "name": "change_lsn",
                  "type": [
                    "null",
                    "string"
                  ],
                  "default": null
                },
                {
                  "name": "commit_lsn",
                  "type": [
                    "null",
                    "string"
                  ],
                  "default": null
                },
                {
                  "name": "snapshot",
                  "type": [
                    "null",
                    "boolean"
                  ],
                  "default": null
                }
              ],
              "connect.name": "io.debezium.connector.sqlserver.Source"
            }
          },
          {
            "name": "op",
            "type": "string"
          },
          {
            "name": "ts_ms",
            "type": [
              "null",
              "long"
            ],
            "default": null
          }
        ],
        "connect.name": "logical_cluster_name.dbo.table_name.Envelope"
      }
      

      This is also true of the schema for the key:

      {
        "type": "record",
        "name": "Key",
        "namespace": "logical_cluster_name.database_name.dbo.table_name",
        "fields": [
          {
            "name": "intUserID",
            "type": "int"
          }
        ],
        "connect.name": "logical_cluster_name.database_name.dbo.table_name.Key"
      }
      

            Unassigned Unassigned
            edpenglund Victor Englund (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: