-
Bug
-
Resolution: Duplicate
-
Major
-
None
-
0.9.0.Beta1
-
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" }
- duplicates
-
DBZ-1089 Connect schema name is wrong for SQL Server
- Closed