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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0012314
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2010-02-17 09:522010-03-16 00:00
ReporternetworkbView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionfixedFixed in Version2.50MP14
StatusclosedFix in branchpiFixed in SCM revision62b410eb94f3
ProjectionnoneETAnoneTarget Version2.50MP14
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.50MP11SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

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

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0024591)
shuehner (administrator)
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 (developer)
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 (developer)
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 (administrator)
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

- Issue History
Date Modified Username Field Change
2010-02-17 09:52 networkb New Issue
2010-02-17 09:52 networkb Assigned To => marvintm
2010-02-18 13:10 shuehner Note Added: 0024591
2010-02-22 08:20 alostale Status new => scheduled
2010-02-22 08:20 alostale fix_in_branch => pi
2010-03-05 16:10 hgbot Checkin
2010-03-05 16:10 hgbot Note Added: 0025087
2010-03-05 16:10 hgbot Status scheduled => resolved
2010-03-05 16:10 hgbot Resolution open => fixed
2010-03-05 16:10 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/62b410eb94f3e05a3a38f7547a1c5f2fe14687df [^]
2010-03-08 16:05 jpabloae Target Version 2.50MP13 => 2.50MP14
2010-03-12 22:41 hudsonbot Checkin
2010-03-12 22:41 hudsonbot Note Added: 0025398
2010-03-15 16:20 shuehner Note Added: 0025483
2010-03-15 16:20 shuehner Status resolved => closed
2010-03-15 16:20 shuehner Fixed in Version => 2.50MP14
2010-03-16 00:00 anonymous sf_bug_id 0 => 2970929

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker