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
Create function/sp which references to non-existent exception: error message is "Error while parsing function's BLR" instead of "exception not defined" [CORE4371]
#4693
The following script will show error message "Error while parsing function's BLR" instead of normal explanation that exception does not exist, i.e. a specific error message is lost while raising a more generic one.
set term ^;
create or alter function fn_test returns int as begin end^
set term ;^
commit;
set term ^;
create or alter function fn_test returns int as
begin
exception ex_some_non_existent_name;
return 1;
end
^
set term ;^
commit;
If comment line #2 ( create or alter function fn_test returns int as begin end^) - all becomes OK.
The following script will show error message "unknown ISC error 335544994" instead of normal explanation that exception does not exists:
set term ^;
create or alter function fn_test returns int as begin end^
set term ;^
commit;
set term ^;
create or alter function fn_test returns int as
begin
exception ex_some_non_existent_name;
return 1;
end
^
set term ;^
commit;
If comment line #2 ( create or alter function fn_test returns int as begin end^) - all becomes OK.
=>
LI-T6.3.0.30981
The following script will show error message "Error while parsing function's BLR" instead of normal explanation that exception does not exist, i.e. a specific error message is lost while raising a more generic one.
set term ^;
create or alter function fn_test returns int as begin end^
set term ;^
commit;
set term ^;
create or alter function fn_test returns int as
begin
exception ex_some_non_existent_name;
return 1;
end
^
set term ;^
commit;
If comment line #2 ( create or alter function fn_test returns int as begin end^) - all becomes OK.
summary: Create function/sp which references to NON-existent exception: compiler outputs "unknown ISC error 335544994" instead of "exception not defined" => Create function/sp which references to non-existent exception: error message is "Error while parsing function's BLR" instead of "exception not defined"
Submitted by: @pavel-zotov
LI-T6.3.0.30981
The following script will show error message "Error while parsing function's BLR" instead of normal explanation that exception does not exist, i.e. a specific error message is lost while raising a more generic one.
set term ^;
create or alter function fn_test returns int as begin end^
set term ;^
commit;
set term ^;
create or alter function fn_test returns int as
begin
exception ex_some_non_existent_name;
return 1;
end
^
set term ;^
commit;
If comment line #2 ( create or alter function fn_test returns int as begin end^) - all becomes OK.
Commits: 7596de8 FirebirdSQL/fbt-repository@839c3f2
The text was updated successfully, but these errors were encountered: