Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0009551 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | have not tried | 2009-06-18 18:28 | 2009-07-27 00:00 | |||
| Reporter | marvintm | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 2.50MP3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | dd1fb1476753 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0009551: update.customized.database doesn't correctly upgrade column type for NVARCHAR columns created in r2.3x | |||||||
| Description | Database 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 Reproduce | Upgrade 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 Solution | DBSM needs to be fixed so that it adds this comment. | |||||||
| Tags | 250MP3releasecandidate | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0017486) hgbot (developer) 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 (developer) 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 --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2009-06-18 18:28 | marvintm | New Issue | |
| 2009-06-18 18:28 | marvintm | Assigned To | => marvintm |
| 2009-06-18 18:30 | psarobe | Issue Monitored: psarobe | |
| 2009-06-19 16:23 | hgbot | Checkin | |
| 2009-06-19 16:23 | hgbot | Note Added: 0017486 | |
| 2009-06-19 16:23 | hgbot | Status | new => resolved |
| 2009-06-19 16:23 | hgbot | Resolution | open => fixed |
| 2009-06-19 16:30 | hgbot | Checkin | |
| 2009-06-19 16:30 | hgbot | Note Added: 0017487 | |
| 2009-06-19 16:30 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.40/rev/dd1fb1476753ae82b305752d4952d916e53fd687 [^] |
| 2009-06-22 11:09 | psarobe | Fixed in Version | => main |
| 2009-07-21 16:24 | psarobe | Fixed in Version | main => 2.50MP3 |
| 2009-07-21 16:26 | psarobe | Tag Attached: 250MP3releasecandidate | |
| 2009-07-26 21:33 | psarobe | Status | resolved => closed |
| 2009-07-27 00:00 | anonymous | sf_bug_id | 0 => 2827488 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |