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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013298
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajorhave not tried2010-05-11 19:022010-05-18 21:44
ReportermarvintmView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in Version2.50MP17
StatusclosedFix in branchpiFixed in SCM revision5c9a58ec18bc
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava 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

0013298: In Oracle databases, triggers generated without a DECLARE statement are not created correctly in the database

DescriptionWhen a trigger which was created with a DECLARE statement is exported, it has an additional line end at the beginning of the body in the XML file. This additional line is not present in the case of triggers created without a DECLARE statement. When dbsourcemanager tries to create this kind of triggers in the database, it produces statements which contains "DECLAREBEGIN" words, which is obviously wrong.
Steps To ReproduceCreate a trigger without using a DECLARE statement in Oracle. Export it and do update.database. The trigger creation statement will fail
Proposed SolutionDBSM needs to be able to correctly insert triggers created this way.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0027150)
hgbot (developer)
2010-05-11 19:04

 Repository: erp/devel/pi
Changeset: 5c9a58ec18bccc45754b25292ebcd74d4a4c58f1
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue May 11 19:04:02 2010 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5c9a58ec18bccc45754b25292ebcd74d4a4c58f1 [^]

Fixed issue 13298. Triggers created without DECLARE statements will now be created correctly in update.database and create.database.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0027514)
hudsonbot (developer)
2010-05-18 21:44

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/5c9a58ec18bc [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^]

- Issue History
Date Modified Username Field Change
2010-05-11 19:02 marvintm New Issue
2010-05-11 19:02 marvintm Assigned To => marvintm
2010-05-11 19:04 hgbot Checkin
2010-05-11 19:04 hgbot Note Added: 0027150
2010-05-11 19:04 hgbot Status new => resolved
2010-05-11 19:04 hgbot Resolution open => fixed
2010-05-11 19:04 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/5c9a58ec18bccc45754b25292ebcd74d4a4c58f1 [^]
2010-05-14 09:15 alostale Status resolved => closed
2010-05-14 09:15 alostale Fixed in Version => 2.50MP16
2010-05-14 09:15 alostale Status closed => new
2010-05-14 09:15 alostale Resolution fixed => open
2010-05-14 09:15 alostale Fixed in Version 2.50MP16 =>
2010-05-14 09:15 alostale Status new => scheduled
2010-05-14 09:15 alostale fix_in_branch => pi
2010-05-14 09:16 alostale Status scheduled => resolved
2010-05-14 09:16 alostale Resolution open => fixed
2010-05-14 09:16 alostale Status resolved => closed
2010-05-14 09:16 alostale Fixed in Version => 2.50MP17
2010-05-15 00:01 anonymous sf_bug_id 0 => 3001866
2010-05-18 21:44 hudsonbot Checkin
2010-05-18 21:44 hudsonbot Note Added: 0027514

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker