You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "cunlianer (via GitHub)" <gi...@apache.org> on 2024/05/13 06:30:39 UTC
[I] SQL statement deep paging problem [shardingsphere]
cunlianer opened a new issue, #31221:
URL: https://github.com/apache/shardingsphere/issues/31221
In SQL statements with deep pagination, such as table partitioning, there are the following SQL statements:
select fields from tableName t1 inner join (select id from tableName limit 2000000,10) t2 on t2. id=t1. id
When the number of records in a single table is less than 2000000 but the total number is more than 2000000, deep pagination retrieves an empty record. I suspect that pagination can only obtain data on the number of records in a single table.
--
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] SQL statement deep paging problem [shardingsphere]
Posted by "cunlianer (via GitHub)" <gi...@apache.org>.
cunlianer commented on issue #31221:
URL: https://github.com/apache/shardingsphere/issues/31221#issuecomment-2106755980
--
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] SQL statement deep paging problem [shardingsphere]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #31221:
URL: https://github.com/apache/shardingsphere/issues/31221#issuecomment-2166673041
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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] SQL statement deep paging problem [shardingsphere]
Posted by "terrymanu (via GitHub)" <gi...@apache.org>.
terrymanu closed issue #31221: SQL statement deep paging problem
URL: https://github.com/apache/shardingsphere/issues/31221
--
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