Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0013038Openbravo ERPY. DBSourceManagerpublic2010-04-19 14:332012-04-02 06:10
Reportershuehner 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version3.0MP10 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0013038: A LIKE operator in a view-definition is translated on export.db in postgresql from LIKE -> ~~
DescriptionAt least one view having a LIKE in its definition is changed on export.database on postgresql 8.4.3.

LIKE -> ~~

View definition is attached
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Filesxml APRM_RECONCILIATION_V.xml (2,777) 2010-04-19 14:34
https://issues.openbravo.com/file_download.php?file_id=2454&type=bug
Issue History
Date ModifiedUsernameFieldChange
2010-04-19 14:33shuehnerNew Issue
2010-04-19 14:33shuehnerAssigned To => marvintm
2010-04-19 14:34shuehnerFile Added: APRM_RECONCILIATION_V.xml
2010-04-19 16:11jpabloaeIssue Monitored: jpabloae
2010-04-26 08:33alostaleStatusnew => scheduled
2012-03-14 18:52hgbotCheckin
2012-03-14 18:52hgbotNote Added: 0046432
2012-03-14 18:52hgbotStatusscheduled => resolved
2012-03-14 18:52hgbotResolutionopen => fixed
2012-03-14 18:52hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7c1d4b08ba256afdcf45db6d536eae2744bfb457 [^]
2012-03-14 18:53hgbotCheckin
2012-03-14 18:53hgbotNote Added: 0046433
2012-03-14 18:53hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/7c1d4b08ba256afdcf45db6d536eae2744bfb457 [^] => http://code.openbravo.com/erp/devel/dbsm-main/rev/0330f997de004ee4623463e21fedd3cffb46ce35 [^]
2012-03-16 10:50alostaleNote Added: 0046505
2012-03-16 10:50alostaleStatusresolved => closed
2012-03-16 10:50alostaleFixed in Version => 3.0MP10
2012-04-02 06:10hudsonbotCheckin
2012-04-02 06:10hudsonbotNote Added: 0047143

Notes
(0046432)
hgbot   
2012-03-14 18:52   
Repository: erp/devel/pi
Changeset: 7c1d4b08ba256afdcf45db6d536eae2744bfb457
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Mar 14 18:52:21 2012 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/7c1d4b08ba256afdcf45db6d536eae2744bfb457 [^]

Fixed issue 13038. Added support for LIKE statement in views

---
M src-db/database/lib/dbsourcemanager.jar
---
(0046433)
hgbot   
2012-03-14 18:53   
Repository: erp/devel/dbsm-main
Changeset: 0330f997de004ee4623463e21fedd3cffb46ce35
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Mar 14 18:51:11 2012 +0100
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/0330f997de004ee4623463e21fedd3cffb46ce35 [^]

Fixed issue 13038. Added support for LIKE statement in views

---
M src/org/apache/ddlutils/platform/postgresql/PostgreSQLStandarization.java
---
(0046505)
alostale   
2012-03-16 10:50   
Code reviewed and verified on pi@d14e8752f4e6

Executed test:
-Using PostgreSQL 8.4.9: Create a new view with LIKE operator
-Export database
-Check it is properly kept
(0047143)
hudsonbot   
2012-04-02 06:10   
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/7814864461ac [^]

Maturity status: Test