Issue Details (XML | Word | Printable)

Key: CORE-5216
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Minor Minor
Assignee: Dmitry Yemanov
Reporter: Boltik Evgeny
Votes: 0
Watchers: 1
Operations

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

Provide location context (line/column numbers) for runtime errors raised inside EXECUTE BLOCK

Created: 28/Apr/16 11:33 AM   Updated: 22/Sep/16 06:42 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 2.5.6, 3.0.1, 4.0 Alpha 1

QA Status: Done with caveats
Test Details: Implemented only for 3.0 and above; 2.5.x does not show all of expected lines.


 Description  « Hide
set term ^;

select cast('' as timestamp) from rdb$database
^
-- ERROR:
-- Statement failed, SQLSTATE = 22018
-- conversion error from string ""


recreate procedure qwe123
  returns(res timestamp)
as
begin
  res = cast('' as timestamp);
  suspend;
end
^

execute procedure qwe123
^
-- ERROR:
-- Statement failed, SQLSTATE = 22018
-- conversion error from string ""
-- At procedure 'QWE123' line: 5, col: 3

execute block
returns(res timestamp)
as
begin
  res = cast('' as timestamp);
  suspend;
end
^
-- ERROR:
-- Statement failed, SQLSTATE = 22018
-- conversion error from string ""

Something like "At anonymous block line: 5, col: 3" should be reported in this case.


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no subversion log entries for this issue yet.