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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0029270
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] Y. DBSourceManagermajorhave not tried2015-03-13 12:072015-05-07 22:17
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version3.0PR15Q3
StatusclosedFix in branchFixed in SCM revisionf8c18a0c0a00
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0029270: prevent table recreation in update.database

DescriptionSee project page: http://wiki.openbravo.com/wiki/Projects:Table_Recreation_Prevention [^]
Steps To Reproduce-
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 0029154 closedalostale log table recreation on update database 
related to design defect 0029142 acknowledgedTriage Platform Base update.database does not remove invalid rows with multiple level of cascaded FKs 
related to defect 0029284 closedalostale Oracle: onCretateDefault not executed for appended non mandatory columns 
related to design defect 0028822 acknowledgedTriage Platform Base update.database.script is not reliable 
related to defect 0034048 closedplatform Not null constraint removed from database under some circumnstances 
related to feature request 00346543.0PR17Q2 closedalostale some performance improvements in DBSM tasks 
causes defect 00299233.0PR15Q3 closedalostale upgrading from 2.50 to pi shows errors in update.database log 
causes defect 00299273.0PR15Q3 closedalostale export database after upgrade from 2.50 results in formal changes 
causes defect 00300163.0PR15Q3 closedalostale upgrading from 2.50 to pi some FKs are missing 
causes defect 00322443.0PR16Q2 closedalostale oracle shows error in log when setting an AD column to not null 

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

- Issue History
Date Modified Username Field Change
2015-03-13 12:07 alostale New Issue
2015-03-13 12:07 alostale Assigned To => alostale
2015-03-13 12:07 alostale Modules => Core
2015-03-13 12:07 alostale Triggers an Emergency Pack => No
2015-03-13 12:08 alostale Status new => scheduled
2015-03-13 12:09 alostale Relationship added related to 0029154
2015-03-13 12:09 alostale Relationship added related to 0029142
2015-03-13 12:28 alostale Tag Attached: Performance
2015-03-16 10:10 alostale Relationship added related to 0029284
2015-03-18 15:09 alostale Relationship added related to 0028822
2015-04-28 16:57 hgbot Checkin
2015-04-28 16:57 hgbot Note Added: 0076834
2015-04-28 16:57 hgbot Status scheduled => resolved
2015-04-28 16:57 hgbot Resolution open => fixed
2015-04-28 16:57 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f8c18a0c0a00d9dc01482bb1ca5b72d2c68c1fe3 [^]
2015-04-28 16:58 alostale Review Assigned To => marvintm
2015-04-29 08:53 marvintm Status resolved => closed
2015-04-29 08:53 marvintm Fixed in Version => 3.0PR15Q3
2015-05-07 22:17 hudsonbot Checkin
2015-05-07 22:17 hudsonbot Note Added: 0077175
2015-05-19 09:45 alostale Relationship added causes 0029923
2015-05-19 10:16 alostale Relationship added causes 0029927
2015-05-26 15:10 alostale Relationship added causes 0030016
2016-02-16 14:52 alostale Relationship added causes 0032244
2016-09-21 16:33 caristu Relationship added related to 0034048
2016-11-30 11:31 alostale Relationship added related to 0034654

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker