Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0004133
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajoralways2008-06-23 18:292009-03-18 11:02
ReporterjpabloaeView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision5400
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.5.0_15
OS VersionGentoo - 2.6.24Database version8.3.3Ant version1.7.0
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0004133: 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>
Tagsdbsm_migrate
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0008016)
svnbot (reporter)
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 [^]

- Issue History
Date Modified Username Field Change
2008-06-23 18:29 jpabloae New Issue
2008-06-25 09:37 pjuvara Assigned To => marvintm
2008-06-25 17:33 svnbot Checkin
2008-06-25 17:33 svnbot Note Added: 0008016
2008-06-25 17:33 svnbot Status new => resolved
2008-06-25 17:33 svnbot Resolution open => fixed
2008-06-25 17:33 svnbot svn_revision => 5400
2008-11-26 12:56 psarobe Status resolved => closed
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-03-18 11:02 anonymous sf_bug_id 0 => 2691338


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker