Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0010481 | Openbravo ERP | A. Platform | public | 2009-09-03 21:01 | 2009-09-03 21:01 |
| Reporter | iciordia | ||||
| Assigned To | iciordia | ||||
| Priority | normal | Severity | major | Reproducibility | N/A |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | any | |
| Product Version | 2.50 | ||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0010481: Text columns should not have physical limitation | ||||
| Description | In Openbravo 2.50 and previous text columns are limited in lenght depending on column type (eg. name usually limited to 60, description to 255, etc.). Modules (templates) can modify this limit but there is a risk of failure in pl/sql code using those columns (if the column is read in a variable limited in size the read might not fit raising an error). It should be faced in similar way to numbers . Numbers are defined "generic" in the database -without specific size and precision- and later configured to something more specific in Application Dictionary (according to references, currency precision, etc.). If that definition changes in AD there is no risk of failure. Since oracle database has a limitation of 4000 characters for varchar2 datatype and there is no "generic" definition of varchar2 columns (without specifying the size), all text columns should be defined as VARCHAR2(4000) in the db model. Business logic should operate these columsn without size limitation. | ||||
| Steps To Reproduce | |||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2009-09-03 21:01 | iciordia | New Issue | |||
| 2009-09-03 21:01 | iciordia | Assigned To | => iciordia | ||
| 2009-09-04 15:01 | villind | Issue Monitored: villind | |||
| There are no notes attached to this issue. |