[FLINK-27018] timestamp missing end zero when outputing to kafka

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.13.5
• Component/s: Connectors / Kafka
• Assignee: Yao Zhang
• Reporter: jeff-zou
• Created: 02/Apr/22 11:29
• Updated: 26/Apr/23 07:27

Description

the bug is described as follows:

 

data in source:
 2022-04-02 03:34:21.260
but after sink by sql, the data in kafka:
 2022-04-02 03:34:21.26

 

data miss end zero in kafka.

 

sql:

create kafka_table(stime stimestamp) with ('connector'='kafka','format' = 'json');
insert into kafka_table select stime from (values(timestamp '2022-04-02 03:34:21.260'))

the value in kafka is : {"stime":"2022-04-02 03:34:21.26"}, missed end zero.