Skip to content
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

Jump to bottom

Metadata export with isql (option -ex) does not export functions properly [CORE4122] #4450

Closed
firebird-automations opened this issue Jun 18, 2013 · 10 comments
Closed

Metadata export with isql (option -ex) does not export functions properly [CORE4122] #4450

firebird-automations opened this issue Jun 18, 2013 · 10 comments
Assignees
@dyemanov
Labels
affect-version: 3.0 Initial component: isql fix-version: 3.0 Alpha 1 priority: major qa: done successfully type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Thomas Beckmann (thbeckmann)

Attachments:
Test_Create.sql
Test_MetaDump.sql

Functions are exported as if they were UDFs.
Functions belonging to packages are actually exported twice, properly with the package and incorrectly.

Commits: b94f613 FirebirdSQL/fbt-repository@fb74f0c
@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

Thomas, unfortunately, the subject does not "say it all".

The problem, as you have described it, seems to be limit to the export of functions which are part of packages...

A sample of the output would be helpfull.

@firebird-automations
Copy link
Collaborator Author

Modified by: Thomas Beckmann (thbeckmann)

description: Summary says it all:
Functions are exported as if they were UDFs.
Functions belonging to packages are actually exported twice, properly with the package and incorrectly.

=>

Functions are exported as if they were UDFs.
Functions belonging to packages are actually exported twice, properly with the package and incorrectly.

summary: Metadata export with isql (option -ex) does not functions properly => Metadata export with isql (option -ex) does not export functions properly

@firebird-automations
Copy link
Collaborator Author

Commented by: Thomas Beckmann (thbeckmann)

Hi Sean,

no, actually, it is not limited to functions in packages - as I wrote, all functions are exported as if they were UDFs. Those belonging to a package are exported with the correct package syntax once more.

I'll put together an example tonight.

@firebird-automations
Copy link
Collaborator Author

Commented by: Thomas Beckmann (thbeckmann)

Attached Create script creates 2 functions, one inside, one outside a package, Dumping the besides that empty database via "isql -ex" leads to MetaDump script, containing 2 (wrong) UDF declarations of the functions and the proper declaration of the package.

@firebird-automations
Copy link
Collaborator Author

Modified by: Thomas Beckmann (thbeckmann)

Attachment: Test_Create.sql [ 12337 ]

Attachment: Test_MetaDump.sql [ 12338 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Frank Schlottmann-Goedde (fsg)

I believe this is the same problem as described in CORE3963

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Done successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@dyemanov dyemanov

Labels
affect-version: 3.0 Initial component: isql fix-version: 3.0 Alpha 1 priority: major qa: done successfully type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@dyemanov @firebird-automations