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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0004704
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] K. Packagingmajoralways2008-08-25 16:272008-11-25 21:47
ReportermarvintmView Statuspublic 
Assigned Tojpabloae 
PriorityhighResolutionfixedFixed in Version2.40
StatusclosedFix in branchFixed in SCM revision6535
ProjectionnoneETAnoneTarget Version2.40
OSAnyDatabasePostgreSQLJava 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

0004704: OnCreateDefault command doesn't work in PostgreSQL

DescriptionWhen the update.customized.database process is executed while trying to upgrade a customized r2.35 mp5 database to a r2.4 database, there are several errors related to the OnCreateDefault attribute of several tables.

Specifically, the problem is related to the "SELECT 'x' FROM DUAL" syntax used there. Those statements should be replaced by a simple 'x', to make them compatible both with Oracle and PostgreSQL.
Steps To ReproduceJust use the ant update.customized.database process in an MP5 database, with an originalDatabase folder containing an MP5 database, and a database folder containing the 2.40 standard xml files.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00047052.40 closedjpabloae OnCreateDefault command doesn't work in PostgreSQL 

-  Notes
(0008728)
svnbot (reporter)
2008-08-25 16:31

 Repository: openbravo
Revision: 6535
Author: jpabloae
Date: 2008-08-25 16:31:05 +0200 (Mon, 25 Aug 2008)

Fixes issue 4704: OnCreateDefault command doesn't work in PostgreSQL

---
U branches/r2.40/src-db/database/model/tables/C_BANKACCOUNT.xml
U branches/r2.40/src-db/database/model/tables/C_BP_BANKACCOUNT.xml
U branches/r2.40/src-db/database/model/tables/C_GLITEM.xml
U branches/r2.40/src-db/database/model/tables/C_PROJECT.xml
U branches/r2.40/src-db/database/model/tables/C_PROJECTTASK.xml
U branches/r2.40/src-db/database/model/tables/C_TAX.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=6535&sc=1 [^]
(0008881)
plujan (manager)
2008-09-04 10:54

 Reopened for moving to Packaging project

- Issue History
Date Modified Username Field Change
2008-08-25 16:27 marvintm New Issue
2008-08-25 16:27 marvintm Assigned To => jpabloae
2008-08-25 16:27 marvintm sf_bug_id 0 => 2073735
2008-08-25 16:27 marvintm Regression testing => No
2008-08-25 16:29 jpabloae Issue cloned 0004705
2008-08-25 16:29 jpabloae Relationship added related to 0004705
2008-08-25 16:30 jpabloae Target Version => trunk
2008-08-25 16:31 svnbot Checkin
2008-08-25 16:31 svnbot Note Added: 0008728
2008-08-25 16:31 svnbot Status new => resolved
2008-08-25 16:31 svnbot Resolution open => fixed
2008-08-25 16:31 svnbot svn_revision => 6535
2008-08-25 16:32 jpabloae Target Version trunk => 2.40
2008-09-04 10:54 plujan Status resolved => new
2008-09-04 10:54 plujan Resolution fixed => open
2008-09-04 10:54 plujan Note Added: 0008881
2008-09-04 10:54 plujan Project Openbravo ERP => @5@
2008-09-18 15:51 jpabloae Status new => scheduled
2008-09-18 15:51 jpabloae fix_in_branch => trunk
2008-09-18 15:51 jpabloae Status scheduled => resolved
2008-09-18 15:51 jpabloae Fixed in Version => 2.40
2008-09-18 15:51 jpabloae Resolution open => fixed
2008-11-13 07:01 jpabloae Category Z. Others => Upgrader
2008-11-13 07:01 jpabloae fix_in_branch trunk =>
2008-11-13 07:03 jpabloae Status resolved => closed
2008-11-25 21:41 pjuvara Sticky Issue No => Yes
2008-11-25 21:43 pjuvara Project @5@ => Openbravo ERP
2008-11-25 21:45 pjuvara Category Upgrader => K. Packaging
2008-11-25 21:47 pjuvara Sticky Issue Yes => No

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker