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

getting error 'Illegal parameter data types row and bigint for operation '+' ' when using ITERATE in a FOR..DO

Details

    Description

      Hi,
      customer is getting the following error when he comments the DECLARE CONTINUE, while it works if the DECLARE is uncommented:

      'Illegal parameter data types row and bigint for operation '+' '

      The following procedure was created by the customer to test the ITERATE clause but it's identical to the one used in prod

      delimiter //
      		 
      CREATE DEFINER='root'@'%' PROCEDURE 'forIterateBug'()
      		 
          MODIFIES SQL DATA
      		 
      BEGIN
      		 
      	DECLARE 'loopDone' TINYINT DEFAULT FALSE;
      		 
       
      		 
      	FOR '_unused' IN (SELECT "") DO
      		 
      		'innerLoop': LOOP
      		 
      			IF 'loopDone' THEN
      		 
      				LEAVE 'innerLoop';
      		 
      			END IF;
      		 
       
      		 
      			SET 'loopDone' = TRUE;
      		 
      			BEGIN
      		 
      				#DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
      		 
      				ITERATE 'innerLoop';
      		 
      			END;
      		 
      		END LOOP;
      		 
      	END FOR;
      		 
      END 
      //

      Attachments

        Issue Links

          is caused by

          Technical task - A technical task. MDEV-10580 sql_mode=ORACLE: FOR loop statement

          • Major - Major loss of function.
          • Closed

          Technical task - A technical task. MDEV-10581 sql_mode=ORACLE: Explicit cursor FOR LOOP

          • Major - Major loss of function.
          • Closed

          Technical task - A technical task. MDEV-12098 sql_mode=ORACLE: Implicit cursor FOR loop

          • Major - Major loss of function.
          • Closed

          Technical task - A technical task. MDEV-12314 sql_mode=ORACLE: Implicit cursor FOR LOOP for cursors with parameters

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-14415 Add Oracle-style FOR loop to sql_mode=DEFAULT

          • Major - Major loss of function.
          • Closed

          Activity

            People

              bar Alexander Barkov
              Bongini Luigi (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.