shaohui hong created FLINK-36894:
------------------------------------
Summary: rowId comparision is incorrect in oracle connector
Key: FLINK-36894
URL: https://issues.apache.org/jira/browse/FLINK-36894
Project: Flink
Issue Type: Bug
Components: Flink CDC
Affects Versions: 3.0.0
Reporter: shaohui hong
the method which compares rowids is OracleChunkSplitter->isChunkEndGeMax.
isChunkEndGeMax compares every byte between two rowids to determine the order
of rowids. This is incorrect, because this is not the way that oracle does.
Oracle compares the order of two rowids by comparing dataObj, afn, bdba, slot
stored in rowid. A more comprehensive discussion is in the following link:
[sql - How does order by row id work in Oracle? - Stack
Overflow|https://stackoverflow.com/questions/34742707/how-does-order-by-row-id-work-in-oracle]
I can fix this bug.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)