Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0000468 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | always | 2008-05-29 09:53 | 2009-03-18 11:02 | |||
| Reporter | jpabloae | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 73 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 64 bit | Database | Oracle | Java version | 1.5.0_15 | |||
| OS Version | Gentoo - 2.6.24 | Database version | 10.2.0.1 | Ant version | 1.7.0 | |||
| 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 | 0000468: Sampledata consistency not kept in update.database | |||||||
| Description | The "ant update.database" task does not maintain the sampledata consistency. So that if an ID is deleted in sourcedata and there are records in sampledata referencing that ID, then the update.database will fail with a constraint error. Take into account that in a "svn update" both sampledata and sourcedata are updated. But the update.database doesn't take into account this change in sampledata. Thus it may be necessary to keep this consistency. | |||||||
| Steps To Reproduce | 1. Delete an AD_PROCESS_ID in AD_PROCESS.xml in sourcedata. 2. Make sure there's a record in sampledata/AD_PROCESS_ACCESS.xml referencing that deleted AD_PROCESS_ID. 3. Run "ant update.database". | |||||||
| Tags | dbsm_migrate | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0000500) svnbot (reporter) 2008-06-11 17:54 |
Repository: dbsourcemanager Revision: 72 Author: marvintm Date: 2008-06-11 17:54:08 +0200 (Wed, 11 Jun 2008) Fixes bug 468 . Now data rows which contain an ON DELETE CASCADE type reference to a missing row will be deleted during the update.database process --- U trunk/src/org/apache/ddlutils/Platform.java U trunk/src/org/apache/ddlutils/io/DataToDatabaseSink.java U trunk/src/org/apache/ddlutils/platform/PlatformImplBase.java U trunk/src/org/apache/ddlutils/platform/SqlBuilder.java U trunk/src/org/openbravo/ddlutils/task/AlterDatabaseData.java --- https://dev.openbravo.com/websvn/dbsourcemanager/?rev=72&sc=1 [^] |
|
(0007671) svnbot (reporter) 2008-06-12 12:20 |
Repository: dbsourcemanager Revision: 73 Author: marvintm Date: 2008-06-12 12:20:38 +0200 (Thu, 12 Jun 2008) Fixes bug 468 . Now data rows which contain an ON DELETE CASCADE type reference to a missing row will be deleted during the update.database process --- U trunk/src/org/apache/ddlutils/io/DataToDatabaseSink.java U trunk/src/org/apache/ddlutils/io/DatabaseDataIO.java U trunk/src/org/apache/ddlutils/platform/SqlBuilder.java --- https://dev.openbravo.com/websvn/dbsourcemanager/?rev=73&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-05-29 09:53 | jpabloae | New Issue | |
| 2008-05-29 10:01 | jpabloae | Relationship added | related to 0000469 |
| 2008-06-11 17:54 | svnbot | Checkin | |
| 2008-06-11 17:54 | svnbot | Note Added: 0000500 | |
| 2008-06-11 17:54 | svnbot | Status | new => resolved |
| 2008-06-11 17:54 | svnbot | Resolution | open => fixed |
| 2008-06-11 17:54 | svnbot | svn_revision | => 72 |
| 2008-06-12 02:05 | cromero | Assigned To | => marvintm |
| 2008-06-12 02:05 | cromero | Status | resolved => new |
| 2008-06-12 02:05 | cromero | Resolution | fixed => open |
| 2008-06-12 12:20 | svnbot | Checkin | |
| 2008-06-12 12:20 | svnbot | Note Added: 0007671 | |
| 2008-06-12 12:20 | svnbot | Status | new => resolved |
| 2008-06-12 12:20 | svnbot | Resolution | open => fixed |
| 2008-06-12 12:20 | svnbot | svn_revision | 72 => 73 |
| 2008-11-26 13:50 | 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 => 2691317 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |