waywtdcc created FLINK-23379:
--------------------------------
Summary: interval left join null value result out of order
Key: FLINK-23379
URL: https://issues.apache.org/jira/browse/FLINK-23379
Project: Flink
Issue Type: Bug
Components: Table SQL / Runtime
Affects Versions: 1.12.2
Reporter: waywtdcc
* Scenes:
Person main table left interval join associated message information table,
The first record that is not associated with the message information table will
be later than the later record that is associated with the message information
table.
When there are normal output and null value output with the same primary key,
it will be out of order, and the null value output is later than the normal
value output, resulting in incorrect results
enter:
\{"id": 1, "name":"chencc2", "message": "good boy2", "ts":"2021-03-26 18:56:43"}
\{"id": 1, "name":"chencc2", "age": "28", "ts":"2021-03-26 19:02:47"}
\{"id": 1, "name":"chencc2", "message": "good boy3", "ts":"2021-03-26 19:06:43"}
\{"id": 1, "name":"chencc2", "age": "27", "ts":"2021-03-26 19:06:47"}
Output:
+I(chencc2,27,2021-03-26T19:06:47,good boy3,2021-03-26 19:06:43.000)
+I(chencc2,28,2021-03-26T19:02:47,null,null)
The time of the second record here is 19:02 earlier than the first record, but
the output of the result is late, causing data update errors
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
