Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0010481 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [Openbravo ERP] A. Platform | major | N/A | 2009-09-03 21:01 | 2009-09-03 21:01 | |||||||
| Reporter | iciordia | View Status | public | |||||||||
| Assigned To | iciordia | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | any | |||||||
| OS Version | any | Database version | any | Ant version | any | |||||||
| Product Version | 2.50 | 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 | 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. | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |