Backport to branch(3.11) : Fix scan with limit behavior in DynamoDB adapter #4929

Job	Run time
Gradle check	3m 47s
Lint dockerfiles	29s
Cassandra 3.0 integration test	7m 23s
Cassandra 3.11 integration test	7m 28s
Cosmos DB integration test	25m 6s
DynamoDB integration test	11m 30s
MariaDB 10 integration test	3m 47s
MariaDB 11.4 integration test	4m 4s
MySQL 5.7 integration test	4m 22s
MySQL 8.0 integration test	5m 52s
MySQL 8.1 integration test	5m 49s
Oracle 19 integration test	9m 24s
Oracle 21 integration test	9m 35s
Oracle 23 integration test	10m 34s
PostgreSQL 12 integration test	2m 32s
PostgreSQL 13 integration test	3m 2s
PostgreSQL 14 integration test	2m 44s
PostgreSQL 15 integration test	2m 55s
SQLite 3 integration test	5m 7s
SQL Server 2017 integration test	5m 19s
SQL Server 2019 integration test	5m 8s
SQL Server 2022 integration test	5m 52s
Multi-storage integration test	3m 9s
ScalarDB Server integration test	6m 28s
	2h 31m 26s

Provide feedback