Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007676Openbravo ERPY. DBSourceManagerpublic2009-02-19 12:522009-04-22 00:00
Reporterjpabloae 
Assigned Tomarvintm 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionGentoo - 2.6.27
Product Versionpi 
Target VersionFixed in Version2.50 
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
Summary0007676: Checks are exported in multiple lines in Oracle and only in one in PostgreSQL
DescriptionThe checks are exported into multiple lines when using Oracle. Example, in src-db/database/model/tables/AD_ORGTYPE.xml:

      <check name="AD_ORGTYPE_ISACCTLE_CHECK"><![CDATA[
ISACCTLEGALENTITY IN ('Y', 'N')
]]></check>

And PostgreSQL exports it this way:

<check name="AD_ORGTYPE_ISACCTLE_CHECK"><![CDATA[ISACCTLEGALENTITY IN ('Y', 'N')]]></check>

This is dangerous because the result is different in PostgreSQL and in Oracle.
Steps To Reproduce1. Check out trunk r13394
2. Configure it and run install.source
3. Put the core module in development in the AD_MODULE table.
4. Run "ant export.database -Dforce=yes"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-02-19 12:52jpabloaeNew Issue
2009-02-19 12:52jpabloaeAssigned To => marvintm
2009-02-19 12:52jpabloaeRegression testing => No
2009-02-24 11:52rafarodaSeverityminor => major
2009-02-24 11:52rafarodaStatusnew => scheduled
2009-03-03 11:45hgbotCheckin
2009-03-03 11:45hgbotNote Added: 0014285
2009-03-03 11:45hgbotStatusscheduled => resolved
2009-03-03 11:45hgbotResolutionopen => fixed
2009-03-03 12:37hgbotCheckin
2009-03-03 12:37hgbotNote Added: 0014295
2009-03-03 12:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a89cf175542a28fb572647c70acb7ee3cecb8486 [^]
2009-04-21 10:33psarobeStatusresolved => closed
2009-04-22 00:00anonymoussf_bug_id0 => 2777965

Notes
(0014285)
hgbot   
2009-03-03 11:45   
Repository: dbsourcemanager
Revision: 251
Author: marvintm
Date: 2009-03-03 11:45:40 +0100 (Tue, 03 Mar 2009)

Fixed issue 7676. Check constraints shouldn't be exported in multiple lines now.

---
U trunk/src/org/apache/ddlutils/platform/ModelLoaderBase.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=251&sc=1 [^]
(0014295)
hgbot   
2009-03-03 12:37   
Repository: erp/devel/pi
Changeset: a89cf175542a28fb572647c70acb7ee3cecb8486
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Mar 03 12:40:25 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/a89cf175542a28fb572647c70acb7ee3cecb8486 [^]

Fixed issue 7676. Check constraints shouldn't be exported in multiple lines now.

---
M src-db/database/lib/dbsourcemanager.jar
---