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

Description

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.

Steps To Reproduce

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.

Tags

dbsm_migrate

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

0000366

closed

marvintm

Update process trims the body of functions and triggers when comparing

Notes
(0000244) 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:34	marvintm	New Issue
2008-05-19 17:34	marvintm	Assigned To	=> marvintm
2008-05-19 17:34	marvintm	Status	new => scheduled
2008-05-19 18:17	marvintm	Status	scheduled => resolved
2008-05-19 18:17	marvintm	Fixed in Version	=> 0.7x
2008-05-19 18:17	marvintm	Resolution	open => fixed
2008-05-19 18:17	marvintm	Note Added: 0000244
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-05-21 16:37	psarobe	Status	resolved => closed