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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009366
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajoralways2009-06-08 11:132009-07-27 00:00
ReportervillindView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionfixedFixed in Version2.50MP3
StatusclosedFix in branchFixed in SCM revision956884ed1e7b
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase version8.3Ant version
Product Version2.40MP4SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009366: 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.
Tags250MP3releasecandidate
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0017220)
hgbot (developer)
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 (developer)
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 (developer)
2009-06-16 09:43

 Are you planning to push this also to the 2.40 maintenance branch?

- Issue History
Date Modified Username Field Change
2009-06-08 11:13 villind New Issue
2009-06-08 11:13 villind Assigned To => marvintm
2009-06-09 17:48 psarobe Priority normal => urgent
2009-06-09 17:48 psarobe Status new => scheduled
2009-06-11 18:09 hgbot Checkin
2009-06-11 18:09 hgbot Note Added: 0017220
2009-06-11 18:09 hgbot Status scheduled => resolved
2009-06-11 18:09 hgbot Resolution open => fixed
2009-06-11 18:11 hgbot Checkin
2009-06-11 18:11 hgbot Note Added: 0017221
2009-06-11 18:11 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/956884ed1e7b74341b4d2f0b840a1861fcfcb374 [^]
2009-06-16 09:43 villind Note Added: 0017337
2009-06-22 11:09 psarobe Fixed in Version => main
2009-07-21 16:24 psarobe Fixed in Version main => 2.50MP3
2009-07-21 16:26 psarobe Tag Attached: 250MP3releasecandidate
2009-07-26 21:36 psarobe Status resolved => closed
2009-07-27 00:00 anonymous sf_bug_id 0 => 2827481

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker