Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004133Openbravo ERPY. DBSourceManagerpublic2008-06-23 18:292009-03-18 11:02
Reporterjpabloae 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionGentoo - 2.6.24
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
Summary0004133: PosgreSQL gives more date detail than Oracle
DescriptionAfter exporting the database in PostgreSQL, there may be times with miliseconds. Oracle doesn't accept them by default, so after creating the database and exporting them the result is not the same. This will lead to emerge false positives.

Example:

-- src-db/database/sourcedata/AD_TEXTINTERFACES.xml (revision 5312)
+++ src-db/database/sourcedata/AD_TEXTINTERFACES.xml (working copy)
@@ -36006,11 +36006,11 @@
 <!--1000400055 ISACTIVE-->
 <!--1000400055--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--1000400055 CREATED-->
-<!--1000400055--> <CREATED><![CDATA[2008-06-20 16:46:06.604027]]></CREATED>
+<!--1000400055--> <CREATED><![CDATA[2008-06-20 16:46:06.0]]></CREATED>
Steps To Reproduce
Proposed Solution
Additional Information
Tagsdbsm_migrate
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-23 18:29jpabloaeNew Issue
2008-06-25 09:37pjuvaraAssigned To => marvintm
2008-06-25 17:33svnbotCheckin
2008-06-25 17:33svnbotNote Added: 0008016
2008-06-25 17:33svnbotStatusnew => resolved
2008-06-25 17:33svnbotResolutionopen => fixed
2008-06-25 17:33svnbotsvn_revision => 5400
2008-11-26 12:56psarobeStatusresolved => 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 => 2691338

Notes
(0008016)
svnbot   
2008-06-25 17:33   
Repository: openbravo
Revision: 5400
Author: marvintm
Date: 2008-06-25 17:32:59 +0200 (Wed, 25 Jun 2008)

Fixed bug 0004133 Now nanoseconds will not be exported in dates.

---
U trunk/src-db/database/lib/dbsourcemanager.jar
---

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