Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011040Openbravo ERPY. DBSourceManagerpublic2009-10-19 17:112009-10-23 00:01
Reportershuehner 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011040: dbsm does not sort index names consistently
Descriptiondbsm does not sort index names in java leading to different order of indexes on export.database depending on db system configuration. This can/will lead to db inconsistency as detected in this hudson build:

http://builds.openbravo.com/job/erp_stable_2.40-pgsql-db-full-consistency-test/110/console [^]
Steps To Reproduce
Proposed SolutionUse java sort for index names instead of db-system order by also fox index names and not only for i.e. table and foreign key names
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-10-19 17:11shuehnerNew Issue
2009-10-19 17:11shuehnerAssigned To => marvintm
2009-10-19 17:11shuehnerOBNetwork customer => No
2009-10-19 17:12shuehnerIssue Monitored: shuehner
2009-10-19 18:18hgbotCheckin
2009-10-19 18:18hgbotNote Added: 0021185
2009-10-19 18:18hgbotStatusnew => resolved
2009-10-19 18:18hgbotResolutionopen => fixed
2009-10-19 18:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/0f55d4d4f0cc779a74e5ed52abb7ff3b12946b51 [^]
2009-10-19 18:27hgbotCheckin
2009-10-19 18:27hgbotNote Added: 0021186
2009-10-19 18:27hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/stable/2.40/rev/0f55d4d4f0cc779a74e5ed52abb7ff3b12946b51 [^] => http://code.openbravo.com/erp/devel/pi/rev/4b17055c5b6085d12ced8a733b2f5ead76e3fee9 [^]
2009-10-19 18:27hgbotCheckin
2009-10-19 18:27hgbotNote Added: 0021187
2009-10-19 18:27hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/4b17055c5b6085d12ced8a733b2f5ead76e3fee9 [^] => http://code.openbravo.com/erp/devel/pi/rev/603b72820ebeee039869e39f8f9fd51fed76dbf5 [^]
2009-10-22 11:21plujanStatusresolved => closed
2009-10-23 00:01anonymoussf_bug_id0 => 2884268

Notes
(0021185)
hgbot   
2009-10-19 18:18   
Repository: erp/stable/2.40
Changeset: 0f55d4d4f0cc779a74e5ed52abb7ff3b12946b51
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Oct 19 18:18:40 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/0f55d4d4f0cc779a74e5ed52abb7ff3b12946b51 [^]

Fixed issue 11040. Indices will now be sorted before exporting them.

---
M src-db/database/lib/dbsourcemanager.jar
M src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml
---
(0021186)
hgbot   
2009-10-19 18:27   
Repository: erp/devel/pi
Changeset: 4b17055c5b6085d12ced8a733b2f5ead76e3fee9
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Oct 19 17:32:03 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/4b17055c5b6085d12ced8a733b2f5ead76e3fee9 [^]

Fixed issue 11040. OnCreateDefaults should be removed when not in the XML files, on update.database.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0021187)
hgbot   
2009-10-19 18:27   
Repository: erp/devel/pi
Changeset: 603b72820ebeee039869e39f8f9fd51fed76dbf5
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Oct 19 18:25:01 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/603b72820ebeee039869e39f8f9fd51fed76dbf5 [^]

Fixed issue 11040. Indices will now be sorted before exporting them.

---
M src-db/database/lib/dbsourcemanager.jar
M src-db/database/model/tables/MA_SEQUENCEPRODUCT.xml
---