Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0010077 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] Y. DBSourceManager | major | have not tried | 2009-07-27 18:08 | 2009-07-28 00:00 | |||
Reporter | marvintm | View Status | public | |||||
Assigned To | marvintm | |||||||
Priority | immediate | Resolution | fixed | Fixed in Version | 2.50MP3 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 1c9ae662f869 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | pi | SCM revision | ||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | No | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0010077: OnCreateDefault fails to execute correctly when the column is required | |||||||
Description | If 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 Reproduce | Just define a new column in an xml, make it required, define an onCreateDefault value for it, and do update.database. | |||||||
Proposed Solution | The INSERT/SELECT statement needs to directly insert the onCreateDefault value when the table is being recreated. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
|
![]() |
|
(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 --- |
![]() |
|||
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:08 | marvintm | OBNetwork customer | => No |
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 |