Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0004706 | Openbravo ERP | Y. DBSourceManager | public | 2008-08-25 17:29 | 2009-03-18 11:02 |
|
| Reporter | marvintm | |
| Assigned To | marvintm | |
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0004706: DROP TABLE CASCADE statements cause DROP VIEW statements to fail |
| Description | If a view depending on a table and that table have to be dropped when updating the database, there will be an error.
This error happens because the DROP TABLE statement containts a CASCADE clause, that in turn forces the database to drop the view. Afterwards, dbsourcemanager tries to delete the view, which causes the error, as the view no longer exists.
|
| Steps To Reproduce | Simply remove a table and a dependant view from your database xml files, and perform a ant update.database |
| Proposed Solution | The solution will be to delete views before deleting tables, so that this problem doesn't happen. |
| Additional Information | |
| Tags | dbsm_migrate |
| Relationships | |
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2008-08-25 17:29 | marvintm | New Issue | |
| 2008-08-25 17:29 | marvintm | Assigned To | => marvintm |
| 2008-08-25 17:30 | svnbot | Checkin | |
| 2008-08-25 17:30 | svnbot | Note Added: 0008731 | |
| 2008-08-25 17:30 | svnbot | Status | new => resolved |
| 2008-08-25 17:30 | svnbot | Resolution | open => fixed |
| 2008-08-25 17:30 | svnbot | svn_revision | => 106 |
| 2008-12-15 19:05 | psarobe | Status | resolved => closed |
| 2008-12-18 12:38 | jpabloae | Sticky Issue | No => Yes |
| 2008-12-18 12:39 | jpabloae | Sticky Issue | Yes => No |
| 2008-12-18 12:39 | jpabloae | Tag Attached: dbsm_migrate | |
| 2008-12-18 12:41 | jpabloae | Project | @4@ => Openbravo ERP |
| 2008-12-18 12:42 | jpabloae | Category | => Y. DBSourceManager |
| 2009-03-18 11:02 | anonymous | sf_bug_id | 0 => 2691341 |