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)

Reply via email to