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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0007676
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajoralways2009-02-19 12:522009-04-22 00:00
ReporterjpabloaeView Statuspublic 
Assigned Tomarvintm 
PriorityhighResolutionfixedFixed in Version2.50
StatusclosedFix in branchFixed in SCM revisiona89cf175542a
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionGentoo - 2.6.27Database version8.3.5Ant version1.7.1
Product VersionpiSCM revision13394 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007676: 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"
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0014285)
hgbot (developer)
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 (developer)
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
---

- Issue History
Date Modified Username Field Change
2009-02-19 12:52 jpabloae New Issue
2009-02-19 12:52 jpabloae Assigned To => marvintm
2009-02-19 12:52 jpabloae Regression testing => No
2009-02-24 11:52 rafaroda Severity minor => major
2009-02-24 11:52 rafaroda Status new => scheduled
2009-03-03 11:45 hgbot Checkin
2009-03-03 11:45 hgbot Note Added: 0014285
2009-03-03 11:45 hgbot Status scheduled => resolved
2009-03-03 11:45 hgbot Resolution open => fixed
2009-03-03 12:37 hgbot Checkin
2009-03-03 12:37 hgbot Note Added: 0014295
2009-03-03 12:37 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a89cf175542a28fb572647c70acb7ee3cecb8486 [^]
2009-04-21 10:33 psarobe Status resolved => closed
2009-04-22 00:00 anonymous sf_bug_id 0 => 2777965


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker