Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0034022 | Openbravo ERP | Y. DBSourceManager | public | 2016-09-19 19:21 | 2022-02-01 08:05 |
|
| Reporter | caristu | |
| Assigned To | Triage Platform Base | |
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | acknowledged | Resolution | open | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | No |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0034022: PostgreSqlBuilder configuration for escaped characters is not correct |
| Description | PostgreSqlBuilder 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 Reproduce | Apply 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 Solution | Review 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 | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0033417 | 3.0PR17Q1 | closed | caristu | Loading config script for a module template in install.source task fails in pgsql 9.3 |
|
| Attached Files |  testIssue34022.diff (2,685) 2016-09-20 10:26
https://issues-new.openbravo.com/file_download.php?file_id=9836&type=bug |
|
| 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 | OBNetwork customer | => No |
| 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 | bug_revision_view_page.php?rev_id=13130#r13130 |
| 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 | bug_revision_view_page.php?rev_id=13133#r13133 |
| 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 |