Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004132Openbravo ERPY. DBSourceManagerpublic2008-06-23 18:242009-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
Summary0004132: Create/export cycles differ in Oracle and PostgreSQL
DescriptionCreating the database, compiling, synchronizing terminology and exporting the databae gives different results in Oracle and PostgreSQL.

Diff example in Openbravo ERP, AD_TABLE.xml:

-<!--323--> <SQL_RECORD_IDENTIFIER><![CDATA[SELECT TO_CHAR(COALESCE(TO_CHAR(T.DocumentNo),''))||' - '||TO_CHAR(COALESCE(TO_CHAR(T.Name),'')) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, M_Movement T WHERE M_Movement_ID=:c_ID]]></SQL_RECORD_IDENTIFIER>
+<!--323--> <SQL_RECORD_IDENTIFIER><![CDATA[SELECT TO_CHAR(COALESCE(TO_CHAR(T.Name),''))||' - '||TO_CHAR(COALESCE(TO_CHAR(T.DocumentNo),'')) AS COLUMN_IDENTIFIER FROM (SELECT AD_LANGUAGE FROM AD_LANGUAGE WHERE AD_LANGUAGE=:c_language) L, M_Movement T WHERE M_Movement_ID=:c_ID]]></SQL_RECORD_IDENTIFIER>
 <!--323 DEVELOPMENTSTATUS-->
 <!--323--> <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--323**************--></AD_TABLE>
Steps To Reproduce
Proposed Solution
Additional Information
Tagsdbsm_migrate
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-06-23 18:24jpabloaeNew Issue
2008-06-25 09:37pjuvaraAssigned To => marvintm
2008-06-26 00:24svnbotCheckin
2008-06-26 00:24svnbotNote Added: 0008018
2008-06-26 00:24svnbotStatusnew => resolved
2008-06-26 00:24svnbotResolutionopen => fixed
2008-06-26 00:24svnbotsvn_revision => 5406
2008-06-26 01:05svnbotCheckin
2008-06-26 01:05svnbotNote Added: 0008019
2008-06-26 01:05svnbotsvn_revision5406 => 5407
2008-11-26 12:55psarobeStatusresolved => 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 => 2691337

Notes
(0008018)
svnbot   
2008-06-26 00:24   
Repository: openbravo
Revision: 5406
Author: cromeroherrero
Date: 2008-06-26 00:24:09 +0200 (Thu, 26 Jun 2008)

Fixed bug 4132: Create/export cycles differ in Oracle and PostgreSQL

---
U trunk/src-db/database/model/views/C_DEBT_PAYMENT_V.xml
U trunk/src-db/database/model/views/C_INVOICE_V.xml
U trunk/src-db/database/model/views/MA_PROCESSPLAN_TOTALIZED.xml
U trunk/src-db/database/model/views/RV_C_INVOICE.xml
U trunk/src-db/database/sourcedata/AD_COLUMN.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=5406&sc=1 [^]
(0008019)
svnbot   
2008-06-26 01:05   
Repository: openbravo
Revision: 5407
Author: cromeroherrero
Date: 2008-06-26 01:05:45 +0200 (Thu, 26 Jun 2008)

Fixed bug 4132: Create/export cycles differ in Oracle and PostgreSQL. There were two different issues: *unnecessary () in views that are removed by PostgreSQL but not in Oracle: the () have been removed *Columns identifiers with the same SEQNO, what provokes that the order can be interpreted different in Oracle and in PostgreSQL: now the data have been corrected and with this commit the AD_TABLE data should no be exported different

---
U trunk/src-db/database/sourcedata/AD_TABLE.xml
---

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