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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0034115
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2016-09-28 11:142019-07-30 15:17
ReporterAugustoMauchView Statuspublic 
Assigned Toplatform 
PrioritynormalResolutionduplicateFixed 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

0034115: ad_db_modified does not take into account check constraints

DescriptionThe ad_db_modified function checks if the database has local changes. The problem is that it is not detecting changes done on check constraints. If a check constraint is added/modified/deleted, invoking ad_db_modified will return 'N', even though there are indeed local changes in the database.
Steps To Reproduce- Run update.database to make sure there are no local changes.
- Check it executing this in the database: SELECT AD_DB_MODIFIED('N') FROM DUAL. It will return 'N' (this is OK)
- Remove a check constraint, for instance: ALTER TABLE c_order DROP CONSTRAINT c_order_isactive_check;
- Run again the function that checks if there are local changes: SELECT AD_DB_MODIFIED('N') FROM DUAL. It will return 'N' (this is WRONG, the database has local changes).
- Remove a foreign key, for instance: ALTER TABLE c_order DROP CONSTRAINT c_order_ad_client;
- Run again the function that checks if there are local changes: SELECT AD_DB_MODIFIED('N') FROM DUAL. It will return 'Y' (this is OK)
Proposed SolutionI am not sure, as taking now into account the check constraints will modify the checksum, and false positives in the detection of local changes will occur.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
duplicate of defect 0028644 acknowledgedplatform update.database doesn't detect check constraint modifications as local changes 
related to defect 0035628 closedalostale ORA: sometimes update.database after install.source detects db changes 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2016-09-28 11:14 AugustoMauch New Issue
2016-09-28 11:14 AugustoMauch Assigned To => platform
2016-09-28 11:14 AugustoMauch Modules => Core
2016-09-28 11:14 AugustoMauch Triggers an Emergency Pack => No
2016-09-29 09:14 alostale Status new => acknowledged
2017-03-28 10:19 alostale Relationship added related to 0035628
2019-07-30 15:17 alostale Status acknowledged => scheduled
2019-07-30 15:17 alostale Relationship added duplicate of 0028644
2019-07-30 15:17 alostale Status scheduled => closed
2019-07-30 15:17 alostale Resolution open => duplicate


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker