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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0034022
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagerminoralways2016-09-19 19:212022-02-01 08:05
ReportercaristuView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0034022: 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 [^]
TagsNo tags attached.
Attached Filesdiff file icon testIssue34022.diff [^] (2,685 bytes) 2016-09-20 10:26 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00334173.0PR17Q1 closedcaristu Loading config script for a module template in install.source task fails in pgsql 9.3 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2016-09-19 19:21 caristu New Issue
2016-09-19 19:21 caristu Assigned To => platform
2016-09-19 19:21 caristu Modules => Core
2016-09-19 19:21 caristu Triggers an Emergency Pack => No
2016-09-19 19:24 caristu Steps to Reproduce Updated View Revisions
2016-09-19 19:24 caristu Proposed Solution updated
2016-09-19 19:24 caristu Relationship added related to 0033417
2016-09-20 10:26 caristu Steps to Reproduce Updated View Revisions
2016-09-20 10:26 caristu File Added: testIssue34022.diff
2016-09-20 18:55 caristu Summary PostgreSqlBuilder configuration for scaped characters is not correct => PostgreSqlBuilder configuration for escaped characters is not correct
2016-09-29 16:21 caristu Category A. Platform => Y. DBSourceManager
2016-12-01 12:55 alostale Status new => acknowledged
2022-02-01 08:05 alostale Assigned To platform => Triage Platform Base


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker