Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0021672
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2012-09-17 14:172012-09-17 17:17
ReporterAugustoMauchView Statuspublic 
Assigned ToAugustoMauch 
PriorityimmediateResolutionfixedFixed in Version3.0MP16
StatusclosedFix in branchFixed in SCM revision425718995c30
ProjectionnoneETAnoneTarget Version3.0MP16
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToAugustoMauch
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0021672: API change: Added delete on cascade constraint

DescriptionIn the fix of issue https://issues.openbravo.com/view.php?id=21634, [^] an delete on constraint constraint was added to the obuiapp_note.ad_table_id column, this breaks the API.

This constraint was needed because it is not possible to uninstall a module when a note has been posted on a table related to it.

The only change the users may notice is that now if a table containing notes is deleted, the table will be actually deleted along with its notes.
Steps To ReproduceInstall 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0021634 closedAugustoMauch obuiapp_note.ad_table_id is missing onDeleteCascade 

-  Notes
(0052172)
iciordia (manager)
2012-09-17 16:44

Approved.

Ismael
(0052173)
hgbot (developer)
2012-09-17 17:14

Repository: erp/devel/api-checks
Changeset: 425718995c3090713e68c8fd6e6371559bf2f11b
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Mon Sep 17 17:13:17 2012 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/425718995c3090713e68c8fd6e6371559bf2f11b [^]

Fixes issue 21672: Added delete on cascade to obuiapp_note.ad_table_id column

---
M model/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_NOTE.xml
---

- Issue History
Date Modified Username Field Change
2012-09-17 14:17 AugustoMauch New Issue
2012-09-17 14:17 AugustoMauch Assigned To => AugustoMauch
2012-09-17 14:17 AugustoMauch Modules => Core
2012-09-17 14:20 AugustoMauch Relationship added related to 0021634
2012-09-17 14:20 AugustoMauch Assigned To AugustoMauch => iciordia
2012-09-17 16:44 iciordia Note Added: 0052172
2012-09-17 16:44 iciordia Assigned To iciordia => AugustoMauch
2012-09-17 17:14 hgbot Checkin
2012-09-17 17:14 hgbot Note Added: 0052173
2012-09-17 17:14 hgbot Status new => resolved
2012-09-17 17:14 hgbot Resolution open => fixed
2012-09-17 17:14 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/425718995c3090713e68c8fd6e6371559bf2f11b [^]
2012-09-17 17:17 AugustoMauch Closed by => AugustoMauch
2012-09-17 17:17 AugustoMauch Status resolved => closed
2012-09-17 17:17 AugustoMauch Fixed in Version => 3.0MP16


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker