Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029270Openbravo ERPY. DBSourceManagerpublic2015-03-13 12:072015-05-07 22:17
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0PR15Q3 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029270: prevent table recreation in update.database
DescriptionSee project page: http://wiki.openbravo.com/wiki/Projects:Table_Recreation_Prevention [^]
Steps To Reproduce-
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to feature request 0029154 closed alostale log table recreation on update database 
related to design defect 0029142 acknowledged Triage Platform Base update.database does not remove invalid rows with multiple level of cascaded FKs 
related to defect 0029284 closed alostale Oracle: onCretateDefault not executed for appended non mandatory columns 
related to design defect 0028822 acknowledged Triage Platform Base update.database.script is not reliable 
related to defect 0034048 closed platform Not null constraint removed from database under some circumnstances 
related to feature request 00346543.0PR17Q2 closed alostale some performance improvements in DBSM tasks 
causes defect 00299233.0PR15Q3 closed alostale upgrading from 2.50 to pi shows errors in update.database log 
causes defect 00299273.0PR15Q3 closed alostale export database after upgrade from 2.50 results in formal changes 
causes defect 00300163.0PR15Q3 closed alostale upgrading from 2.50 to pi some FKs are missing 
causes defect 00322443.0PR16Q2 closed alostale oracle shows error in log when setting an AD column to not null 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-03-13 12:07alostaleNew Issue
2015-03-13 12:07alostaleAssigned To => alostale
2015-03-13 12:07alostaleModules => Core
2015-03-13 12:07alostaleTriggers an Emergency Pack => No
2015-03-13 12:08alostaleStatusnew => scheduled
2015-03-13 12:09alostaleRelationship addedrelated to 0029154
2015-03-13 12:09alostaleRelationship addedrelated to 0029142
2015-03-13 12:28alostaleTag Attached: Performance
2015-03-16 10:10alostaleRelationship addedrelated to 0029284
2015-03-18 15:09alostaleRelationship addedrelated to 0028822
2015-04-28 16:57hgbotCheckin
2015-04-28 16:57hgbotNote Added: 0076834
2015-04-28 16:57hgbotStatusscheduled => resolved
2015-04-28 16:57hgbotResolutionopen => fixed
2015-04-28 16:57hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f8c18a0c0a00d9dc01482bb1ca5b72d2c68c1fe3 [^]
2015-04-28 16:58alostaleReview Assigned To => marvintm
2015-04-29 08:53marvintmStatusresolved => closed
2015-04-29 08:53marvintmFixed in Version => 3.0PR15Q3
2015-05-07 22:17hudsonbotCheckin
2015-05-07 22:17hudsonbotNote Added: 0077175
2015-05-19 09:45alostaleRelationship addedcauses 0029923
2015-05-19 10:16alostaleRelationship addedcauses 0029927
2015-05-26 15:10alostaleRelationship addedcauses 0030016
2016-02-16 14:52alostaleRelationship addedcauses 0032244
2016-09-21 16:33caristuRelationship addedrelated to 0034048
2016-11-30 11:31alostaleRelationship addedrelated to 0034654

Notes
(0076834)
hgbot   
2015-04-28 16:57   
Repository: erp/devel/pi
Changeset: f8c18a0c0a00d9dc01482bb1ca5b72d2c68c1fe3
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue Apr 28 16:56:17 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/f8c18a0c0a00d9dc01482bb1ca5b72d2c68c1fe3 [^]

fixed issue 29270: prevent table recreation in update.database

  When adding or removing columns to existing tables update.database does not
  recreate the table but just appends the new columns. In order to do this,
  column phyisical position wihtin the table is no longer important, being relative
  only to the time they were created but not to the module they belong to.

---
M src-db/database/build.xml
M src-db/database/lib/dbsourcemanager.jar
---
(0077175)
hudsonbot   
2015-05-07 22:17   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/a1817f84bd8b [^]
Maturity status: Test