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

Can't drop table when computed field depends on later created another field [CORE3579] #3933

Closed
firebird-automations opened this issue Aug 22, 2011 · 9 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @dmitry-starodubov

Depends on CORE3557
Is related to QA468

create table Test (
Comp computed by (1),
Src int
);

alter table Test alter Comp computed by (Src);

After reconnect try to drop table:
drop table Test;

Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-ERASE RDB$RELATIONS failed
-invalid request BLR at offset 6
-column SRC is not defined in table TEST

Commits: 13c6c85 7833f5e 0ed1fad d760408

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Recent patch for CORE3557 should fix this issue too, please test it and report back

@firebird-automations
Copy link
Collaborator Author

Commented by: @dmitry-starodubov

Yes, it fixes the problem. Thanks.

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 2.0.7 [ 10390 ]

Fix Version: 2.5.2 [ 10450 ]

Fix Version: 2.1.5 [ 10420 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Link: This issue depends on CORE3557 [ CORE3557 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA468 [ QA468 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Test created.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

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