Issue Details (XML | Word | Printable)

Key: CORE-3579
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Vlad Khorsun
Reporter: Dmitriy Starodubov
Votes: 0
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Can't drop table when computed field depends on later created another field

Created: 22/Aug/11 07:14 AM   Updated: 27/Mar/14 12:13 PM
Component/s: Engine
Affects Version/s: 2.5.1
Fix Version/s: 2.0.7, 2.1.5, 2.5.2, 3.0 Alpha 1

Time Tracking:
Not Specified

Issue Links:
Depend
 
Relate
 

Planning Status: Unspecified


 Description  « Hide
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

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Vlad Khorsun added a comment - 08/Nov/11 12:18 PM
Recent patch for CORE-3557 should fix this issue too, please test it and report back

Dmitriy Starodubov added a comment - 08/Nov/11 01:12 PM
Yes, it fixes the problem. Thanks.