Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010481
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. PlatformmajorN/A2009-09-03 21:012009-09-03 21:01
ReportericiordiaView Statuspublic 
Assigned Toiciordia 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava versionany
OS VersionanyDatabase versionanyAnt versionany
Product Version2.50SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010481: Text columns should not have physical limitation

DescriptionIn 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker