dtle
dtle copied to clipboard
kafka incr job - wrong value for text type
Description
Steps to reproduce the issue
- create kafka job
- execute sql
create table tinytext_columns(id int(11) not null primary key, c_tinytext tinytext)ENGINE=InnoDB DEFAULT CHARSET=utf8;
create table text_columns(id int(11) not null primary key,c_text text)ENGINE=InnoDB DEFAULT CHARSET=utf8;
create table mediumtext_columns(id int(11) not null primary key,c_mediumtext mediumtext)ENGINE=InnoDB DEFAULT
CHARSET=utf8;
create table longtext_columns(id int(11) not null primary key,c_longtext longtext)ENGINE=InnoDB DEFAULT CHARSET=utf8;
- execute sql
insert into tinytext_columns values (0,NULL);
insert into tinytext_columns values (1,'');
insert into tinytext_columns values (2,' ');
insert into tinytext_columns values (3,'a a a ');
...
insert into text_columns values (0,NULL);
insert into text_columns values (1,'');
insert into text_columns values (2,' ');
insert into text_columns values (3,'a a a ');
...
insert into mediumtext_columns values (0,NULL);
insert into mediumtext_columns values (1,'');
insert into mediumtext_columns values (2,' ');
insert into mediumtext_columns values (3,'a a a ');
...
insert into longtext_columns values (0,NULL);
insert into longtext_columns values (1,'');
insert into longtext_columns values (2,' ');
insert into longtext_columns values (3,'a a a ');
...
- compare kafka message with dbz
- the value is wrong
Describe the results you received
Describe the results you expected
Output of ./dtle version
:**
9.9.9.9-master-f18f78c