Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0028822 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| design defect | [Openbravo ERP] Y. DBSourceManager | minor | have not tried | 2015-01-30 12:59 | 2022-02-01 08:09 | ||||||
| Reporter | alostale | View Status | public | ||||||||
| Assigned To | Triage Platform Base | ||||||||||
| Priority | normal | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Any | Database | Any | Java version | |||||||
| OS Version | Database version | Ant version | |||||||||
| Product Version | SCM revision | ||||||||||
| Review Assigned To | AugustoMauch | ||||||||||
| Web browser | |||||||||||
| Modules | Core | ||||||||||
| Regression level | |||||||||||
| Regression date | |||||||||||
| Regression introduced in release | |||||||||||
| Regression introduced by commit | |||||||||||
| Triggers an Emergency Pack | No | ||||||||||
| Summary | 0028822: update.database.script is not reliable | ||||||||||
| Description | update.database.script task logs a file with the sql statements that actual update.database would execute. The problem is that it logs some commands that actual update.database will not execute. Example: actual update.database drops FKs only for those tables to be recreated and for the ones defined in the AD dataset whereas update.database.script logs statements to drop *all* FKs. Though the script is still useful to understand the main actions done by update.database it is not reliable. | ||||||||||
| Steps To Reproduce | -execute ant update.datbase to syn DB with xml -execute ant update.databse.script -Dbbdd.outputscript=/tmp/update.sql --> check all FK constrains are dropped and recreated -set pg log to log all the statements in DB -execute ant update.datbase --> check not all the FKs appearing in the script are actually dropped and recreated | ||||||||||
| Proposed Solution | Currently update.database.script duplicates actual update.database methods reimplementing them, this makes more difficult to maintain code because any change in update.database should be also ported to update.datbase. These methods should be refactored to be maintained in a single place. | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-01-30 12:59 | alostale | New Issue | |
| 2015-01-30 12:59 | alostale | Assigned To | => alostale |
| 2015-01-30 12:59 | alostale | Modules | => Core |
| 2015-01-30 12:59 | alostale | Triggers an Emergency Pack | => No |
| 2015-03-18 15:07 | alostale | Status | new => scheduled |
| 2015-03-18 15:08 | alostale | Review Assigned To | => AugustoMauch |
| 2015-03-18 15:09 | alostale | Relationship added | related to 0029270 |
| 2017-03-31 14:36 | alostale | Status | scheduled => acknowledged |
| 2017-04-10 14:33 | alostale | Assigned To | alostale => platform |
| 2022-02-01 08:09 | alostale | Assigned To | platform => Triage Platform Base |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |