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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0030114
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformcriticalalways2015-06-02 09:292015-06-15 10:08
ReportervmromanosView Statuspublic 
Assigned Tocaristu 
PriorityimmediateResolutionfixedFixed in Version3.0PR15Q1.5
StatusclosedFix in branchFixed in SCM revision6e1388c1e422
ProjectionnoneETAnoneTarget Version3.0PR15Q1.5
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase version9.3Ant version
Product VersionSCM revision 
Review Assigned Toalostale
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0030114: Critical bug with decimals only in PostgreSQL 9.3

DescriptionIt seems that the way decimal numbers are managed by PostgreSQL 9.3 is different from PostgreSQL 9.1, and may create important issues in several flows.

The same query [select to_number('1.53')] returns different results depending on the PG version:

PG 9.1: 1.53
PG 9.3: 153
Steps To ReproduceLogin as Openbravo admin

Go to Sales Order and create a new record:
  Org: España Norte
  BP: Alimentos y Supermercados
  Invoice Terms: Immediate
Go to Lines and create a new record:
  Quantity: 10
  Product: Agua sin gas
 Verify unit price = 1.53
Book the sales order

Go to Sales Invoice and create a new record:
  Org: España Norte
  BP: Alimentos y SuperMercados
Press Create Lines From:
  In the sales order select the previously created
  In the grid select the 2 order lines
  Press OK
Go to lines and check that:
  the unit price is 153, when it should be 1.53
  the line net amount is 1530, when it should be 15.30
TagsApproved
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0030069 closedcaristu Critical bug with decimals only in PostgreSQL 9.3 

-  Notes
(0078189)
hgbot (developer)
2015-06-10 17:06

 Repository: erp/backports/3.0PR15Q1.5
Changeset: 6e1388c1e4224b9fd92a691cb3010d40ea0d4358
Author: Carlos Aristu <carlos.aristu <at> openbravo.com>
Date: Wed Jun 10 10:32:27 2015 +0200
URL: http://code.openbravo.com/erp/backports/3.0PR15Q1.5/rev/6e1388c1e4224b9fd92a691cb3010d40ea0d4358 [^]

Fixes issue 30114: Critical bug with decimals only in PostgreSQL 9.3

A new build validation has been added. This way, when executing update.database the result returned by the to_number() procedure is evaluated.
n case it does not return the expected result, the task will fail, showing a message with the link to the documentation.

---
A src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DatabaseDecimalNumberCheck.class
A src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/DatabaseDecimalNumberCheckData.class
A src-util/buildvalidation/src/org/openbravo/buildvalidation/DatabaseDecimalNumberCheck.java
A src-util/buildvalidation/src/org/openbravo/buildvalidation/DatabaseDecimalNumberCheck_data.xsql
---
(0078282)
alostale (manager)
2015-06-15 10:07

 code reviewed + tested with PG 9.3 lc_numeric 'es_ES'

- Issue History
Date Modified Username Field Change
2015-06-05 11:43 alostale Type defect => backport
2015-06-05 11:43 alostale Target Version => 3.0PR15Q1.5
2015-06-10 09:25 dmitry_mezentsev Tag Attached: Approved
2015-06-10 10:33 caristu Issue Monitored: alostale
2015-06-10 17:06 hgbot Checkin
2015-06-10 17:06 hgbot Note Added: 0078189
2015-06-10 17:07 hgbot Status scheduled => resolved
2015-06-10 17:07 hgbot Resolution open => fixed
2015-06-10 17:07 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q1.5/rev/6e1388c1e4224b9fd92a691cb3010d40ea0d4358 [^]
2015-06-15 10:07 alostale Note Added: 0078282
2015-06-15 10:07 alostale Status resolved => closed
2015-06-15 10:08 alostale Fixed in Version => 3.0PR15Q1.5

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker