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

Restore with SPs in 'COMPUTED BY' fields fails [CORE374] #716

Closed
firebird-automations opened this issue Oct 15, 2004 · 9 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: css (css)

Assigned to: @samofatov

Relate to CORE1865
Is duplicated by CORE1632
Relate to CORE3165

SFID: 1047576#⁠
Submitted By: css

A restore fails on a table that has computed fields
which select a value from a stored procedure, eg.
....computed by ( Select Total from
StoredProc_Total(http://table.PK) )
will cause a prerviously backedup database not to be
restored correctly.
ErrorMessage: "Unsuccessful execution caused by system
error that does not preclude successful execution of
subsequent statements.
action cancelled by trigger (0) to preserve data integrity.
could not find table/procedure for GRANT."

The table is granted the right to execute/reference the
StoredProcedure.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 [ 10048 ]

SF_ID: 1047576 =>

assignee: Sean Leyne [ seanleyne ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: peter worbis (worbis)

the restore also fails if you are using an udf in a computed by field

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.1 RC1 [ 10201 ]

assignee: Nickolay Samofatov [ skidder ]

Fix Version: 3.0.0 [ 10048 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is duplicated by CORE1632 [ CORE1632 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10398 ] => Firebird [ 14659 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue relate to CORE1865 [ CORE1865 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue relate to CORE3165 [ CORE3165 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant