Sparx Systems Forum

Enterprise Architect => Bugs and Issues => Topic started by: Henrik Raböse on July 08, 2016, 11:26:08 pm

Title: MySQL, Datetime, DDL-Issue
Post by: Henrik Raböse on July 08, 2016, 11:26:08 pm

EA: 12.0.1215

In the database builder: Column "adddate", Type "Datetime". I can't change or remove the "Length" (0).

(http://it-raboese.de/EA_Datetime_Issue.png)

The DDL-Generator make this.

Code: [Select]

CREATE TABLE `customer`
(
`id` BIGINT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(150) NOT NULL,
`adddate` DATETIME(0) NOT NULL,
`addby` BIGINT NOT NULL,
`changedate` DATETIME(0) NOT NULL,
`changeby` BIGINT NOT NULL,
CONSTRAINT `PK_customer` PRIMARY KEY (`id`)
)


The generated code has an SQL-Error: Datatype "DATETIME" has not a length. "`adddate` DATETIME(0) NOT NULL,"



regards
Henrik

Title: Re: MySQL, Datetime, DDL-Issue
Post by: qwerty on July 09, 2016, 01:06:22 am

For which database?

q.

Title: Re: MySQL, Datetime, DDL-Issue
Post by: Henrik Raböse on July 09, 2016, 03:23:53 am

Sorry.
But it is in the subject: MySql.

Title: Re: MySQL, Datetime, DDL-Issue
Post by: qwerty on July 09, 2016, 04:28:29 am

lol

I just tried this with MySQL and my EA does not create the number:

Code: [Select]

`date` DATETIME NULL
used release 1224. So maybe you should update?

q.

Title: Re: MySQL, Datetime, DDL-Issue
Post by: Henrik Raböse on July 09, 2016, 06:09:59 am

Ok, thank you for this hint.
I'll try this again with update and report my result.

regards
Henrik

ps.
There is an update to the version 1224?

pps.
I've updated to version 1230 and the DDL-code looks like good ;).

Title: Re: MySQL, Datetime, DDL-Issue
Post by: qwerty on July 09, 2016, 06:43:51 am

Formerly I had been on the latest release whenever possible, but I'm no longer that adventurous ;-)
But probably it's better to update to the latest version once you ran into trouble.

q.