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
Comments
Commented by: @aafemt Commit wasn't necessary in version 1.5 but it might result in corrupted database. |
Commented by: @dyemanov This is the intended change in behaviour. Altering/dropping procedures in use is no longer allowed. |
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? |
Commented by: @dyemanov Unreliable and often confusing behaviour under load. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: @dyemanov Reopened upon requests from customers. |
Modified by: @dyemanovstatus: Closed [ 6 ] => Reopened [ 4 ] assignee: Dmitry Yemanov [ dimitr ] resolution: Won't Fix [ 2 ] => |
Modified by: @dyemanovstatus: Reopened [ 4 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.0.1 [ 10090 ] Fix Version: 2.1 [ 10041 ] |
Commented by: @pcisar Fix verified, test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: @pcisar Reopened to update ticket information. |
Modified by: @pcisarWorkflow: jira [ 11126 ] => Firebird [ 14679 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
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
The text was updated successfully, but these errors were encountered: