[MDEV-32275] getting error 'Illegal parameter data types row and bigint for operation '+' ' when using ITERATE in a FOR..DO - Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.6.12, 10.6.14
Fix Version/s: 11.1.1, 10.4.32, 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3, 11.2.2, 11.3.1
Component/s: Server
Labels:
- triage
Environment:
Ubuntu 20.04.6 LTS

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

//

is caused by

MDEV-10580 sql_mode=ORACLE: FOR loop statement

MDEV-10581 sql_mode=ORACLE: Explicit cursor FOR LOOP

MDEV-12098 sql_mode=ORACLE: Implicit cursor FOR loop

MDEV-12314 sql_mode=ORACLE: Implicit cursor FOR LOOP for cursors with parameters

MDEV-14415 Add Oracle-style FOR loop to sql_mode=DEFAULT

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