Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005002Openbravo ERPY. DBSourceManagerpublic2008-09-10 10:452009-04-22 00:00
Reporterpsarobe 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityalways
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
Summary0005002: Treatment for null and '' values in columns
DescriptionDBSource manager manage in a different way the columns with values '' and null. For Oracle is transparent so when running ant export.database either the value is null or '' they doesn't appear in the xml files

But PostgreSQL doesn't so, when the value is '' it appears in the .xml file but when is null it does not appear.

An example during the upgrader MP4-MP5

Upgrade M4-MP5
  <AD_ELEMENT_TRL AD_ELEMENT_ID="367" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-09-26 12:55:53.0" CREATEDBY="100" UPDATED="2003-09-26 12:55:53.0" UPDATEDBY="100" NAME="Repartido-Entregado" PRINTNAME="Repartido-Entregado" DESCRIPTION="" HELP="" ISTRANSLATED="Y" />

Tag MP5

  <AD_ELEMENT_TRL AD_ELEMENT_ID="367" AD_LANGUAGE="es_ES" AD_CLIENT_ID="0" AD_ORG_ID="0" ISACTIVE="Y" CREATED="2003-09-26 12:55:53.0" CREATEDBY="100" UPDATED="2003-09-26 12:55:53.0" UPDATEDBY="100" NAME="Repartido-Entregado" PRINTNAME="Repartido-Entregado" ISTRANSLATED="Y" />

Steps To Reproduce
Proposed Solution
Additional Information
Tagsdbsm_migrate
Relationships
depends on backport 0005843 closed marvintm Treatment for null and '' values in columns 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-10 10:45psarobeNew Issue
2008-09-10 10:45psarobeIssue Monitored: psarobe
2008-09-12 13:39psarobeAssigned To => marvintm
2008-11-06 11:13marvintmStatusnew => scheduled
2008-11-06 11:13marvintmNote Added: 0010020
2008-11-06 11:13marvintmfix_in_branch => trunk
2008-11-06 11:16svnbotCheckin
2008-11-06 11:16svnbotNote Added: 0010023
2008-11-06 11:16svnbotStatusscheduled => resolved
2008-11-06 11:16svnbotResolutionopen => fixed
2008-11-06 11:16svnbotsvn_revision => 165
2008-11-06 11:16svnbotCheckin
2008-11-06 11:16svnbotNote Added: 0010024
2008-11-06 11:16svnbotsvn_revision165 => 9731
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-04-21 11:07psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777901

Notes
(0010020)
marvintm   
2008-11-06 11:13   
This will also be fixed for 2.4x.
(0010023)
svnbot   
2008-11-06 11:16   
Repository: dbsourcemanager
Revision: 165
Author: marvintm
Date: 2008-11-06 11:16:00 +0100 (Thu, 06 Nov 2008)

Fixed issue 5002. Now '' values, and null values, will be exported as null in PostgreSQL to standardize behaviour in our range of products.

---
U branches/dbsmmodularity/src/org/apache/ddlutils/io/DataWriter.java
U branches/dbsmmodularity/src/org/openbravo/ddlutils/task/ExportDataXMLMod.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=165&sc=1 [^]
(0010024)
svnbot   
2008-11-06 11:16   
Repository: openbravo
Revision: 9731
Author: marvintm
Date: 2008-11-06 11:16:43 +0100 (Thu, 06 Nov 2008)

Fixed issue 5002. Now '' values, and null values, will be exported as null in PostgreSQL to standardize behaviour in our range of products.

---
U branches/modularity/src-db/database/lib/dbsourcemanager.jar
U branches/modularity/src-db/database/lib/dbsourcemanagerlight.jar
---

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