Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0021672 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | have not tried | 2012-09-17 14:17 | 2012-09-17 17:17 | |||
| Reporter | AugustoMauch | View Status | public | |||||
| Assigned To | AugustoMauch | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 3.0MP16 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 425718995c30 | ||||
| Projection | none | ETA | none | Target Version | 3.0MP16 | |||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | AugustoMauch | |||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0021672: API change: Added delete on cascade constraint | |||||||
| Description | In 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 Reproduce | 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
Notes |
|
|
(0052172) iciordia (viewer) 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:17 | AugustoMauch | OBNetwork customer | => No |
| 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 |