You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/10/10 06:32:36 UTC
[GitHub] [shardingsphere] mumutu66 opened a new issue, #20352: merge will return empty list
mumutu66 opened a new issue, #20352:
URL: https://github.com/apache/shardingsphere/issues/20352
https://github.com/apache/shardingsphere/blob/f347765d0dfa05fe4d3a31c69813b34f66fe275a/shardingsphere-features/shardingsphere-sharding/shardingsphere-sharding-core/src/main/java/org/apache/shardingsphere/sharding/merge/dql/pagination/TopAndRowNumberDecoratorMergedResult.java#L62
`pagination` is offset and limit and canbe same value 。so why skipOffset will change the rownumber to the offset value while compare to the actual row number which return false every time offset equals limit。
--
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] merge will return empty list [shardingsphere]
Posted by "2671884528 (via GitHub)" <gi...@apache.org>.
2671884528 commented on issue #20352:
URL: https://github.com/apache/shardingsphere/issues/20352#issuecomment-1953726367
I am using version 5.2.1 to connect to SQL server. This problem also occurs when using paging. How to solve it?
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] closed issue #20352: merge will return empty list
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #20352: merge will return empty list
URL: https://github.com/apache/shardingsphere/issues/20352
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #20352: merge will return empty list
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #20352:
URL: https://github.com/apache/shardingsphere/issues/20352#issuecomment-1221986075
Can you provide a demo to describe your 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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #20352: merge will return empty list
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #20352:
URL: https://github.com/apache/shardingsphere/issues/20352#issuecomment-1272348809
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] mumutu66 commented on issue #20352: merge will return empty list
Posted by GitBox <gi...@apache.org>.
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] merge will return empty list [shardingsphere]
Posted by "2671884528 (via GitHub)" <gi...@apache.org>.
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org