New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
ISQL v 2.5 extract metadata extract view with procedure into "from" earlier than the needed procedure [CORE6162] #6411
Comments
Commented by: Anatoly Loy (anatoloy) Offer for fix |
Modified by: Anatoly Loy (anatoloy)Attachment: extract.epp [ 13390 ] |
Commented by: @aafemt It is a chicken-egg problem. Procedures using views are much more wide spread than views using procedures. |
Commented by: Anatoly Loy (anatoloy) The attached files (new source and diff) contains realization of current issue: |
Modified by: Anatoly Loy (anatoloy)Attachment: diff.txt [ 13391 ] |
Commented by: Anatoly Loy (anatoloy) And in the end, it's already done in FB 3.0 ;) |
Commented by: @hvlad Issue is already fixed in fb3 |
Commented by: Sean Leyne (seanleyne) Anatoly, you should be able to use ISQL v3 with v2.5.x databases. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Anatoly Loy (anatoloy)
Attachments:
extract.epp
diff.txt
1. Script for test:
CREATE PROCEDURE a() RETURNS (out1 INTEGER)
AS
BEGIN
out1 = 1;
SUSPEND;
END;
CREATE VIEW b(b1) AS SELECT out1 as b1 FROM a();
2. ISQL extract metadata in wrong order (view then procedure). That result not create new datanase correctly.
The text was updated successfully, but these errors were encountered: