Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004132 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Y. DBSourceManager | major | always | 2008-06-23 18:24 | 2009-03-18 11:02 | |||
| Reporter | jpabloae | View Status | public | |||||
| Assigned To | marvintm | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 5407 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.5.0_15 | |||
| OS Version | Gentoo - 2.6.24 | Database version | 8.3.3 | Ant version | 1.7.0 | |||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0004132: Create/export cycles differ in Oracle and PostgreSQL | |||||||
| Description | Creating 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> | |||||||
| Tags | dbsm_migrate | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0008018) svnbot (viewer) 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 (viewer) 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 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-06-23 18:24 | jpabloae | New Issue | |
| 2008-06-25 09:37 | pjuvara | Assigned To | => marvintm |
| 2008-06-26 00:24 | svnbot | Checkin | |
| 2008-06-26 00:24 | svnbot | Note Added: 0008018 | |
| 2008-06-26 00:24 | svnbot | Status | new => resolved |
| 2008-06-26 00:24 | svnbot | Resolution | open => fixed |
| 2008-06-26 00:24 | svnbot | svn_revision | => 5406 |
| 2008-06-26 01:05 | svnbot | Checkin | |
| 2008-06-26 01:05 | svnbot | Note Added: 0008019 | |
| 2008-06-26 01:05 | svnbot | svn_revision | 5406 => 5407 |
| 2008-11-26 12:55 | 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 => 2691337 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |