Pagination doesn't work as expected for identical table names in different databases

[liviuconcioiu]

Describe the bug

Pagination doesn't work as expected for identical table names in different databases. Count is greater than rows in table.
I have attached the SQL files for both databases.

To Reproduce

Steps to reproduce the behavior:

1. Create two databases db_test_1 and db_test_2 (database names don't matter)
2. Create a table name db_test_1.tbl_test and insert 3 rows
3. Copy the table with structure and data in the second database
4. Insert 100-200 rows in db_test_2.tbl_test
5. Open db_test_1.tbl_test in a browser tab
6. Open db_test_2.tbl_test in another browser tab
7. Navigate to a page greater than 1 in db_test_2.tbl_test
8. Click on table name at the top in db_test_1.tbl_test
9. See error - Showing rows 75 - 74 (75 total, Query took 0.0004 seconds.) even though the first table has 3 rows, and pagination is messed.

Expected behavior

An accurate count should be done when clicking on table name at the top.

Screenshots

First table

Second table

Server configuration

• Operating system: Windows
• Web server: nginx/1.21.1
• Database version: 5.7.35 - MySQL Community Server (GPL)
• PHP version: 8.0.9
• phpMyAdmin version: RELEASE_5_1_1-1242-g3c2d727139

Client configuration

• Browser: Firefox
• Operating system: Windows

Additional context

tables.zip