dtle icon indicating copy to clipboard operation
dtle copied to clipboard

kafka incr job - wrong value for text type

Open asiroliu opened this issue 3 years ago • 0 comments

Description

Steps to reproduce the issue

  1. create kafka job
  2. 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;
  1. 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 ');
...
  1. compare kafka message with dbz
  2. the value is wrong

Describe the results you received

image

Describe the results you expected

Output of ./dtle version:**

9.9.9.9-master-f18f78c

asiroliu avatar Sep 03 '21 05:09 asiroliu