Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0012577Openbravo ERPY. DBSourceManagerpublic2010-03-05 15:122018-04-08 17:01
shuehner 
platform 
normalmajorhave not tried
scheduledopen 
5
pi 
 
Core
No
0012577: dbsourcemanager cannot to an ad_column.name update of two columns with intermediate conflicting values like A->B,B->C
When the following situation is in the DB (unique constraint on ad_column.name)

first row with ad_column.name = A
second row with ad_column.name = B

then in on update.database both columns as renamed at once so

first A->B
then B->C

and second row has a higher uuid then the first row

then the update will fails as both renamings are applied individually and after the first there will be two rows with value B. which contradicts the unique constraint
see this inc-build failing:
http://builds.openbravo.com/job/erp_devel_pi-inc-pgsql/1675/console [^]

after this commit:

https://code.openbravo.com/erp/devel/pi/rev/45b8e0cdb556 [^]
No tags attached.
related to defect 00279183.0PR15Q1 closed AugustoMauch After PR14Q2.X and new tree infrastructure, window User Defined Accounting Report Setup window has lost the tree view 
Issue History
2010-03-05 15:12shuehnerNew Issue
2010-03-05 15:12shuehnerAssigned To => marvintm
2010-03-05 15:15shuehnerSummarydbsourcemanager cannot to an ad_column.name update ot two columns with intermediate conflicts, A->B,B->C => dbsourcemanager cannot to an ad_column.name update of two columns with intermediate conflicting values like A->B,B->C
2010-03-08 15:58alostaleStatusnew => scheduled
2010-03-08 15:58alostalefix_in_branch => pi
2012-01-30 15:24marvintmNote Added: 0044703
2012-01-30 15:24marvintmTypedefect => design defect
2012-01-30 15:24marvintmfix_in_branchpi =>
2012-09-24 23:36AugustoMauchNote Added: 0052501
2012-09-24 23:36AugustoMauchPriorityurgent => normal
2014-10-21 12:32AugustoMauchRelationship addedrelated to 0027918
2018-04-08 17:01shuehnerAssigned Tomarvintm => platform

Notes
(0044703)
marvintm   
2012-01-30 15:24   
This problem is real. However, it would require a significant change either in the way constraints are handled in dbsourcemanager (with a big performance penalty), or in the way data changes are executed, for it to be fixed, with a relevant risk of producing regressions.

Therefore, it is being changed to a design defect.
(0052501)
AugustoMauch   
2012-09-24 23:36   
Effort: 10
Impact: low
Plan: mid