Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004853 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 01. General setup | major | always | 2008-09-08 14:26 | 2009-04-21 11:05 | |||
| Reporter | rafaroda | View Status | public | |||||
| Assigned To | rafaroda | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 7019 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.5 | |||
| OS Version | Ubuntu 7.10 | Database version | 8.3 | Ant version | 1.7 | |||
| Product Version | pi | SCM revision | 7008 | |||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0004853: 'C_Currency_Convert' function does not work in PostgreSQL | |||||||
| Description | Due 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 Reproduce | 1) 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0008920) svnbot (viewer) 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 (viewer) 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 [^] |
|
Notes |
|
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 | OBNetwork customer | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |