Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005002 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | always | 2008-09-10 10:45 | 2009-04-22 00:00 | |||
| Reporter | psarobe | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | pi | Fixed in SCM revision | 9731 | |||
| 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 | 0005002: Treatment for null and '' values in columns | |||||||
| Description | DBSource 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" /> | |||||||
| Tags | dbsm_migrate | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0010020) marvintm (developer) 2008-11-06 11:13 |
This will also be fixed for 2.4x. |
|
(0010023) svnbot (reporter) 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 (reporter) 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 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-09-10 10:45 | psarobe | New Issue | |
| 2008-09-10 10:45 | psarobe | Issue Monitored: psarobe | |
| 2008-09-12 13:39 | psarobe | Assigned To | => marvintm |
| 2008-11-06 11:13 | marvintm | Status | new => scheduled |
| 2008-11-06 11:13 | marvintm | Note Added: 0010020 | |
| 2008-11-06 11:13 | marvintm | fix_in_branch | => trunk |
| 2008-11-06 11:16 | svnbot | Checkin | |
| 2008-11-06 11:16 | svnbot | Note Added: 0010023 | |
| 2008-11-06 11:16 | svnbot | Status | scheduled => resolved |
| 2008-11-06 11:16 | svnbot | Resolution | open => fixed |
| 2008-11-06 11:16 | svnbot | svn_revision | => 165 |
| 2008-11-06 11:16 | svnbot | Checkin | |
| 2008-11-06 11:16 | svnbot | Note Added: 0010024 | |
| 2008-11-06 11:16 | svnbot | svn_revision | 165 => 9731 |
| 2008-12-18 12:38 | jpabloae | Sticky Issue | No => Yes |
| 2008-12-18 12:39 | jpabloae | Sticky Issue | Yes => No |
| 2008-12-18 12:39 | jpabloae | Tag Attached: dbsm_migrate | |
| 2008-12-18 12:41 | jpabloae | Project | @4@ => Openbravo ERP |
| 2008-12-18 12:41 | jpabloae | Category | => Y. DBSourceManager |
| 2009-04-21 11:07 | psarobe | Status | resolved => closed |
| 2009-04-22 00:00 | anonymous | sf_bug_id | 0 => 2777901 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |