dinky icon indicating copy to clipboard operation
dinky copied to clipboard

[Bug] [dlink-client] Date type conversion error

Open wanshicheng opened this issue 3 years ago • 0 comments

Search before asking

  • [X] I had searched in the issues and found no similar issues.

What happened

If you set a date type in a table and transfer the data from this table to another table, you will find that all data of the date type are 1970-01-01.

What you expected to happen

Return the correct data.

How to reproduce

create a table with date type. Then transfer the data from this table to another table.

Anything else

Because FlinkCDC relies on DeBezium, we can refer to the following sources:

  1. https://debezium.io/documentation/reference/1.3/connectors/mysql.html#how-the-mysql-connector-maps-data-types_debezium
  2. https://debezium.io/documentation/reference/1.3/connectors/oracle.html#oracle-data-types

Note that although both rely on debezium, date type has a different meaning.

Version

0.6.6

Are you willing to submit PR?

  • [X] Yes I am willing to submit a PR!

Code of Conduct

wanshicheng avatar Aug 03 '22 15:08 wanshicheng