-
Bug
-
Resolution: Done
-
Major
-
None
Hello~, I have encountered a problem with the default value of the field, The source table is not consistent with the target table , for example:
This is a piece of json data from id=1
{
"schema": {
"type": "struct",
"fields": [
{
"type": "struct",
"fields": [
,
{ "type": "string", "optional": true, "default": "zhangsan", "field": "name" },
{ "type": "int32", "optional": true, "field": "age" },
{ "type": "string", "optional": true, "field": "timestamp" },
{ "type": "string", "optional": true, "default": "1", "field": "char" },
{ "type": "int32", "optional": true, "default": 100, "field": "int" }],
"optional": true,
"name": "Mysql_140.wangzc_test.a_wzc_default_value.Value",
"field": "before"
},
{
"type": "struct",
"fields": [
,
{ "type": "string", "optional": true, "default": "zhangsan", "field": "name" },
{ "type": "int32", "optional": true, "field": "age" },
{ "type": "string", "optional": true, "field": "timestamp" },
{ "type": "string", "optional": true, "default": "1", "field": "char" },
{ "type": "int32", "optional": true, "default": 100, "field": "int" }],
"optional": true,
"name": "Mysql_140.wangzc_test.a_wzc_default_value.Value",
"field": "after"
},
{
"type": "struct",
"fields": [
,
{ "type": "string", "optional": false, "field": "connector" },
{ "type": "string", "optional": false, "field": "name" },
{ "type": "int64", "optional": false, "field": "ts_ms" },
{
"type": "string",
"optional": true,
"name": "io.debezium.data.Enum",
"version": 1,
"parameters":
,
"default": "false",
"field": "snapshot"
},
,
{ "type": "string", "optional": true, "field": "sequence" },
{ "type": "string", "optional": true, "field": "table" },
{ "type": "int64", "optional": false, "field": "server_id" },
{ "type": "string", "optional": true, "field": "gtid" },
{ "type": "string", "optional": false, "field": "file" },
{ "type": "int64", "optional": false, "field": "pos" },
{ "type": "int32", "optional": false, "field": "row" },
{ "type": "int64", "optional": true, "field": "thread" },
{ "type": "string", "optional": true, "field": "query" }],
"optional": false,
"name": "io.debezium.connector.mysql.Source",
"field": "source"
},
,
{ "type": "int64", "optional": true, "field": "ts_ms" },
{
"type": "struct",
"fields": [
,
{ "type": "int64", "optional": false, "field": "total_order" },
{ "type": "int64", "optional": false, "field": "data_collection_order" }],
"optional": true,
"name": "event.block",
"version": 1,
"field": "transaction"
}
],
"optional": false,
"name": "Mysql_140.wangzc_test.a_wzc_default_value.Envelope",
"version": 1
},
"payload": {
"before": null,
"after":
,
"source":
,
"op": "r",
"ts_ms": 1701065788073,
"transaction": null
}
}
- links to
-
RHEA-2024:129636 Red Hat build of Debezium 2.5.4 release