Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0034022Openbravo ERPY. DBSourceManagerpublic2016-09-19 19:212022-02-01 08:05
Reportercaristu 
Assigned ToTriage Platform Base 
PrioritynormalSeverityminorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
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
Summary0034022: PostgreSqlBuilder configuration for escaped characters is not correct
DescriptionPostgreSqlBuilder configuration for escaped characters is not correct, this causes that queries with special characters (like single quotes) using this class are not being parsed correctly.
Steps To ReproduceApply the attached patch for the DBSMTest project. It contains a test case for this issue.

Use a PostgresSQL database to run the test and notice that it fails.
Proposed SolutionReview the escaped characters in PostgreSqlBuilder[1], check the OracleSqlBuilder which currently works fine.

[1] https://code.openbravo.com/erp/devel/dbsm-main/file/8590a0dc4607/src/org/apache/ddlutils/platform/postgresql/PostgreSqlBuilder.java#l70 [^]

[2] https://code.openbravo.com/erp/devel/dbsm-main/file/8590a0dc4607/src/org/apache/ddlutils/platform/oracle/Oracle8Builder.java#l84 [^]
Additional Information
TagsNo tags attached.
Relationships
related to defect 00334173.0PR17Q1 closed caristu Loading config script for a module template in install.source task fails in pgsql 9.3 
Attached Filesdiff testIssue34022.diff (2,685) 2016-09-20 10:26
https://issues.openbravo.com/file_download.php?file_id=9836&type=bug
Issue History
Date ModifiedUsernameFieldChange
2016-09-19 19:21caristuNew Issue
2016-09-19 19:21caristuAssigned To => platform
2016-09-19 19:21caristuModules => Core
2016-09-19 19:21caristuTriggers an Emergency Pack => No
2016-09-19 19:24caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=13130#r13130
2016-09-19 19:24caristuProposed Solution updated
2016-09-19 19:24caristuRelationship addedrelated to 0033417
2016-09-20 10:26caristuSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=13133#r13133
2016-09-20 10:26caristuFile Added: testIssue34022.diff
2016-09-20 18:55caristuSummaryPostgreSqlBuilder configuration for scaped characters is not correct => PostgreSqlBuilder configuration for escaped characters is not correct
2016-09-29 16:21caristuCategoryA. Platform => Y. DBSourceManager
2016-12-01 12:55alostaleStatusnew => acknowledged
2022-02-01 08:05alostaleAssigned Toplatform => Triage Platform Base

There are no notes attached to this issue.