SQL statement deep paging problem

[cunlianer]

shardingsphere v5.5
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.

[cunlianer]

[github-actions[bot]]

There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.