Procedures and EXECUTE BLOCK without RETURNS should not be allowed to use SUSPEND [CORE6239] #6483
Assignees
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandessummary: Compiler can make more rigorous check for presense of RETURNS(...) clause in SP header when SP body contains SUSPEND. => Procedures and EXECUTE BLOCK without RETURNS should not be allowed to use SUSPEND |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Beta 2 [ 10888 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Done successfully |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: @pavel-zotov
This SP will be compiled without errors or warnings:
set term ^ ;
create or alter procedure sp_missed_returns_in_its_header as
begin
-- we use SUSPEND clause but there is no
-- output parameters in this SP header:
suspend;
end
^
set term ;^
commit;
But attempt to select from this SP will, of course, fail:
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -84
-procedure SP_MISSED_RETURNS_IN_ITS_HEADER does not return any values
Commits: b2b5f9a
The text was updated successfully, but these errors were encountered: