Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0000507

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

backport

[Openbravo ERP] Z. Others

minor

always

2008-06-02 11:37

2009-01-27 17:15

Reporter

egoitz

View Status

public

Assigned To

Hennadzi

Priority

normal

Resolution

fixed

Fixed in Version

2.35

Status

closed

Fix in branch

2.3x

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

PostgreSQL

Java version

OS Version

Database version

8.2

Ant version

Product Version

pi

SCM revision

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

0000507: m_get_offers_name function does not work on postgreSQL

Description

The m_get_offers_name function does not work on postgresql

Steps To Reproduce

I tried to use this function defined to do a develop.
I defined a new Price adjustemnt and assigned a product to this price adjustment. I execute the next order and it didn't return nothing.
select m_get_offers_name(to_date(now()),anypartner_id,the_id_of_the_productassigned) from dual;

Proposed Solution

The problem is that the next variable is initialized with NULL and then a String is concatened to this variable, and it is not possible in postgre.

v_Names VARCHAR(10000) := NULL;
...
...
    LOOP
      IF v_Names IS NOT NULL THEN
        v_Names := v_Names||'
';
      END IF;
      v_Names := v_Names||Cur_Offer.name;
    END LOOP;

To solve it you have to use an empty string instead of NULL and the compare the v_Names with an empty string instead of compare with NULL.
Posible solution:

v_Names VARCHAR(10000) := '';
...
...
IF v_Names <> '' THEN
        v_Names := v_Names||'<b r/>& nbsp;';
      END IF;
      v_Names := v_Names||Cur_Offer.name;
    END LOOP;

Tags

No tags attached.

Relationships [ Relation Graph ] [ Dependency Graph ]

blocks

defect

pi

closed

m_get_offers_name function does not work on postgreSQL

Notes
(0010582) svnbot (viewer) 2008-11-24 17:47	Repository: openbravo Revision: 10485 Author: hennadzi Date: 2008-11-24 17:46:40 +0100 (Mon, 24 Nov 2008) bug fixed 0000507: m_get_offers_name function does not work on postgreSQL --- U branches/r2.3x/database/model/functions/M_GET_OFFERS_NAME.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=10485&sc=1 [^]

(0012694) rafaroda (viewer) 2009-01-27 17:12 edited on: 2009-01-27 17:15	To test the fix within Openbravo ERP using PostgreSQL: 1) Create a price adjustment in 'Master Data Management \|\| Pricing \|\| Price Adjustments \|\| Adjustments' with values: * Starting date = 01-01-2000 * Discount % = 50 * Min Quantity = 499 * Business Partner = All Selected * Product = All Selected 2) Move to Business Partner tab and select one business partner 3) Move to Product tab and select one product 4) Create a new Sales or Purchase Order for the business partner of the price adjustment 5) Create one line for the product of the price adjustment 6) Save this line 7) Change quantity to 500. Unit Price should have half amount 8) Go to the header of the order and complete it 9) Create a new order for the same business partner 10) Click on Copy Lines and select the product of the previous order Notice that in Copy Lines pop up the name of the offer appears in Offer column.

Issue History
Date Modified	Username	Field	Change
2008-06-02 11:37	cromero	New Issue
2008-06-02 11:37	cromero	Assigned To	=> cromero
2008-06-02 11:37	cromero	Status	new => scheduled
2008-06-03 10:50	cromero	Assigned To	cromero => egoitz
2008-06-03 10:50	cromero	Steps to Reproduce Updated
2008-11-13 22:47	rafaroda	Assigned To	egoitz => Hennadzi
2008-11-24 17:47	svnbot	Checkin
2008-11-24 17:47	svnbot	Note Added: 0010582
2008-11-24 17:47	svnbot	Status	scheduled => resolved
2008-11-24 17:47	svnbot	Resolution	open => fixed
2008-11-24 17:47	svnbot	svn_revision	=> 10485
2009-01-27 17:12	rafaroda	Note Added: 0012694
2009-01-27 17:15	rafaroda	Note Edited: 0012694
2009-01-27 17:15	psarobe	Regression testing	=> No
2009-01-27 17:15	psarobe	Status	resolved => closed
2009-01-27 17:15	psarobe	Fixed in Version	2.35MP10 => 2.35

Copyright © 2000 - 2009 MantisBT Group