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
Dmitry Yemanov made changes - 28/Apr/16 11:33 AM
Field Original Value New Value
Assignee Dmitry Yemanov [ dimitr ]
Dmitry Yemanov made changes - 28/Apr/16 12:40 PM
Fix Version/s 3.0.1 [ 10730 ]
Fix Version/s 4.0 Alpha 1 [ 10731 ]
Reporter Dmitry Yemanov [ dimitr ] Boltik Evgeny [ bolt ]
Dmitry Yemanov made changes - 28/Apr/16 12:51 PM
Priority Major [ 3 ] Minor [ 4 ]
Dmitry Yemanov made changes - 28/Apr/16 12:57 PM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Fixed [ 1 ]
Dmitry Yemanov made changes - 28/Apr/16 07:21 PM
Fix Version/s 2.5.6 [ 10721 ]
Pavel Zotov made changes - 30/Apr/16 11:13 AM
Status Resolved [ 5 ] Resolved [ 5 ]
Test Details Waiting for reply on issue 29/Apr/16 07:34 PM.
QA Status No test Deferred
Pavel Zotov made changes - 22/Sep/16 06:42 AM
Status Resolved [ 5 ] Resolved [ 5 ]
Test Details Waiting for reply on issue 29/Apr/16 07:34 PM. Implemented only for 3.0 and above; 2.5.x does not show all of expected lines.
QA Status Deferred Done with caveats