Issue Details (XML | Word | Printable)

Key: CORE-4371
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Pavel Zotov
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Create function/sp which references to non-existent exception: error message is "Error while parsing function's BLR" instead of "exception not defined"

Created: 25/Mar/14 05:01 AM   Updated: 22/Sep/15 09:41 AM
Component/s: Engine
Affects Version/s: 3.0 Alpha 2
Fix Version/s: 3.0 Beta 1

QA Status: Done successfully


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov made changes - 25/Mar/14 05:18 AM
Field Original Value New Value
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"
Description LI-T6.3.0.30981

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.
Dmitry Yemanov made changes - 25/Mar/14 05:38 AM
Assignee Dmitry Yemanov [ dimitr ]
Dmitry Yemanov made changes - 25/Mar/14 01:53 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Resolution Fixed [ 1 ]
Pavel Zotov made changes - 29/May/15 09:37 PM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status Done successfully
Pavel Cisar made changes - 22/Sep/15 09:41 AM
Status Resolved [ 5 ] Closed [ 6 ]