ODC version
ODC 4.2.3
OB version
What happened?
No error will be reported when checking the sql statement of the delimiter alone, but an error will be reported when checking together with pl.
What did you expect to happen?
Checking it together with pl will not report an error.
How can we reproduce it (as minimally and precisely as possible)?
delimiter //;
create function fun_loop (p1 int) returns int(11) begin
declare v1 int;
set v1 = 0;
loop1:LOOP
IF v1 > 10 THEN
LEAVE loop1;
END IF;
set v1 = v1 + p1;
END LOOP;
return v1;
end;
Anything else we need to know?
No response
Cloud
No response
ODC version
ODC 4.2.3
OB version
What happened?
No error will be reported when checking the sql statement of the delimiter alone, but an error will be reported when checking together with pl.
What did you expect to happen?
Checking it together with pl will not report an error.
How can we reproduce it (as minimally and precisely as possible)?
delimiter //;
create function
fun_loop(p1 int) returns int(11) begindeclare v1 int;
set v1 = 0;
loop1:LOOP
IF v1 > 10 THEN
LEAVE loop1;
END IF;
set v1 = v1 + p1;
END LOOP;
return v1;
end;
Anything else we need to know?
No response
Cloud
No response