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]