Issue Details (XML | Word | Printable)

Key: CORE-1862
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Claudio Valderrama C.
Reporter: Claudio Valderrama C.
Votes: 0
Watchers: 0
Operations

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

Isql's extracted script is unusable with interdependent selectable procedures in FB 2.1

Created: 24/Apr/08 06:48 AM   Updated: 23/Feb/11 01:54 PM
Component/s: ISQL
Affects Version/s: 2.5 Initial, 2.1.0
Fix Version/s: 2.5 Alpha 1

Time Tracking:
Not Specified

Environment: Platform independent.
Issue Links:
Relate
 

Planning Status: Unspecified


 Description  « Hide
Since IB6 or before (can't remember) isql has extracted first the procedure's headers (parameters) and later the bodies. It typically does:
CREATE PROCEDURE P AS
BEGIN EXIT; END ^

However, as FB2.1 has a way to distinguish between selectable and executable procedures and enforces the difference, if a proc A that calls a selectable proc B is defined before B, A won't compile because (due to the header) FB knows it's not selectable.
The solution is that for FB2.1 and newer, isql read the rdb$procedure_type field and do the correct header extraction as shown here:
CREATE PROCEDURE P AS
BEGIN SUSPEND; END ^

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.