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

[firebird-automations]

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]

Modified by: @dyemanov

Fix Version: 3.0 [ 10048 ]

SF_ID: 1047576 =>

assignee: Sean Leyne [ seanleyne ] =>

[firebird-automations]

Commented by: peter worbis (worbis)

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

[firebird-automations]

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]

Modified by: @dyemanov

Link: This issue is duplicated by CORE1632 [ CORE1632 ]

[firebird-automations]

Modified by: @pcisar

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

[firebird-automations]

Modified by: @dyemanov

Link: This issue relate to CORE1865 [ CORE1865 ]

[firebird-automations]

Modified by: @pcisar

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

[firebird-automations]

Modified by: @dyemanov

Link: This issue relate to CORE3165 [ CORE3165 ]

[firebird-automations]

Modified by: @pavel-zotov

QA Status: No test