Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029761Openbravo ERPA. Platformpublic2015-03-06 11:182015-05-04 13:32
Reportereduardo_Argal 
Assigned Toeduardo_Argal 
PriorityurgentSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR15Q1.4Fixed in Version3.0PR15Q1.4 
Merge Request Status
Review Assigned Toumartirena
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029761: getCallableResult broken when using null parameters
DescriptiongetCallableResult method for class RDBMSIndependent, is replacing null values for parameters with the String "Test", resulting in unexpected behavior of the procedure call.
Steps To ReproduceUsing postgres database
Install Picking List module
Create a sales order and add a line with a product. Process it.
Click on generate picking.
Realize that not Available Stock error message is thrown
Root cause problem: M_GET_STOCK_PARAM function is being called using "Test" as parameter value for those which should be null.
Proposed Solution
Additional Information
TagsApproved
Relationships
blocks defect 00291683.0PR15Q2 closed eduardo_Argal getCallableResult broken when using null parameters 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-05-04 12:30umartirenaTypedefect => backport
2015-05-04 12:30umartirenaTarget Version3.0PR15Q2 => 3.0PR15Q1.4
2015-05-04 13:31hgbotCheckin
2015-05-04 13:31hgbotNote Added: 0076936
2015-05-04 13:31hgbotStatusscheduled => resolved
2015-05-04 13:31hgbotResolutionopen => fixed
2015-05-04 13:31hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/95f9c5ce620700a9fd621efaca2b00f0c45432d9 [^] => http://code.openbravo.com/erp/backports/3.0PR15Q1.4/rev/f448061a64cf04b82600f3f92c6b85a1f7dccfcb [^]
2015-05-04 13:32umartirenaNote Added: 0076937
2015-05-04 13:32umartirenaStatusresolved => closed
2015-05-04 13:32umartirenaFixed in Version => 3.0PR15Q1.4
2015-05-04 13:32umartirenaTag Attached: Approved

Notes
(0076936)
hgbot   
2015-05-04 13:31   
Repository: erp/backports/3.0PR15Q1.4
Changeset: f448061a64cf04b82600f3f92c6b85a1f7dccfcb
Author: Unai Martirena <unai.martirena <at> openbravo.com>
Date: Mon May 04 13:29:55 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q1.4/rev/f448061a64cf04b82600f3f92c6b85a1f7dccfcb [^]

Fixes bug 29761: getCallableResult broken when using null parameters.

Removed TEST value for default

---
M src-core/src/org/openbravo/database/RDBMSIndependent.java
---
(0076937)
umartirena   
2015-05-04 13:32   
Code Review + Testing OK