Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005225Openbravo ERPY. DBSourceManagerpublic2008-09-24 10:582009-04-22 00:00
Reportermarvintm 
Assigned Tomarvintm 
PrioritylowSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0005225: Changes of a column from NOT NULL to NULL right now are performed in the update script instead of the postscript
DescriptionRight 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 ReproduceJust change a column from NULL to NOT NULL and do an update.database.
Proposed SolutionWe should perform this change in the postscript of the update process, to be sure that the data inserted in the database has been updated.
Additional Information
Tagsdbsm_migrate
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-24 10:58marvintmNew Issue
2008-11-21 18:01svnbotCheckin
2008-11-21 18:01svnbotNote Added: 0010518
2008-11-21 18:01svnbotStatusnew => resolved
2008-11-21 18:01svnbotResolutionopen => fixed
2008-11-21 18:01svnbotsvn_revision => 179
2008-11-21 18:03svnbotCheckin
2008-11-21 18:03svnbotNote Added: 0010519
2008-11-21 18:03svnbotsvn_revision179 => 10415
2008-11-21 18:08svnbotCheckin
2008-11-21 18:08svnbotNote Added: 0010520
2008-11-21 18:08svnbotsvn_revision10415 => 180
2008-11-21 18:15svnbotCheckin
2008-11-21 18:15svnbotNote Added: 0010521
2008-11-21 18:15svnbotsvn_revision180 => 10416
2008-11-25 12:08svnbotCheckin
2008-11-25 12:08svnbotNote Added: 0010624
2008-11-25 12:08svnbotsvn_revision10416 => 10526
2008-11-28 12:54jpabloaeAssigned To => marvintm
2008-12-18 12:38jpabloaeSticky IssueNo => Yes
2008-12-18 12:39jpabloaeSticky IssueYes => No
2008-12-18 12:39jpabloaeTag Attached: dbsm_migrate
2008-12-18 12:41jpabloaeProject@4@ => Openbravo ERP
2008-12-18 12:41jpabloaeCategory => Y. DBSourceManager
2009-04-21 11:07psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777903

Notes
(0010518)
svnbot   
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   
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   
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   
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   
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 [^]