Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010077Openbravo ERPY. DBSourceManagerpublic2009-07-27 18:082009-07-28 00:00
Reportermarvintm 
Assigned Tomarvintm 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP3 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010077: OnCreateDefault fails to execute correctly when the column is required
DescriptionIf a new column which is going to be added in an update.database is required and has a defined onCreateDefault value, the process will fail, because a NOT NULL constraint is still active.
Steps To ReproduceJust define a new column in an xml, make it required, define an onCreateDefault value for it, and do update.database.
Proposed SolutionThe INSERT/SELECT statement needs to directly insert the onCreateDefault value when the table is being recreated.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-07-27 18:08marvintmNew Issue
2009-07-27 18:08marvintmAssigned To => marvintm
2009-07-27 18:08marvintmOBNetwork customer => No
2009-07-27 18:18hgbotCheckin
2009-07-27 18:18hgbotNote Added: 0018633
2009-07-27 18:18hgbotStatusnew => resolved
2009-07-27 18:18hgbotResolutionopen => fixed
2009-07-27 18:18hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1c9ae662f86992d550917acafca2e4953a65b321 [^]
2009-07-27 18:21psarobeStatusresolved => closed
2009-07-27 18:21psarobeversion => pi
2009-07-27 18:21psarobeFixed in Version => 2.50MP3
2009-07-28 00:00anonymoussf_bug_id0 => 2828095

Notes
(0018633)
hgbot   
2009-07-27 18:18   
Repository: erp/devel/pi
Changeset: 1c9ae662f86992d550917acafca2e4953a65b321
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Mon Jul 27 18:17:54 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1c9ae662f86992d550917acafca2e4953a65b321 [^]

Fixed issue 10077. Now INSERT/SELECT statement will include the onCreateDefault values for new columns which have an onCreateDefault value defined.

---
M src-db/database/lib/dbsourcemanager.jar
---