Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021849Openbravo ERPA. Platformpublic2012-10-03 16:372012-10-30 09:17
ReporterioritzCia 
Assigned ToAugustoMauch 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP17 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021849: Export.sampledata reorganizes properties that have same column position.
DescriptionExport.sampledata reorganizes properties of the entities that have same column position value.
Steps To Reproduce- Execute ant export.sampledata and see that some properties are reorganized.

For example:

diff --git a/referencedata/sampledata/F_B_International_Group.xml b/referencedata/sampledata/F_B_International_Group.xml
--- a/referencedata/sampledata/F_B_International_Group.xml
+++ b/referencedata/sampledata/F_B_International_Group.xml
@@ -28193,9 +28193,9 @@
     <description xsi:nil="true"/>
     <aprmModifPaymentINPlan>false</aprmModifPaymentINPlan>
     <aprmModifPaymentOUTPlan>false</aprmModifPaymentOUTPlan>
- <daysOverdue>0</daysOverdue>
     <lastPaymentDate>2011-12-05T00:00:00.0Z</lastPaymentDate>
     <numberOfPayments>1</numberOfPayments>
+ <daysOverdue>0</daysOverdue>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="00DFF28676AE4CE49B08790361D86AB4">
     <id>00DFF28676AE4CE49B08790361D86AB4</id>
@@ -28216,9 +28216,9 @@
     <description xsi:nil="true"/>
     <aprmModifPaymentINPlan>false</aprmModifPaymentINPlan>
     <aprmModifPaymentOUTPlan>false</aprmModifPaymentOUTPlan>
- <daysOverdue>22</daysOverdue>
     <lastPaymentDate>2012-08-21T00:00:00.0Z</lastPaymentDate>
     <numberOfPayments>1</numberOfPayments>
+ <daysOverdue>22</daysOverdue>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="01EB58DB89354C88956D2FB821353D12">
     <id>01EB58DB89354C88956D2FB821353D12</id>
@@ -28239,9 +28239,9 @@
     <description xsi:nil="true"/>
     <aprmModifPaymentINPlan>false</aprmModifPaymentINPlan>
     <aprmModifPaymentOUTPlan>false</aprmModifPaymentOUTPlan>
- <daysOverdue>0</daysOverdue>
     <lastPaymentDate xsi:nil="true"/>
     <numberOfPayments>0</numberOfPayments>
+ <daysOverdue>0</daysOverdue>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="02DADE02A2E74E9EBE197711615E3093">
     <id>02DADE02A2E74E9EBE197711615E3093</id>

And so on.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff issue21849.diff (461) 2012-10-04 17:18
https://issues.openbravo.com/file_download.php?file_id=5638&type=bug
Issue History
Date ModifiedUsernameFieldChange
2012-10-03 16:37ioritzCiaNew Issue
2012-10-03 16:37ioritzCiaAssigned To => AugustoMauch
2012-10-03 16:37ioritzCiaModules => Core
2012-10-04 17:18AugustoMauchFile Added: issue21849.diff
2012-10-04 17:19AugustoMauchStatusnew => scheduled
2012-10-04 17:19AugustoMauchfix_in_branch => pi
2012-10-08 14:03AugustoMauchIssue Monitored: dbaz
2012-10-08 14:03AugustoMauchIssue End Monitor: dbaz
2012-10-08 14:04AugustoMauchIssue Monitored: marvintm
2012-10-08 14:04AugustoMauchReview Assigned To => marvintm
2012-10-08 14:04AugustoMauchfix_in_branchpi =>
2012-10-08 14:08hgbotCheckin
2012-10-08 14:08hgbotNote Added: 0053113
2012-10-08 14:08hgbotStatusscheduled => resolved
2012-10-08 14:08hgbotResolutionopen => fixed
2012-10-08 14:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e7effc11e1bea22ce60f048c3c7fbf6442010189 [^]
2012-10-11 07:50hudsonbotCheckin
2012-10-11 07:50hudsonbotNote Added: 0053260
2012-10-30 09:17alostaleReview Assigned Tomarvintm => alostale
2012-10-30 09:17alostaleNote Added: 0053783
2012-10-30 09:17alostaleStatusresolved => closed
2012-10-30 09:17alostaleFixed in Version => 3.0MP17

Notes
(0053113)
hgbot   
2012-10-08 14:08   
Repository: erp/devel/pi
Changeset: e7effc11e1bea22ce60f048c3c7fbf6442010189
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Mon Oct 08 14:03:36 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/e7effc11e1bea22ce60f048c3c7fbf6442010189 [^]

Fixes issue 21849: Column with same position are ordered by name

When all the database columns are listed in the readColumns method of ModelProvider, they were ordered by its position. If several columns had the same position, its order was not deterministic. Now the name of the column has been added to the order clause.

---
M src/org/openbravo/base/model/ModelProvider.java
---
(0053260)
hudsonbot   
2012-10-11 07:50   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/63dfc135f2a1 [^]

Maturity status: Test
(0053783)
alostale   
2012-10-30 09:17   
Code reviewed and tested on pi@b2e90dcc4dc7