mumutu66 commented on issue #20352: URL: https://github.com/apache/shardingsphere/issues/20352#issuecomment-1223448453
γit's an issue report with `TopAndRowNumberDecoratorMergedResult` when use sqlserver will hit this logic. first I use my own way to fixed (issue)[https://github.com/apache/shardingsphere/issues/17973] then the case is a simple hello world example : one logic table with two sharding table table_0 , table_1 I query a table with OFFSET 200 FETCH NEXT 200 the actualsql will be query every sharding table OFFSET 0 FETCH NEXT 400 , then come to the merge phase the origin logic in ` `TopAndRowNumberDecoratorMergedResult` return empty list even both QueryResult has a 400 result, cuz the `pagination.getActualRowCount() ` is 200 and the rowNumber is set to 201 during the `skipOffset()` Maybe there has two case the pagination ActualRowCount is 400 but something got error it return 200 or the rowNumber canbe 0.γγ currently I change the rowNumber = 0 and everything works well -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
