Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021997Openbravo ERPA. Platformpublic2012-10-18 15:102012-10-30 07:54
Reportermarvintm 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0MP17 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0021997: Some queries in WAD may be problematic with PostgreSQL 9.2
DescriptionSome queries use wrong escaping when specifying strings. This can cause problems in PostgreSQL 9.2
Steps To ReproduceNotice that some queries contain '\n' in src-wad.
Proposed SolutionThe queries will be modified so that this doesn't happen.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-10-18 15:10marvintmNew Issue
2012-10-18 15:10marvintmAssigned To => marvintm
2012-10-18 15:10marvintmModules => Core
2012-10-18 15:14hgbotCheckin
2012-10-18 15:14hgbotNote Added: 0053464
2012-10-18 15:14hgbotStatusnew => resolved
2012-10-18 15:14hgbotResolutionopen => fixed
2012-10-18 15:14hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f4bd2575f14399615951ba915e67a0adf5a2f07d [^]
2012-10-22 13:27hudsonbotCheckin
2012-10-22 13:27hudsonbotNote Added: 0053526
2012-10-30 07:54alostaleReview Assigned To => alostale
2012-10-30 07:54alostaleNote Added: 0053776
2012-10-30 07:54alostaleStatusresolved => closed
2012-10-30 07:54alostaleFixed in Version => 3.0MP17

Notes
(0053464)
hgbot   
2012-10-18 15:14   
Repository: erp/devel/pi
Changeset: f4bd2575f14399615951ba915e67a0adf5a2f07d
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Thu Oct 18 15:14:19 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f4bd2575f14399615951ba915e67a0adf5a2f07d [^]

Fixed issue 21997. Modified queries so that they work with PostgreSQL 9.2

---
M src-wad/src/org/openbravo/wad/Fields_data.xsql
---
(0053526)
hudsonbot   
2012-10-22 13:27   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/483f2e6dc1af [^]

Maturity status: Test
(0053776)
alostale   
2012-10-30 07:54   
code reviewed and tested on pi@b2e90dcc4dc7