Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005198Openbravo ERPY. DBSourceManagerpublic2008-09-23 13:102009-03-18 11:02
Reportermarvintm 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
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
Summary0005198: Checks containing "::character varying" statements are not standardized correctly.
DescriptionIn PostgreSQL, checks containing "::character varying" statements are not standardized correctly. Therefore, when you export a table with a check that contains those statements, the XML is exported with them, and this could lead to problems when creating the database in Oracle.
Steps To ReproduceCreate a check with a "::character varying" statement and do an export.database.
Proposed SolutionWe will filter those statements and delete them.
Additional Information
Tagsdbsm_migrate
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-23 13:10marvintmNew Issue
2008-09-23 13:10marvintmAssigned To => marvintm
2008-09-23 15:22marvintmStatusnew => scheduled
2008-09-23 15:22marvintmfix_in_branch => trunk
2008-09-23 15:26svnbotCheckin
2008-09-23 15:26svnbotNote Added: 0009156
2008-09-23 15:26svnbotStatusscheduled => resolved
2008-09-23 15:26svnbotResolutionopen => fixed
2008-09-23 15:26svnbotsvn_revision => 127
2008-09-23 15:29svnbotCheckin
2008-09-23 15:29svnbotNote Added: 0009157
2008-09-23 15:29svnbotsvn_revision127 => 128
2008-11-25 22:45psarobeStatusresolved => closed
2008-12-18 12:38jpabloaeSticky IssueNo => Yes
2008-12-18 12:39jpabloaeSticky IssueYes => No
2008-12-18 12:39jpabloaeTag Attached: dbsm_migrate
2008-12-18 12:41jpabloaeProject@4@ => Openbravo ERP
2008-12-18 12:41jpabloaeCategory => Y. DBSourceManager
2009-03-18 11:02anonymoussf_bug_id0 => 2691354

Notes
(0009156)
svnbot   
2008-09-23 15:26   
Repository: dbsourcemanager
Revision: 127
Author: marvintm
Date: 2008-09-23 15:26:12 +0200 (Tue, 23 Sep 2008)

Fixed bug 5198. Now checks with ::character varying will be filtered to remove that statement, to avoid problems with Oracle

---
U branches/dbsmmodularity/src/org/apache/ddlutils/platform/postgresql/PostgreSqlCheckTranslation.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=127&sc=1 [^]
(0009157)
svnbot   
2008-09-23 15:29   
Repository: dbsourcemanager
Revision: 128
Author: marvintm
Date: 2008-09-23 15:29:12 +0200 (Tue, 23 Sep 2008)

Backport of bug 5198. Now checks with ::character varying will be filtered to remove that statement, to avoid problems with Oracle

---
_U branches/r0.8x/
U branches/r0.8x/src/org/apache/ddlutils/platform/postgresql/PostgreSqlCheckTranslation.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=128&sc=1 [^]