Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0009551Openbravo ERPY. DBSourceManagerpublic2009-06-18 18:282009-07-27 00:00
Reportermarvintm 
Assigned Tomarvintm 
PriorityimmediateSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.50MP3 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0009551: update.customized.database doesn't correctly upgrade column type for NVARCHAR columns created in r2.3x
DescriptionDatabase NVARCHAR columns weren't correctly created in Openbravo r2.3x instances in PostgreSQL (the comment that allows dbsm to know that they are in fact a NVARCHAR column, and not a VARCHAR one, is missing).

update.customized.database should add that comment to those columns, so that they are exported as NVARCHAR columns. However, it doesn't do it.
Steps To ReproduceUpgrade from any r2.3x version of Openbravo to any r2.4x one, using update.customized.database. Afterwards, do export.database. You will notice that all NVARCHAR columns have been changed to VARCHAR ones in the xml files.
Proposed SolutionDBSM needs to be fixed so that it adds this comment.
Additional Information
Tags250MP3releasecandidate
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-06-18 18:28marvintmNew Issue
2009-06-18 18:28marvintmAssigned To => marvintm
2009-06-18 18:30psarobeIssue Monitored: psarobe
2009-06-19 16:23hgbotCheckin
2009-06-19 16:23hgbotNote Added: 0017486
2009-06-19 16:23hgbotStatusnew => resolved
2009-06-19 16:23hgbotResolutionopen => fixed
2009-06-19 16:30hgbotCheckin
2009-06-19 16:30hgbotNote Added: 0017487
2009-06-19 16:30hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.40/rev/dd1fb1476753ae82b305752d4952d916e53fd687 [^]
2009-06-22 11:09psarobeFixed in Version => main
2009-07-21 16:24psarobeFixed in Versionmain => 2.50MP3
2009-07-21 16:26psarobeTag Attached: 250MP3releasecandidate
2009-07-26 21:33psarobeStatusresolved => closed
2009-07-27 00:00anonymoussf_bug_id0 => 2827488

Notes
(0017486)
hgbot   
2009-06-19 16:23   
Repository: dbsourcemanager
Revision: 342
Author: marvintm
Date: 2009-06-19 16:23:47 +0200 (Fri, 19 Jun 2009)

Fixed issue 9551. Now update.customized.database should add the identifying comment to NVARCHAR columns that were created in 2.3x PostgreSQL databases.

---
U branches/r0.8x/src/org/openbravo/ddlutils/task/AlterCustomizedDatabaseData.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=342&sc=1 [^]
(0017487)
hgbot   
2009-06-19 16:30   
Repository: erp/stable/2.40
Changeset: dd1fb1476753ae82b305752d4952d916e53fd687
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Fri Jun 19 16:29:10 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.40/rev/dd1fb1476753ae82b305752d4952d916e53fd687 [^]

Fixed issue 9551. Now update.customized.database should add the identifying comment to NVARCHAR columns that were created in 2.3x PostgreSQL databases.

---
M src-db/database/lib/dbsourcemanager.jar
---