Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0004705 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] Z. Others | major | always | 2008-08-25 16:29 | 2008-12-02 13:02 | |||
Reporter | jpabloae | View Status | public | |||||
Assigned To | jpabloae | |||||||
Priority | high | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | 6536 | ||||
Projection | none | ETA | none | Target Version | 2.40 | |||
OS | Any | Database | PostgreSQL | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 2.40 | SCM revision | ||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0004705: OnCreateDefault command doesn't work in PostgreSQL | |||||||
Description | When 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 Reproduce | Just 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. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||||
|
Notes | |
(0008729) svnbot (reporter) 2008-08-25 16:31 |
Repository: openbravo Revision: 6536 Author: jpabloae Date: 2008-08-25 16:31:51 +0200 (Mon, 25 Aug 2008) Fixes issue 4705: OnCreateDefault command doesn't work in PostgreSQL --- U trunk/src-db/database/model/tables/C_BANKACCOUNT.xml U trunk/src-db/database/model/tables/C_BP_BANKACCOUNT.xml U trunk/src-db/database/model/tables/C_GLITEM.xml U trunk/src-db/database/model/tables/C_PROJECT.xml U trunk/src-db/database/model/tables/C_PROJECTTASK.xml U trunk/src-db/database/model/tables/C_TAX.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=6536&sc=1 [^] |
Issue History | |||
Date Modified | Username | Field | Change |
2008-08-25 16:29 | jpabloae | New Issue | |
2008-08-25 16:29 | jpabloae | Assigned To | => jpabloae |
2008-08-25 16:29 | jpabloae | Regression testing | => No |
2008-08-25 16:29 | jpabloae | Issue generated from | 0004704 |
2008-08-25 16:29 | jpabloae | Relationship added | related to 0004704 |
2008-08-25 16:31 | svnbot | Checkin | |
2008-08-25 16:31 | svnbot | Note Added: 0008729 | |
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 | => 6536 |
2008-08-25 16:32 | jpabloae | Target Version | 2.40 => trunk |
2008-09-04 16:22 | psarobe | Target Version | trunk => 2.40 |
2008-11-25 23:20 | psarobe | Status | resolved => closed |
2008-12-02 13:02 | jaimetorre | sf_bug_id | 0 => 2377077 |
Copyright © 2000 - 2009 MantisBT Group |