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

SP needs recompilation after deleting index [CORE331] #666

Closed
firebird-automations opened this issue Aug 31, 2005 · 13 comments
Closed

SP needs recompilation after deleting index [CORE331] #666

firebird-automations opened this issue Aug 31, 2005 · 13 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: obucina (obucina)

Is replaced by CORE828

Attachments:
SFARTIKLI.zip

SFID: 1277777#⁠
Submitted By: obucina

I presume SP use that index.
After deleting index SP cant execute.

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

Date: 2005-09-08 14:50
Sender: dimitr
Logged In: YES
user_id=61270

Procedure's optimized BLR resides in the metadata cache. To
clear this cache, it's enough to disconnect all users from
database. Recompilation is not necessary.

While I agree this is not very good behaviour, the actual
resolution of this bug should be "as designed/pitfall". But,
even if this SF ticket is closed/deleted, I'd suggest to add
a feature request to allow re-optimization of cached SPs
under some circumstances.

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

Date: 2005-09-01 13:59
Sender: obucina
Logged In: YES
user_id=959752

Stripped from my app.

SP will use index IDX_SFARTIKLI_KA.

Execute script, execute SP, drop index, execute SP - Error.

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

Date: 2005-09-01 00:09
Sender: seanleyne
Logged In: YES
user_id=71163

Please provide a SQL script which demonstrates the problem.

@firebird-automations
Copy link
Collaborator Author

Commented by: Alice F. Bird (firebirds)

Date: 2005-08-31 23:54
Sender: obucina
Logged In: YES
user_id=959752

v1.5.2

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is replaced by CORE828 [ CORE828 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

As Dmitry suggested, this issue was replaced by Improvement request (see linked issue).

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

resolution: Won't Fix [ 2 ]

assignee: Dmitry Yemanov [ dimitr ]

SF_ID: 1277777 =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

SF_ID: 1277777 =>

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Reopened just to add attachment.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

SF_ID: 1277777 =>

resolution: Won't Fix [ 2 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Attachment: SFARTIKLI.zip [ 10029 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

resolution: Won't Fix [ 2 ]

SF_ID: 1277777 =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10355 ] => Firebird [ 14595 ]

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

2 participants