0002486: Saving records in Payment Status Management Lines

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0002486

Openbravo ERP

09. Financial management

public

2008-01-09 10:18

2008-07-04 19:05

Reporter

user71

Assigned To

cromero

Priority

normal

Severity

minor

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

2.40beta

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

0002486: Saving records in Payment Status Management Lines

Description

Merely clicking the 'Save' button in :

Financial Management->Receivables & Payables->Transactions->Payment Status Management->Header->Lines

will produce error :

"ERROR : COALESCE types character and integer cannot be matched'

I found the offending codes in database trigger "c_dpmline_chk_restriction_trg" line 15:

... OR(COALESCE(OLD.STATUS_FROM, 0) <> COALESCE(NEW.STATUS_FROM, 0)) OR(COALESCE(OLD.STATUS_TO, 0) <> COALESCE(NEW.STATUS_TO, 0)))) THEN

Changing it to

... OR(COALESCE(OLD.STATUS_FROM, '') <> COALESCE(NEW.STATUS_FROM, '')) OR(COALESCE(OLD.STATUS_TO, '') <> COALESCE(NEW.STATUS_TO, '')))) THEN

Seems to solve the problem. Is this correct?, please advice.

Openbravo 2.35
Debian Etch
Postgresql 8.2/lenny
Tomcat5.5
Java 1.5

Steps To Reproduce

Proposed Solution

Additional Information