you can use LIMIT and OFFSET to paginate the data in TiDB. However, TiDB’s underlying storage engine is TiKV.
Reading TiKV source code reveals that TiKV does not seem to find query interfaces for OFFSET and LIMIT. The only relevant ones are:
- rawKV.Scan
- txn.Scan
So, my question is: How does TiDB use TiKV to implement OFFSET and LIMIT?