Page 1 of 1

Relational grammar ignored on project generation

Posted: Thu 22 Oct 2015 20:43
by terryweiss
When working with foreign keys and creating actions on update and delete, this code:

Code: Select all

references `incident.assessments` (`id`) on delete restrict on update cascade,
produces

Code: Select all

references `incident.assessments` (id) on delete no action on update cascade
Notice that

Code: Select all

delete restrict
was changed to

Code: Select all

delete no action
. A somewhat different command :)

t.

Re: Relational grammar ignored on project generation

Posted: Fri 23 Oct 2015 13:10
by alexa
We will investigate this issue and will answer you as soon as possible.

Re: Relational grammar ignored on project generation

Posted: Fri 23 Oct 2015 14:21
by alexa
We recommend you to refer to the following article http://dev.mysql.com/doc/refman/5.6/en/ ... -keys.html