[Bug]: Pagination count is not accurate
Author: liviuconcioiuCreated Aug 24, 2026Updated Sep 5, 2026
LabelsBug
Describe the bug
Pagination count is not accurate when using WHERE and also when there are hundreds of thousands of rows.
It adds 1 more page than it should.
How to Reproduce
CREATE TABLE `test` (
`id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=FIXED;
INSERT INTO `test` (`id`) SELECT `seq` FROM seq_1_to_982289;
SELECT * FROM `test` WHERE `id` >= 82290;- Go to last page
Expected behavior
Exact pagination count.
Screenshots
https://github.com/user-attachments/assets/c2dc1eab-7858-4564-b7e3-4326815f5dd0
Database Server
MariaDB
phpMyAdmin version
5.2.4-dev, 6.0.0-dev
Source: phpmyadmin/phpmyadmin