Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: VaS on May 12, 2005, 05:10:19 am

Title: Bug in DDL generating
Post by: VaS on May 12, 2005, 05:10:19 am

I have found a bug in DDL generating.

There's simple data model consists 3 tables (http://www.opcsoft.ru/download/123.zip).

EA can't generate right DDL from it.

It produces:  

ALTER TABLE "HDA_FOLDERS" ADD CONSTRAINT "PK_HDA_STRUCTURE"
PRIMARY KEY ("I)

instead:

ALTER TABLE "HDA_FOLDERS" ADD CONSTRAINT "PK_HDA_STRUCTURE"
PRIMARY KEY ("ID")

You may try to have the same wonderful result using the file I mentioned above.

Title: Re: Bug in DDL generating
Post by: thomaskilian on May 12, 2005, 05:25:07 am

Code: [Select]

CREATE TABLE DB_VERSIONS (
ID int identity(0,1)  NOT NULL,
PRODUCT_ID smallint DEFAULT -1 NOT NULL,
VERSION int DEFAULT -1 NOT NULL,
STAMP datetime DEFAULT 0 NOT NULL
)
;

CREATE TABLE HDA_FOLDERS (
ID int identity(0,1)  NOT NULL,
PARENT_ID int DEFAULT -1 NOT NULL,
NAME varchar(200) DEFAULT 'HDA Group' NOT NULL,
DESCRIPTION varchar(1000),
IS_LOG_GROUP smallint DEFAULT 0 NOT NULL,
MSTAMP datetime DEFAULT 0 NOT NULL
)
;

CREATE TABLE HDA_ITEMS (
ID int identity(0,1)  NOT NULL,
HDA_FOLDERS_ID int DEFAULT -1 NOT NULL,
NAME varchar(200) DEFAULT 'HDA Item' NOT NULL,
DESCRIPTION varchar(1000),
MSTAMP datetime DEFAULT 0 NOT NULL,
DA_ITEMID varchar(500) NOT NULL
)
;

I'm using the latest 5.0 beta

Title: Re: Bug in DDL generating
Post by: VaS on May 12, 2005, 05:47:55 am

You didn't generate primary keys. The errors are there.

I'll try to use 5 beta immediately....

Title: Re: Bug in DDL generating
Post by: VaS on May 12, 2005, 05:54:28 am

:)) Where could I get the latest beta of EA? Unfortunately, I can't find it over the site.

Title: Re: Bug in DDL generating
Post by: thomaskilian on May 12, 2005, 06:28:14 am

You will find it on the registered users download area.