Bug #57602 Bad text desription of fetched rows on result tab
Submitted: 20 Oct 2010 13:28 Modified: 23 Dec 2013 15:50
Reporter: Libor Pospichal Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.27, 5.2.29 OS:Windows
Assigned to: CPU Architecture:Any
Tags: fetched rows, result pane

[20 Oct 2010 13:28] Libor Pospichal
Description:
Workbench reads "Fetched x records, more available" even if there are no more records available.

How to repeat:
DROP TABLE IF EXISTS `tab`;

CREATE TABLE `tab` (
  `i` int(11) DEFAULT NULL
);

DROP PROCEDURE IF EXISTS `fill`;

DELIMITER $$
CREATE PROCEDURE `fill` (IN n INT)
BEGIN
    DECLARE i INT DEFAULT 1;
    START TRANSACTION;
    WHILE i <= n DO
        INSERT INTO `tab`(`i`) VALUES(i);
        SET i = i + 1;
    END WHILE;
    COMMIT;
END$$
DELIMITER ;

CALL `fill`(1000);

SELECT * FROM `tab` LIMIT 999;
SELECT * FROM `tab` LIMIT 1000; -- should read "Fetched 1000 records" without "more available"
SELECT * FROM `tab` LIMIT 1001;

DROP TABLE IF EXISTS `tab`;
DROP PROCEDURE IF EXISTS `fill`;
[20 Oct 2010 14:04] MySQL Verification Team
Please try new version 5.2.29 and comment the results. Thanks in advance.
[21 Oct 2010 7:24] Libor Pospichal
Same behavior in 5.2.29.
[21 Oct 2010 9:25] Valeriy Kravchuk
I was able to repeat the problem with LIMIT N, where N is the exact number of rows SELECT returns.
[23 Dec 2013 15:50] Alfredo Kojima
The UI was changed and this bug is no longer applicable.