Issue Details (XML | Word | Printable)

Key: CORE-1894
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Adriano dos Santos Fernandes
Votes: 3
Watchers: 1

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: 19/Oct/16 07:40 PM
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, 4.0 Initial, 3.0.0, 3.0.1
Fix Version/s: 3.0.2, 4.0 Alpha 1

Issue Links:

QA Status: Done successfully

 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   Change History   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 (

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

Philippe Makowski added a comment - 31/Mar/15 08:57 AM
This is still not fixed in 3.0 branch, and still crash the server.