Details
-
Bug
-
Resolution: Done
-
Major
-
0.3.4
-
None
Description
It was noticed that all declared enum values which go after one with included parentheses are not capturing (inclusively) by debezium.
Create table script :
create table TestEnum (
Id int primary key,
EnumColumn ENUM('one', 'one two', 'one two three', 'one () five', 'six')
);
Working insert :
insert into TestEnum values (1, 'one two three');
DBZ message :
{
"before": null,
"after": {
"Id": 1,
"EnumColumn": "one two three"
},
"source": {
"name": "anton_staging",
"server_id": 223344,
"ts_sec": 1479129738,
"gtid": null,
"file": "mysql-bin.000010",
"pos": 20908,
"row": 0,
"snapshot": null
},
"op": "c",
"ts_ms": 1479129737253
}
Not-working insert :
insert into TestEnum values (2, 'six');
DBZ message :
{
"before": null,
"after": {
"Id": 2,
"EnumColumn": null
},
"source": {
"name": "anton_staging",
"server_id": 223344,
"ts_sec": 1479129803,
"gtid": null,
"file": "mysql-bin.000010",
"pos": 21126,
"row": 0,
"snapshot": null
},
"op": "c",
"ts_ms": 1479129801478
}
Notice, that second message has "EnumColumn": null
