Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0014768Openbravo ERPA. Platformpublic2010-10-05 17:582012-03-02 15:36
Reporterchristiancorrodi 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40 
Target VersionFixed in Version3.0MP9 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0014768: prescript-PostgreSql.sql: to_number(integer) function always returning null
DescriptionThe to_number(integer) function defined in src-db/database/model/prescript-PostgreSql.sql always returns null.
Steps To Reproduce
Proposed SolutionCREATE OR REPLACE FUNCTION to_number(integer)
  RETURNS "numeric" AS
$BODY$
BEGIN
RETURN cast($1 as numeric);
EXCEPTION
  WHEN OTHERS THEN
    RETURN NULL;
END;
$BODY$
  LANGUAGE 'plpgsql' IMMUTABLE;
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-10-05 17:58christiancorrodiNew Issue
2010-10-05 17:58christiancorrodiAssigned To => alostale
2010-10-11 09:05alostalePrioritynormal => urgent
2010-10-11 09:06alostaleStatusnew => scheduled
2011-11-16 16:30alostaleAssigned Toalostale => marvintm
2012-02-13 12:10hgbotCheckin
2012-02-13 12:10hgbotNote Added: 0045067
2012-02-13 12:10hgbotStatusscheduled => resolved
2012-02-13 12:10hgbotResolutionopen => fixed
2012-02-13 12:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3082e66a5d16fbf4aec909798fa2bd8583c20549 [^]
2012-02-16 10:42AugustoMauchNote Added: 0045173
2012-02-16 10:42AugustoMauchStatusresolved => closed
2012-02-16 10:42AugustoMauchFixed in Version => 3.0MP9
2012-03-02 15:36hudsonbotCheckin
2012-03-02 15:36hudsonbotNote Added: 0045834

Notes
(0045067)
hgbot   
2012-02-13 12:10   
Repository: erp/devel/pi
Changeset: 3082e66a5d16fbf4aec909798fa2bd8583c20549
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Feb 13 12:02:18 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/3082e66a5d16fbf4aec909798fa2bd8583c20549 [^]

Fixed issue 14768. Fixed function definition

---
M src-db/database/model/prescript-PostgreSql.sql
---
(0045173)
AugustoMauch   
2012-02-16 10:42   
Close reviewed and verified
(0045834)
hudsonbot   
2012-03-02 15:36   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/544d64e0c159 [^]

Maturity status: Test