Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012314Openbravo ERPA. Platformpublic2010-02-17 09:522010-03-16 00:00
Reporternetworkb 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP11 
Target Version2.50MP14Fixed in Version2.50MP14 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012314: The onCreateDefault takes too much when creating a new column in a table with a big number of rows
DescriptionThe onCreateDefault takes too much when creating a new column in a table with a big number of rows.
For example with 250.000 rows it takes some hours.
Steps To Reproduce-Create a new modules that adds a column that has a onCreateDefaul.
-Apply this to a application that has a bit number of rows on the table where the new column is going to be added.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-17 09:52networkbNew Issue
2010-02-17 09:52networkbAssigned To => marvintm
2010-02-17 09:52networkbOBNetwork customer => Yes
2010-02-18 13:10shuehnerNote Added: 0024591
2010-02-22 08:20alostaleStatusnew => scheduled
2010-02-22 08:20alostalefix_in_branch => pi
2010-03-05 16:10hgbotCheckin
2010-03-05 16:10hgbotNote Added: 0025087
2010-03-05 16:10hgbotStatusscheduled => resolved
2010-03-05 16:10hgbotResolutionopen => fixed
2010-03-05 16:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/62b410eb94f3e05a3a38f7547a1c5f2fe14687df [^]
2010-03-08 16:05jpabloaeTarget Version2.50MP13 => 2.50MP14
2010-03-12 22:41hudsonbotCheckin
2010-03-12 22:41hudsonbotNote Added: 0025398
2010-03-15 16:20shuehnerNote Added: 0025483
2010-03-15 16:20shuehnerStatusresolved => closed
2010-03-15 16:20shuehnerFixed in Version => 2.50MP14
2010-03-16 00:00anonymoussf_bug_id0 => 2970929

Notes
(0024591)
shuehner   
2010-02-18 13:10   
Can you please add the value used for the onCreateDefault here? Is it some static value? or is it some sql-expression which needs to be evaluated?
(0025087)
hgbot   
2010-03-05 16:10   
Repository: erp/devel/pi
Changeset: 62b410eb94f3e05a3a38f7547a1c5f2fe14687df
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Fri Mar 05 15:57:04 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/62b410eb94f3e05a3a38f7547a1c5f2fe14687df [^]

Fixed issue 12314. onCreateDefaults will now be executed without linking to temporary table, to speed the execution in cases in which the tables have a big number of rows.

---
M src-db/database/lib/dbsourcemanager.jar
---
(0025398)
hudsonbot   
2010-03-12 22:41   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/62b410eb94f3 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/631c626866c1 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16685.obx [^]
(0025483)
shuehner   
2010-03-15 16:20   
Tested onCreateDefault themselves in pi with a 2.50 (without MP) to pi update, performance checked by marvintm + reporter. -> Closing