Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] Y. DBSourceManagerminorhave not tried2015-01-30 12:592022-02-01 08:09
ReporteralostaleView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToAugustoMauch
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0028822: update.database.script is not reliable

Descriptionupdate.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 SolutionCurrently 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0029270 closedalostale prevent table recreation in update.database 

-  Notes
There are no notes attached to this issue.

- 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker