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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0004726
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajoralways2008-08-27 10:352009-03-18 11:02
ReportermarvintmView Statuspublic 
Assigned Tomarvintm 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision112
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

0004726: Several indexes are not exported in Oracle

DescriptionAfter creating a database and exporting it, several indexes are not exported.
Steps To Reproduceant create.database
ant export.database

Several indexes in tables should have disappeared.
Proposed SolutionThe solution is to change the order of the primary key and index creation statements, during the creation of the database, in dbsourcemanager.
Tagsdbsm_migrate
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0008764)
svnbot (reporter)
2008-08-27 10:36

Repository: dbsourcemanager
Revision: 111
Author: marvintm
Date: 2008-08-27 10:36:23 +0200 (Wed, 27 Aug 2008)

Fixed issue 0004726. Now the indexes will be created after the primary keys, so make sure their type is correct, and that therefore they are exported without problems in Oracle.

---
U branches/r0.8x/src/org/apache/ddlutils/platform/SqlBuilder.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=111&sc=1 [^]
(0008765)
svnbot (reporter)
2008-08-27 11:00

Repository: dbsourcemanager
Revision: 112
Author: marvintm
Date: 2008-08-27 11:00:10 +0200 (Wed, 27 Aug 2008)

Backport of bug 4726 fix. Now indexes will be created after primary keys.

---
_U trunk/
U trunk/src/org/apache/ddlutils/platform/SqlBuilder.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=112&sc=1 [^]

- Issue History
Date Modified Username Field Change
2008-08-27 10:35 marvintm New Issue
2008-08-27 10:35 marvintm Assigned To => marvintm
2008-08-27 10:36 svnbot Checkin
2008-08-27 10:36 svnbot Note Added: 0008764
2008-08-27 10:36 svnbot Status new => resolved
2008-08-27 10:36 svnbot Resolution open => fixed
2008-08-27 10:36 svnbot svn_revision => 111
2008-08-27 11:00 svnbot Checkin
2008-08-27 11:00 svnbot Note Added: 0008765
2008-08-27 11:00 svnbot svn_revision 111 => 112
2008-12-15 19:00 psarobe Status resolved => closed
2008-12-18 12:38 jpabloae Sticky Issue No => Yes
2008-12-18 12:39 jpabloae Sticky Issue Yes => No
2008-12-18 12:39 jpabloae Tag Attached: dbsm_migrate
2008-12-18 12:41 jpabloae Project @4@ => Openbravo ERP
2008-12-18 12:42 jpabloae Category => Y. DBSourceManager
2009-03-18 11:02 anonymous sf_bug_id 0 => 2691344


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker