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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0000366
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajoralways2008-05-19 17:142009-03-18 11:02
ReportermarvintmView Statuspublic 
Assigned Tomarvintm 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0000366: Update process trims the body of functions and triggers when comparing

DescriptionWhen performing and update.database, DBSourceManager loads the database model from the database, and compares it with the model in the XML files.

When comparing functions and triggers, the bodies are compared. However, instead of comparing them directly, they are first trimmed and then compared.

This is wrong, as functions and triggers that are different (for example, functions that have additional blank spaces at the begining or the end of their body) would instead appear to be equal, and therefore the update.database process would not update them in the database.
Steps To ReproduceDo a create.database. Then modify the XML file of a function or trigger, adding blank spaces to the end of the body. Then do update.database. The update process should detect the modification you've done and update the function or trigger, but instead, it will do nothing.
Tagsdbsm_migrate
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
depends on backport 0000370 closedmarvintm Update process trims the body of functions and triggers when comparing 

-  Notes
(0000245)
marvintm (developer)
2008-05-19 18:17

Now DBSourceManager doesn't trim the PL/SQL code when comparing in a update.database process.

- Issue History
Date Modified Username Field Change
2008-05-19 17:14 marvintm New Issue
2008-05-19 17:14 marvintm Assigned To => marvintm
2008-05-19 17:15 marvintm Status new => acknowledged
2008-05-19 17:24 marvintm Status acknowledged => scheduled
2008-05-19 17:34 marvintm Status scheduled => feedback
2008-05-19 17:34 marvintm Status feedback => scheduled
2008-05-19 18:17 marvintm Status scheduled => resolved
2008-05-19 18:17 marvintm Resolution open => fixed
2008-05-19 18:17 marvintm Note Added: 0000245
2008-11-26 14:11 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:41 jpabloae Category => Y. DBSourceManager
2009-03-18 11:02 anonymous sf_bug_id 0 => 2691300


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker