Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0022436 | Openbravo ERP | 09. Financial management | public | 2012-11-30 11:21 | 2012-12-06 15:12 | |||||||
| Reporter | shuehner | |||||||||||
| Assigned To | caristu | |||||||||||
| Priority | immediate | Severity | major | Reproducibility | have not tried | |||||||
| Status | closed | Resolution | fixed | |||||||||
| Platform | OS | 5 | OS Version | |||||||||
| Product Version | ||||||||||||
| Target Version | 3.0MP18 | Fixed in Version | 3.0MP18 | |||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | jonalegriaesarte | |||||||||||
| OBNetwork customer | No | |||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | ||||||||||||
| Regression level | Production - Confirmed Stable | |||||||||||
| Regression date | 2012-11-27 | |||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | http://code.openbravo.com/erp/devel/pi/rev/b43e48d603a93ef7bc008b7121376c15d98a3ced [^] | |||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0022436: Newly added check contraints don't follow modularity rules | |||||||||||
| Description | The newly added check constraint from issue 21590 (2nd cset) do not follow modularity naming rules as they should all three start with the tablename to avoid naming collisions. BPNAME_CHK REFERENCE_CHK TRANSACTIONDATE_CHK Note: Technically that will be an api-change as new check constraints are added for existing columns. But functionally no problem as in reality only the name of the constraint changes and not change in their content. | |||||||||||
| Steps To Reproduce | Run export.database and check export warnings. +++++++++++++++++++++++++++++++++++++++++++++++++++ Warnings for Validation type: INCORRECT_CHECK_NAME +++++++++++++++++++++++++++++++++++++++++++++++++++ Table FIN_MATCHING_ALGORITHM has check constraint key named BPNAME_CHK, which does not starts by module's DBPrefix. Table FIN_MATCHING_ALGORITHM has check constraint key named REFERENCE_CHK, which does not starts by module's DBPrefix. Table FIN_MATCHING_ALGORITHM has check constraint key named TRANSACTIONDATE_CHK, which does not starts by module's DBPrefix. | |||||||||||
| Proposed Solution | Rename the check constraints. | |||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| Issue History | ||||||||||||
| Date Modified | Username | Field | Change | |||||||||
| 2012-11-30 11:21 | shuehner | New Issue | ||||||||||
| 2012-11-30 11:21 | shuehner | Assigned To | => dmiguelez | |||||||||
| 2012-11-30 11:21 | shuehner | Modules | => Core | |||||||||
| 2012-11-30 11:21 | shuehner | OBNetwork customer | => No | |||||||||
| 2012-11-30 11:21 | shuehner | Relationship added | related to 0021590 | |||||||||
| 2012-11-30 11:24 | shuehner | Regression level | => Production - Confirmed Stable | |||||||||
| 2012-11-30 11:24 | shuehner | Regression introduced by commit | => http://code.openbravo.com/erp/devel/pi/rev/b43e48d603a93ef7bc008b7121376c15d98a3ced [^] | |||||||||
| 2012-11-30 13:29 | shuehner | Regression date | => 2012-11-27 | |||||||||
| 2012-12-04 12:49 | jonalegriaesarte | Assigned To | dmiguelez => caristu | |||||||||
| 2012-12-04 16:20 | hgbot | Checkin | ||||||||||
| 2012-12-04 16:20 | hgbot | Note Added: 0054706 | ||||||||||
| 2012-12-04 16:20 | hgbot | Status | new => resolved | |||||||||
| 2012-12-04 16:20 | hgbot | Resolution | open => fixed | |||||||||
| 2012-12-04 16:20 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/ebca3ab5ca867ddf82aa21fc18e0c2ff34cc94e5 [^] | |||||||||
| 2012-12-05 09:47 | jonalegriaesarte | Review Assigned To | => jonalegriaesarte | |||||||||
| 2012-12-05 09:47 | jonalegriaesarte | Note Added: 0054716 | ||||||||||
| 2012-12-05 09:47 | jonalegriaesarte | Status | resolved => closed | |||||||||
| 2012-12-05 09:47 | jonalegriaesarte | Fixed in Version | => 3.0MP18 | |||||||||
| 2012-12-06 15:12 | hudsonbot | Checkin | ||||||||||
| 2012-12-06 15:12 | hudsonbot | Note Added: 0054751 | ||||||||||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||