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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0004853
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupmajoralways2008-09-08 14:262009-04-21 11:05
ReporterrafarodaView Statuspublic 
Assigned Torafaroda 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision7019
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.5
OS VersionUbuntu 7.10Database version8.3Ant version1.7
Product VersionpiSCM revision7008 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0004853: 'C_Currency_Convert' function does not work in PostgreSQL

DescriptionDue to UUID changes, 'C_Currency_Convert' function [1] stopped to work in PostgreSQL.

[1] https://dev.openbravo.com/websvn/openbravo/trunk/src-db/database/model/functions/C_CURRENCY_CONVERT.xml [^]
Steps To Reproduce1) Logged as System Administrator, setup a conversion rates from USD to EUR and from EUR to USD: General Setup || Application || Conversion Rates
2) Execute: SELECT C_Currency_Convert(20000, '100', '102', TO_DATE('01-01-2008'), null, '1000000', '1000000') FROM DUAL;

Yo do not get any result.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0008920)
svnbot (reporter)
2008-09-08 15:16

Repository: openbravo
Revision: 7019
Author: rafaroda
Date: 2008-09-08 15:16:31 +0200 (Mon, 08 Sep 2008)

Fixes bug 0004853 Changed NUMBERs to VARCHARs inside C_CURRENCY_RATE.xml.

---
U trunk/src-db/database/model/functions/C_CURRENCY_RATE.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=7019&sc=1 [^]
(0008932)
rafaroda (developer)
2008-09-09 11:04

In fact, they had to be changed by VARCHAR(32): https://dev.openbravo.com/websvn/openbravo/trunk/src-db/database/model/functions/C_CURRENCY_RATE.xml?op=diff&rev=7069&sc=1 [^]

Correctly fixed in bug https://issues.openbravo.com/view.php?id=4863 [^]

- Issue History
Date Modified Username Field Change
2008-09-08 14:26 rafaroda New Issue
2008-09-08 14:26 rafaroda Assigned To => cromero
2008-09-08 14:26 rafaroda sf_bug_id 0 => 2100094
2008-09-08 14:26 rafaroda Regression testing => No
2008-09-08 14:49 rafaroda Proposed Solution updated
2008-09-08 14:54 rafaroda Assigned To cromero => rafaroda
2008-09-08 15:16 svnbot Checkin
2008-09-08 15:16 svnbot Note Added: 0008920
2008-09-08 15:16 svnbot Status new => resolved
2008-09-08 15:16 svnbot Resolution open => fixed
2008-09-08 15:16 svnbot svn_revision => 7019
2008-09-09 11:04 rafaroda Note Added: 0008932
2009-04-21 11:05 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker