Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0005843 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] Y. DBSourceManager | major | always | 2008-11-06 11:13 | 2009-05-21 16:37 | |||
| Reporter | psarobe | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | 0.8x | Fixed in SCM revision | 10371 | |||
| 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 | 0005843: 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 |
|
|
(0010021) svnbot (reporter) 2008-11-06 11:14 |
Repository: dbsourcemanager Revision: 164 Author: marvintm Date: 2008-11-06 11:14:33 +0100 (Thu, 06 Nov 2008) Fixed issue 5843. Now '' values, and null values, will be exported as null in PostgreSQL to standardize behaviour in our range of products. --- U branches/r0.8x/src/org/apache/ddlutils/io/DataWriter.java --- https://dev.openbravo.com/websvn/dbsourcemanager/?rev=164&sc=1 [^] |
|
(0010022) svnbot (reporter) 2008-11-06 11:15 |
Repository: openbravo Revision: 9730 Author: marvintm Date: 2008-11-06 11:15:04 +0100 (Thu, 06 Nov 2008) Fixed issue 5843. Now '' values, and null values, will be exported as null in PostgreSQL to standardize behaviour in our range of products. Also, fixed a blank space in a function file. --- U branches/r2.40/src-db/database/lib/dbsourcemanager.jar U branches/r2.40/src-db/database/model/functions/GET_PARETO_ABC.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=9730&sc=1 [^] |
|
(0010484) svnbot (reporter) 2008-11-20 23:00 |
Repository: openbravo Revision: 10371 Author: villind Date: 2008-11-20 23:00:11 +0100 (Thu, 20 Nov 2008) Merged r9730. Fixed issue 5843. Now '' values, and null values, will be exported as null in PostgreSQL to standardize behaviour in our range of products. Also, fixed a blank space in a function file. --- _U branches/bonware/r2.40/ _U branches/bonware/r2.40/config/setup-tool/ _U branches/bonware/r2.40/eclipse.install.source.launch _U branches/bonware/r2.40/export.database.launch _U branches/bonware/r2.40/src-core/src/org/openbravo/database/OpenbravoDriverManagerConnectionFactory.java U branches/bonware/r2.40/src-db/database/lib/dbsourcemanager.jar _U branches/bonware/r2.40/update.database.launch --- https://dev.openbravo.com/websvn/openbravo/?rev=10371&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-11-06 11:13 | marvintm | New Issue | |
| 2008-11-06 11:13 | marvintm | Assigned To | => marvintm |
| 2008-11-06 11:13 | marvintm | Status | new => scheduled |
| 2008-11-06 11:14 | svnbot | Checkin | |
| 2008-11-06 11:14 | svnbot | Note Added: 0010021 | |
| 2008-11-06 11:14 | svnbot | Status | scheduled => resolved |
| 2008-11-06 11:14 | svnbot | Resolution | open => fixed |
| 2008-11-06 11:14 | svnbot | svn_revision | => 164 |
| 2008-11-06 11:15 | svnbot | Checkin | |
| 2008-11-06 11:15 | svnbot | Note Added: 0010022 | |
| 2008-11-06 11:15 | svnbot | svn_revision | 164 => 9730 |
| 2008-11-20 23:00 | svnbot | Checkin | |
| 2008-11-20 23:00 | svnbot | Note Added: 0010484 | |
| 2008-11-20 23:00 | svnbot | svn_revision | 9730 => 10371 |
| 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-05-21 16:37 | psarobe | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |