Uploaded image for project: 'MariaDB Server'
  1. MDEV-4602

Error 1329 is reported even if it is handled

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: 5.5.31
    • Fix Version/s: 5.5.34
    • Component/s: None
    • Labels:

      Description

      Create a trivial procedure with a cursor and a loop for that cursor. Handle the NOT FOUND event, or the 1329 error, or both.

      DELIMITER ||
      CREATE TABLE `test`.`tab1` (c INT);
      CREATE PROCEDURE `test`.demo()
      BEGIN
      	DECLARE `eof` BOOL;
      	DECLARE `v` INT;	
      	DECLARE `crs` CURSOR FOR
      		SELECT `c`
      			FROM `test`.`tab1`;
      	-- this should handle error...
      	DECLARE CONTINUE HANDLER
      		FOR NOT FOUND, 1329
      		SET eof = TRUE;
      	OPEN `crs`;
      	`lp`: LOOP
      		FETCH `crs` INTO `v`;
      		IF `eof` IS TRUE THEN
      			LEAVE `lp`;
      		END IF;
      	END LOOP;
      	CLOSE `crs`;
      END;
      ||
      DELIMITER ;
      

      Then run it:

      MariaDB [(none)]> CALL test.demo();
      Query OK, 0 rows affected, 1 warning (0.00 sec)
      
      MariaDB [(none)]> SHOW WARNINGS;
      +-------+------+-----------------------------------------------------+
      | Level | Code | Message                                             |
      +-------+------+-----------------------------------------------------+
      | Error | 1329 | No data - zero rows fetched, selected, or processed |
      +-------+------+-----------------------------------------------------+
      1 row in set (0.00 sec)
      

      As far as I understand this warning should not appear, because that warning is handled.
      This also happens with MySQL 5.5.30, but not with 5.6.

        Attachments

          Issue links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                f_razzoli Federico Razzoli
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: