[jira] Closed: (CAY-1030) Delete rule not set on reverse engineer databse

["Andrey Razumovsky (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/cayenne/browse/CAY-1030?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrey Razumovsky closed CAY-1030.
----------------------------------

       Resolution: Won't Fix
    Fix Version/s: 3.0M6
         Assignee: Andrey Razumovsky  (was: Andrus Adamchik)

Cayenne delete rule is somewhat different than DB delete rule. There was some discussion in CAY-436 about that. 
There's no point to have e.g. two 'cascade' rules

> Delete rule not set on reverse engineer databse
> -----------------------------------------------
>
>                 Key: CAY-1030
>                 URL: https://issues.apache.org/cayenne/browse/CAY-1030
>             Project: Cayenne
>          Issue Type: Bug
>          Components: CayenneModeler GUI
>    Affects Versions: 3.0
>         Environment: Cayenne Modeler Win 3.0M3, MySQL 5.0.24a (InnoDB)
>            Reporter: Borut Bolčina
>            Assignee: Andrey Razumovsky
>             Fix For: 3.0M6
>
>
> When 2 tables
> create table module_template_module_parameter (module_template_id int not null, module_parameter_id int not null, value text not null, primary key (module_template_id, module_parameter_id)) type=InnoDB;
> create table module_template (id int not null, catalog_id int, module_id varchar(255) not null, template_id int not null, control_id int, coloumn tinyint, instance int not null, ordering int, style varchar(255), user_id varchar(32), primary key (id)) type=InnoDB;
> are created with this Cascade delete rule
> alter table module_template_module_parameter add index FKmodule_tem396421 (module_template_id), add constraint FKmodule_tem396421 foreign key (module_template_id) references module_template (id) on delete Cascade;
> the modeler does not set the delete rule on the created relationship.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.