0019092: DAL forces column length check when saving

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0019092

Openbravo ERP

A. Platform

public

2011-11-17 12:01

2022-02-01 08:08

Reporter

alostale

Assigned To

Triage Platform Base

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

acknowledged

Resolution

open

Platform

OS Version

Product Version

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

Summary

0019092: DAL forces column length check when saving

Description

DAL checks column length before saving, rasing an error in case length tried to be saved is longer than AD defined one. This is OK in most cases, to prevent a error in DB.

The problem is in text/clob DB types which don't have DB limitation. For these types of columns current still makes sense in some cases but for other ones there should not be validation at all.

Steps To Reproduce

See 0019090

Proposed Solution

Two possible solutions, to be discussed:
1. Do not perform DAL check in case the column length is not defined (currently it is mandatory, so it should be made not mandatory) or when a non valid value (0 or -1) is set.
2. Create a new reference that is not checked

Additional Information