2671884528 commented on issue #20352: URL: https://github.com/apache/shardingsphere/issues/20352#issuecomment-1960630313
> γ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 one is the pagination ActualRowCount is 400 but something got error it return 200 and another is rowNumber should be 0.γγ currently I change the rowNumber = 0 and everything works well Brother, how to solve this problem? -- 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]
