Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010077
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajorhave not tried2009-07-27 18:082009-07-28 00:00
ReportermarvintmView Statuspublic 
Assigned Tomarvintm 
PriorityimmediateResolutionfixedFixed in Version2.50MP3
StatusclosedFix in branchFixed in SCM revision1c9ae662f869
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010077: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0018633)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2009-07-27 18:08 marvintm New Issue
2009-07-27 18:08 marvintm Assigned To => marvintm
2009-07-27 18:18 hgbot Checkin
2009-07-27 18:18 hgbot Note Added: 0018633
2009-07-27 18:18 hgbot Status new => resolved
2009-07-27 18:18 hgbot Resolution open => fixed
2009-07-27 18:18 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1c9ae662f86992d550917acafca2e4953a65b321 [^]
2009-07-27 18:21 psarobe Status resolved => closed
2009-07-27 18:21 psarobe version => pi
2009-07-27 18:21 psarobe Fixed in Version => 2.50MP3
2009-07-28 00:00 anonymous sf_bug_id 0 => 2828095


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker