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

DDL - object in use [CORE888] #1281

Closed
firebird-automations opened this issue Aug 3, 2006 · 20 comments
Closed

DDL - object in use [CORE888] #1281

firebird-automations opened this issue Aug 3, 2006 · 20 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Fredrik Aakvik (fredrik)

Is duplicated by CORE1081
Is related to QA28

Got a problem with DDL's in Firebird 2, combining with DML's.
This example was no problem in Firebird 1.5, but causes an error message in version 2.
I run the script from ISQL.

---------------------------------------------------
SET TERM ^ ;
CREATE PROCEDURE TestProc
AS
BEGIN
EXIT;
END ^
SET TERM ; ^

EXECUTE PROCEDURE TestProc;

DROP PROCEDURE TestProc;
---------------------------------------------------

It's the statement "DROP PROCEDURE TestProc" that gives the error message:
"Unsuccessful metadata update -object TestProc is in use"

If I add an "COMMIT" before the "DROP PROCEDURE TestProc" it will work fine,
but that was not necessary in version 1.5

Commits: f3f4630

@firebird-automations
Copy link
Collaborator Author

Commented by: @aafemt

Commit wasn't necessary in version 1.5 but it might result in corrupted database.

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

This is the intended change in behaviour. Altering/dropping procedures in use is no longer allowed.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Won't Fix [ 2 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: pi3k14 (pi3k14)

I guess that "Altering/dropping procedures in use is no longer allowed.", is meaning "Altering/dropping procedures used in open transactions is no longer allowed."?

What is the rationale for that?

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Unreliable and often confusing behaviour under load.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Reopened upon requests from customers.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

assignee: Dmitry Yemanov [ dimitr ]

resolution: Won't Fix [ 2 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Reopened [ 4 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.0.1 [ 10090 ]

Fix Version: 2.1 [ 10041 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is duplicated by CORE1081 [ CORE1081 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Fix verified, test added.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Reopened to update ticket information.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

resolution: Fixed [ 1 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Fix Version: 2.1 Alpha 1 [ 10150 ]

Fix Version: 2.1.0 [ 10041 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA28 [ QA28 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 11126 ] => Firebird [ 14679 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test => Done successfully

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