Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0000370Openbravo ERPY. DBSourceManagerpublic2008-05-19 17:342009-05-21 16:37
marvintm 
marvintm 
highmajoralways
closedfixed 
5
 
 
Core
No
0000370: Update process trims the body of functions and triggers when comparing
When 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.
Do 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.
dbsm_migrate
blocks defect 0000366 closed marvintm Update process trims the body of functions and triggers when comparing 
Issue History
2008-05-19 17:34marvintmNew Issue
2008-05-19 17:34marvintmAssigned To => marvintm
2008-05-19 17:34marvintmStatusnew => scheduled
2008-05-19 18:17marvintmStatusscheduled => resolved
2008-05-19 18:17marvintmFixed in Version => 0.7x
2008-05-19 18:17marvintmResolutionopen => fixed
2008-05-19 18:17marvintmNote Added: 0000244
2008-12-18 12:39jpabloaeTag Attached: dbsm_migrate
2008-12-18 12:41jpabloaeProject@4@ => Openbravo ERP
2008-12-18 12:41jpabloaeCategory => Y. DBSourceManager
2009-05-21 16:37psarobeStatusresolved => closed

Notes
(0000244)
marvintm   
2008-05-19 18:17   
Now DBSourceManager doesn't trim the PL/SQL code when comparing in a update.database process.