Issue Details (XML | Word | Printable)

Key: CORE-1894
Type: Bug Bug
Status: Reopened Reopened
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 2
Watchers: 0
Operations

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

Circular dependencies between computed fields crashs the engine

Created: 11/May/08 04:18 PM   Updated: 12/Jun/14 07:34 AM
Component/s: Engine
Affects Version/s: 2.0.0, 2.0.1, 2.0.2, 2.0.3, 2.5 Initial, 2.1.0, 2.0.4, 2.5.0
Fix Version/s: None

Time Tracking:
Not Specified

Issue Links:
Duplicate
 
Relate
 

Planning Status: Unspecified


 Description  « Hide
Ability to alter computed fields introduced the possibility of circular dependencies between them.

create table t (
    n integer,
    n1 computed by (n),
    n2 computed by (n1)
);

alter table t alter n1 computed by (n2);

select * from t;
-- segmentation fault (due to stack overflow in CMP/pass1)

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Pavel Cisar added a comment - 21/Apr/11 09:33 AM
This issue is fixed only partially. While second test case (drop + add field with circular reference) is fixed, the originally reported case (alter field to create circular reference) still crash the server (2.5.0.26074).

Philippe Makowski added a comment - 21/Jun/11 12:13 PM
I confirm Pavel's statement, the original reported case still crash the server (2.5.1.26308)