Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0020647 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 00. Application dictionary | trivial | always | 2012-05-30 15:51 | 2012-06-12 11:17 | |||
| Reporter | jvazquez | View Status | public | |||||
| Assigned To | naiaramartinez | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0MP13 | |||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | ca313a1ecdf8 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | pi | SCM revision | ||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0020647: Fin_payment_run_para has same constraint twice | |||||||
| Description | Fin_payment_run_para has check constraint isactive equals 'Y' or 'N' twice. | |||||||
| Steps To Reproduce | Go 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 Solution | Remove one constraint. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0049550) naiaramartinez (developer) 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 (developer) 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 (developer) 2012-06-12 11:17 |
code review + testing OK duplicate constraint removed. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2012-05-30 15:51 | jvazquez | New Issue | |
| 2012-05-30 15:51 | jvazquez | Assigned To | => alostale |
| 2012-05-30 15:51 | jvazquez | Modules | => Core |
| 2012-05-30 15:52 | jvazquez | Relationship added | related to 0020646 |
| 2012-05-31 15:14 | alostale | Assigned To | alostale => mirurita |
| 2012-05-31 17:07 | naiaramartinez | Assigned To | mirurita => naiaramartinez |
| 2012-05-31 17:14 | naiaramartinez | Note Added: 0049550 | |
| 2012-05-31 17:14 | naiaramartinez | Status | new => scheduled |
| 2012-05-31 17:14 | naiaramartinez | fix_in_branch | => pi |
| 2012-06-12 11:15 | hgbot | Checkin | |
| 2012-06-12 11:15 | hgbot | Note Added: 0049746 | |
| 2012-06-12 11:15 | hgbot | Status | scheduled => resolved |
| 2012-06-12 11:15 | hgbot | Resolution | open => fixed |
| 2012-06-12 11:15 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/ca313a1ecdf869a1d64c410664563793affe0e2e [^] |
| 2012-06-12 11:17 | mirurita | Note Added: 0049750 | |
| 2012-06-12 11:17 | mirurita | Status | resolved => closed |
| 2012-06-12 11:17 | mirurita | Fixed in Version | => 3.0MP13 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |