Details
-
Bug
-
Resolution: Obsolete
-
Major
-
None
-
1.7.1.Final
-
None
-
False
-
False
-
These are two pieces of data from the snapshot:
The official document records that long, longraw and raw are not supported, but the snapshot data has values. The document says that CLOB, blob and nclog are within the range of supported data types, but they have no values
This is the second step to insert a row of data into the table:
There are two times. There is no data value I want when adding, but all of them are reflected in the modification
This is to modify a record in a row of data topic:
Except that the field record and primary key I modified are not empty, the rest are empty, but there are no empty fields in my table
This is the data in the table I monitor:
ddl:
CREATE TABLE "INMON"."TZ_TYPE"
( "ID" NUMBER,
"LONGTYPE" LONG,
"RAWTYPE" RAW(255),
"BLOBTYPE" BLOB,
"CLOBTYPE" CLOB,
"NCLOBTYPE" NCLOB,
PRIMARY KEY ("ID"))These are two pieces of data from the snapshot: The official document records that long, longraw and raw are not supported, but the snapshot data has values. The document says that CLOB, blob and nclog are within the range of supported data types, but they have no values This is the second step to insert a row of data into the table: There are two times. There is no data value I want when adding, but all of them are reflected in the modification This is to modify a record in a row of data topic: Except that the field record and primary key I modified are not empty, the rest are empty, but there are no empty fields in my table This is the data in the table I monitor: ddl: CREATE TABLE "INMON"."TZ_TYPE" ( "ID" NUMBER, "LONGTYPE" LONG, "RAWTYPE" RAW(255), "BLOBTYPE" BLOB, "CLOBTYPE" CLOB, "NCLOBTYPE" NCLOB, PRIMARY KEY ("ID"))
Description
Today, I made a test based on the supported and unsupported data types in the debezium official document. The test types include (long, raw, CLOB, blob, nclob). Then, after I created the connector (before creating the connector: I inserted two pieces of data into the table, and the fields are not empty), I checked the two snapshot data of Kafka topic record, and found that except for the primary key field (ID: number type) And long and raw fields are not empty, but all the other fields are empty. Then I insert a piece of data into the table and find that there are two events in topic, one is new and the other is modified. Except that the primary key and raw type fields are not empty, all the other fields are empty. The modified data records the field values when I insert, Finally, I modified a row of data in the table and found that except the primary key and the modified field are not empty, the rest are empty
