Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005225 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | always | 2008-09-24 10:58 | 2009-04-22 00:00 | |||
| Reporter | marvintm | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | low | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 10526 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | 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 | 0005225: Changes of a column from NOT NULL to NULL right now are performed in the update script instead of the postscript | |||||||
| Description | Right now, changes of the nullability of a column are performed in the first part of the update script. If a columns is changed from NULL to NOT NULL, and the data present in the database has NULL values, there will be an error. | |||||||
| Steps To Reproduce | Just change a column from NULL to NOT NULL and do an update.database. | |||||||
| Proposed Solution | We should perform this change in the postscript of the update process, to be sure that the data inserted in the database has been updated. | |||||||
| Tags | dbsm_migrate | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0010518) svnbot (reporter) 2008-11-21 18:01 |
Repository: dbsourcemanager Revision: 179 Author: marvintm Date: 2008-11-21 18:01:16 +0100 (Fri, 21 Nov 2008) Fixed issue 5225. Now columns will be set to NOT NULL at the end of the update process, so data is updated before the constraint is activated. --- U branches/r0.8x/src/org/apache/ddlutils/platform/SqlBuilder.java U branches/r0.8x/src/org/apache/ddlutils/platform/postgresql/PostgreSqlBuilder.java --- https://dev.openbravo.com/websvn/dbsourcemanager/?rev=179&sc=1 [^] |
|
(0010519) svnbot (reporter) 2008-11-21 18:03 |
Repository: openbravo Revision: 10415 Author: marvintm Date: 2008-11-21 18:03:07 +0100 (Fri, 21 Nov 2008) Fixed issue 5225. Now columns will be set to NOT NULL at the end of the update process, so data is updated before the constraint is activated. --- U branches/r2.40/src-db/database/lib/dbsourcemanager.jar --- https://dev.openbravo.com/websvn/openbravo/?rev=10415&sc=1 [^] |
|
(0010520) svnbot (reporter) 2008-11-21 18:08 |
Repository: dbsourcemanager Revision: 180 Author: marvintm Date: 2008-11-21 18:08:33 +0100 (Fri, 21 Nov 2008) Fixed issue 5225. Now columns will be set to NOT NULL at the end of the update process, so data is updated before the constraint is activated. --- _U trunk/ U trunk/src/org/apache/ddlutils/platform/SqlBuilder.java U trunk/src/org/apache/ddlutils/platform/postgresql/PostgreSqlBuilder.java --- https://dev.openbravo.com/websvn/dbsourcemanager/?rev=180&sc=1 [^] |
|
(0010521) svnbot (reporter) 2008-11-21 18:15 |
Repository: openbravo Revision: 10416 Author: marvintm Date: 2008-11-21 18:15:12 +0100 (Fri, 21 Nov 2008) Fixed issue 5225. Now columns will be set to NOT NULL at the end of the update process, so data is updated before the constraint is activated. --- U trunk/src-db/database/lib/dbsourcemanager.jar --- https://dev.openbravo.com/websvn/openbravo/?rev=10416&sc=1 [^] |
|
(0010624) svnbot (reporter) 2008-11-25 12:08 |
Repository: openbravo Revision: 10526 Author: villind Date: 2008-11-25 12:08:33 +0100 (Tue, 25 Nov 2008) Merged r10415. Fixed issue 5225. Now columns will be set to NOT NULL at the end of the update process, so data is updated before the constraint is activated. --- _U branches/bonware/r2.40/ _U branches/bonware/r2.40/config/setup-tool/ _U branches/bonware/r2.40/eclipse.install.source.launch _U branches/bonware/r2.40/export.database.launch _U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java U branches/bonware/r2.40/src-db/database/lib/dbsourcemanager.jar _U branches/bonware/r2.40/update.database.launch --- https://dev.openbravo.com/websvn/openbravo/?rev=10526&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-09-24 10:58 | marvintm | New Issue | |
| 2008-11-21 18:01 | svnbot | Checkin | |
| 2008-11-21 18:01 | svnbot | Note Added: 0010518 | |
| 2008-11-21 18:01 | svnbot | Status | new => resolved |
| 2008-11-21 18:01 | svnbot | Resolution | open => fixed |
| 2008-11-21 18:01 | svnbot | svn_revision | => 179 |
| 2008-11-21 18:03 | svnbot | Checkin | |
| 2008-11-21 18:03 | svnbot | Note Added: 0010519 | |
| 2008-11-21 18:03 | svnbot | svn_revision | 179 => 10415 |
| 2008-11-21 18:08 | svnbot | Checkin | |
| 2008-11-21 18:08 | svnbot | Note Added: 0010520 | |
| 2008-11-21 18:08 | svnbot | svn_revision | 10415 => 180 |
| 2008-11-21 18:15 | svnbot | Checkin | |
| 2008-11-21 18:15 | svnbot | Note Added: 0010521 | |
| 2008-11-21 18:15 | svnbot | svn_revision | 180 => 10416 |
| 2008-11-25 12:08 | svnbot | Checkin | |
| 2008-11-25 12:08 | svnbot | Note Added: 0010624 | |
| 2008-11-25 12:08 | svnbot | svn_revision | 10416 => 10526 |
| 2008-11-28 12:54 | jpabloae | Assigned To | => marvintm |
| 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-04-21 11:07 | psarobe | Status | resolved => closed |
| 2009-04-22 00:00 | anonymous | sf_bug_id | 0 => 2777903 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |