Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004763 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | always | 2008-08-29 16:11 | 2009-03-18 11:02 | |||
| Reporter | marvintm | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 117 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 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 | 0004763: Upgrader gives an error when trying to recreate a UNIQUE constraint in Oracle | |||||||
| Description | When a UNIQUE constraint is created in Oracle, an INDEX with the same name is also created. If the constraint changes, during the update process dbsourcemanager tries to drop it, and create it again. However, the creation is not successfull, because an INDEX with the same name still exists. | |||||||
| Steps To Reproduce | Simply create a unique constraint in the database, export the database, change in the xml the constraint (for example, adding more columns to it), and perform the update.database process. | |||||||
| Proposed Solution | DBsourcemanager will now drop the constraint and its associated index, ensuring that no problems happen when recreating it. | |||||||
| Tags | dbsm_migrate | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0008785) svnbot (reporter) 2008-08-29 16:12 |
Repository: dbsourcemanager Revision: 117 Author: marvintm Date: 2008-08-29 16:12:51 +0200 (Fri, 29 Aug 2008) Fixed issue 4763. Now dbsourcemanager will drop the associated index when dropping a UNIQUE constraint. --- U branches/r0.8x/src/org/apache/ddlutils/platform/oracle/Oracle8Builder.java --- https://dev.openbravo.com/websvn/dbsourcemanager/?rev=117&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-08-29 16:11 | marvintm | New Issue | |
| 2008-08-29 16:11 | marvintm | Assigned To | => marvintm |
| 2008-08-29 16:12 | svnbot | Checkin | |
| 2008-08-29 16:12 | svnbot | Note Added: 0008785 | |
| 2008-08-29 16:12 | svnbot | Status | new => resolved |
| 2008-08-29 16:12 | svnbot | Resolution | open => fixed |
| 2008-08-29 16:12 | svnbot | svn_revision | => 117 |
| 2008-11-25 23:36 | 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:41 | jpabloae | Category | => Y. DBSourceManager |
| 2009-03-18 11:02 | anonymous | sf_bug_id | 0 => 2691345 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |