Issue Details (XML | Word | Printable)

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

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: 25/Sep/15 12:40 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

Issue Links:

QA Status: Done successfully

 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
-invalid request BLR at offset 6
-column SRC is not defined in table TEST

 All   Comments   Change History   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.

Pavel Cisar added a comment - 25/Sep/15 12:40 PM
Test created.