[YSQL] New test suite for testing local limit

[pao214]

Jira Link: DB-11716

Description

Motivation

We do not have a lot of tests for local limit and that makes changes to this feature challenging.

Issues Found

1. [YSQL] Investigate why the first request picks a local limit only when the read time is not set. #22158
2. [YSQL] Set local limit in a multi page read #22821

Plan

TODO:

• check local limit with one tablet
• single tablet multi-page scan
• check local limit with multi-tablet but read time picked on proxy
• check local limit with read time picked on another docdb node
• check local limit after insert
• local limit must work properly with all kinds of restarts
• local limit must work properly with RC
• explicit locking cases

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

• I confirm this issue does not contain any sensitive information.

[pao214]

Resolved by #23076