You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Reason was execute block leaking variable numbers for input parameters, and hidden variables code not assuming this. Code was changed as the stored procedure, not incrementing "locals" variable.
Submitted by: @dyemanov
Is related to QA391
Test case:
execute block (i varchar(10) = :a) returns (o varchar(10))
as
begin
o = coalesce(cast(o as date), current_date);
o = i;
suspend;
end
If called with an input parameter e.g. 'asd', it throws a conversion error instead of returning 'asd'.
The problem is caused by a hidden variable overwriting the output parameter node, as they mistakenly share the same BLR variable identifier.
Commits: 28aa57f
The text was updated successfully, but these errors were encountered: