Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009366Openbravo ERPY. DBSourceManagerpublic2009-06-08 11:132009-07-27 00:00
Reportervillind 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.40MP4 
Target VersionFixed in Version2.50MP3 
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
Summary0009366: PL/SQL code translation fails if the database has an existing procedure (void function) that ends with the suffix of existing fu
DescriptionPL/SQL code translation fails if the database has an existing procedure (void function) that ends with the suffix of existing function.

Example 1:
Original PL/SQL code: INSERT INTO M_PRODUCT_TEMPLATE(M_PRODUCT_TEMPLATE_ID
Replaced PL/SQL code: INSERT INTO M_PRODUCT_PERFORM TEMPLATE(M_PRODUCT_TEMPLATE_ID

Example 2:
Original PL/SQL code: L_FI_COPY_ORDER_INTO_TEMPLATE(v_pinstance_id);
Replaced PL/SQL code: PERFORM L_FI_COPY_ORDER_INTO_PERFORM TEMPLATE(v_pinstance_id);
Steps To ReproduceUse the name of the function withing PERFORM the PL/SQL code. See the examples.
Proposed SolutionRequire that there is whitespace (space, tab, newline or linefeed) before the matched name.
Additional Information
Tags250MP3releasecandidate
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-08 11:13villindNew Issue
2009-06-08 11:13villindAssigned To => marvintm
2009-06-09 17:48psarobePrioritynormal => urgent
2009-06-09 17:48psarobeStatusnew => scheduled
2009-06-11 18:09hgbotCheckin
2009-06-11 18:09hgbotNote Added: 0017220
2009-06-11 18:09hgbotStatusscheduled => resolved
2009-06-11 18:09hgbotResolutionopen => fixed
2009-06-11 18:11hgbotCheckin
2009-06-11 18:11hgbotNote Added: 0017221
2009-06-11 18:11hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/956884ed1e7b74341b4d2f0b840a1861fcfcb374 [^]
2009-06-16 09:43villindNote Added: 0017337
2009-06-22 11:09psarobeFixed in Version => main
2009-07-21 16:24psarobeFixed in Versionmain => 2.50MP3
2009-07-21 16:26psarobeTag Attached: 250MP3releasecandidate
2009-07-26 21:36psarobeStatusresolved => closed
2009-07-27 00:00anonymoussf_bug_id0 => 2827481

Notes
(0017220)
hgbot   
2009-06-11 18:09   
Repository: dbsourcemanager
Revision: 334
Author: marvintm
Date: 2009-06-11 18:09:41 +0200 (Thu, 11 Jun 2009)

Fixed issue 9366. Now if a function name is a suffix of another function name, the translation should work correctly in PostgreSQL.

---
U trunk/src/org/apache/ddlutils/platform/postgresql/PostgrePLSQLTranslation.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=334&sc=1 [^]
(0017221)
hgbot   
2009-06-11 18:11   
Repository: erp/devel/pi
Changeset: 956884ed1e7b74341b4d2f0b840a1861fcfcb374
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Thu Jun 11 18:10:05 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/956884ed1e7b74341b4d2f0b840a1861fcfcb374 [^]

Fixed issue 9366. Now if a function name is a suffix of another function name, the translation should work correctly in PostgreSQL.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0017337)
villind   
2009-06-16 09:43   
Are you planning to push this also to the 2.40 maintenance branch?