0001126: generated DDL does not handle circular references in computed fields

ID	Project	Category	View Status	Date Submitted	Last Update

0001126	Database Workbench v5	Meta Data Compare & Migration	public	2014-12-29 10:46	2014-12-29 10:59

Reporter	Wolfgang Rohdewald	Assigned To	Martijn Tonies
Priority	normal	Severity	major	Reproducibility	always
Status	acknowledged	Resolution	open
Product Version	5.0.6

Summary	0001126: generated DDL does not handle circular references in computed fields
Description	I have two tables referencing each other with computed fields. Extracting DDL for the database generates a script which cannot create a new empty database. IMHO It should first create only dummy definitions for all computed fields and alter them after all tables have been created. Just like it does with procedures.
Additional Information	This is what DBWorkbench generates: CREATE TABLE A ( ID BIGINT NOT NULL, CB COMPUTED BY ((select id from b where id=b.id)) ); CREATE TABLE B ( ID BIGINT NOT NULL, CA COMPUTED BY ((select id from a where id=a.id)) );
Tags	No tags attached.

Date Modified	Username	Field	Change
2014-12-29 10:46	Wolfgang Rohdewald	New Issue
2014-12-29 10:59	Martijn Tonies	Assigned To	=> Martijn Tonies
2014-12-29 10:59	Martijn Tonies	Status	new => acknowledged
2015-05-11 11:20	Martijn Tonies	Category	Compare & Migration => Meta Data Compare & Migration