Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020647Openbravo ERP00. Application dictionarypublic2012-05-30 15:512012-06-12 11:17
Reporterjvazquez 
Assigned Tonaiaramartinez 
PrioritynormalSeveritytrivialReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version3.0MP13 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020647: Fin_payment_run_para has same constraint twice
DescriptionFin_payment_run_para has check constraint isactive equals 'Y' or 'N' twice.
Steps To ReproduceGo to https://code.openbravo.com/erp/devel/pi/file/97173c37d435/src-db/database/model/tables/FIN_PAYMENT_RUN_PARA.xml. [^]
Check lines 64 and 65:
64 <check name="FIN_PAYMENTRUNPARA_ACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
65 <check name="FIN_PAYMENTRUNPARA_VALCHK_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
Proposed SolutionRemove one constraint.
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0020646 new dmiguelez Some isactive columns lack check constraint 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-05-30 15:51jvazquezNew Issue
2012-05-30 15:51jvazquezAssigned To => alostale
2012-05-30 15:51jvazquezModules => Core
2012-05-30 15:52jvazquezRelationship addedrelated to 0020646
2012-05-31 15:14alostaleAssigned Toalostale => mirurita
2012-05-31 17:07naiaramartinezAssigned Tomirurita => naiaramartinez
2012-05-31 17:14naiaramartinezNote Added: 0049550
2012-05-31 17:14naiaramartinezStatusnew => scheduled
2012-05-31 17:14naiaramartinezfix_in_branch => pi
2012-06-12 11:15hgbotCheckin
2012-06-12 11:15hgbotNote Added: 0049746
2012-06-12 11:15hgbotStatusscheduled => resolved
2012-06-12 11:15hgbotResolutionopen => fixed
2012-06-12 11:15hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ca313a1ecdf869a1d64c410664563793affe0e2e [^]
2012-06-12 11:17miruritaNote Added: 0049750
2012-06-12 11:17miruritaStatusresolved => closed
2012-06-12 11:17miruritaFixed in Version => 3.0MP13

Notes
(0049550)
naiaramartinez   
2012-05-31 17:14   
Test Plan:
  Go to the database and check the definition of the fin_payment_run_para table.
  Notice that the check constraint for Active field, is only defined once.
(0049746)
hgbot   
2012-06-12 11:15   
Repository: erp/devel/pi
Changeset: ca313a1ecdf869a1d64c410664563793affe0e2e
Author: Naiara Martinez <naiara.martinez <at> openbravo.com>
Date: Thu May 31 17:10:45 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/ca313a1ecdf869a1d64c410664563793affe0e2e [^]

fixed bug 20647 Remove duplicated constraint

---
M src-db/database/model/tables/FIN_PAYMENT_RUN_PARA.xml
---
(0049750)
mirurita   
2012-06-12 11:17   
code review + testing OK

duplicate constraint removed.