Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021634Openbravo ERPA. Platformpublic2012-09-12 20:182012-09-26 17:19
Reportershuehner 
Assigned ToAugustoMauch 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP16 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021634: obuiapp_note.ad_table_id is missing onDeleteCascade
DescriptionAfter adding a note entry to any record of some specific ad_table. It it not possible anymore to delete that table.

Example case.
Install module having any new table. Add a note to a record in that table.
Uninstall the module having the table.
Rebuild. -> fails
As fk from obuiapp_note.ad_table_id does not have onDelete cascade notes related to the deleted table do not get deleted as well.

Imo they should same as the system does of course delete all the content of the table itself.
Steps To ReproduceSee description.
Proposed SolutionAdd onDelete="cascade" to the obuiapp_note.ad_table_id foreign-key
Additional Information
TagsNo tags attached.
Relationships
related to defect 00216723.0MP16 closed AugustoMauch API change: Added delete on cascade constraint 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-09-12 20:18shuehnerNew Issue
2012-09-12 20:18shuehnerAssigned To => AugustoMauch
2012-09-12 20:18shuehnerModules => Core
2012-09-12 20:18shuehnerOBNetwork customer => No
2012-09-14 12:31hgbotCheckin
2012-09-14 12:31hgbotNote Added: 0052130
2012-09-14 12:31hgbotStatusnew => resolved
2012-09-14 12:31hgbotResolutionopen => fixed
2012-09-14 12:31hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/38acdd74058a16e99608f6e302e7b3fb140d2705 [^]
2012-09-17 14:20AugustoMauchRelationship addedrelated to 0021672
2012-09-24 16:52AugustoMauchClosed by => AugustoMauch
2012-09-24 16:52AugustoMauchNote Added: 0052350
2012-09-24 16:52AugustoMauchStatusresolved => closed
2012-09-24 16:52AugustoMauchFixed in Version => 3.0MP16
2012-09-26 17:19hudsonbotCheckin
2012-09-26 17:19hudsonbotNote Added: 0052760

Notes
(0052130)
hgbot   
2012-09-14 12:31   
Repository: erp/devel/pi
Changeset: 38acdd74058a16e99608f6e302e7b3fb140d2705
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Fri Sep 14 12:13:37 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/38acdd74058a16e99608f6e302e7b3fb140d2705 [^]

Fixes Issue 21634 : Added Cascade delete to obuiapp_note.ad_table_id

Added onDelete Cascade to ad_table_id field in obuiapp_note table.

---
M modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NOTE.xml
---
(0052350)
AugustoMauch   
2012-09-24 16:52   
Code reviewed and verified in pi@4c4431d17dbd
(0052760)
hudsonbot   
2012-09-26 17:19   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/b780e90c6452 [^]

Maturity status: Test