Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0038705 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| feature request | [Openbravo ERP] Y. DBSourceManager | minor | have not tried | 2018-06-05 17:02 | 2022-02-01 08:08 | ||||||
| Reporter | caristu | View Status | public | ||||||||
| Assigned To | Triage Platform Base | ||||||||||
| Priority | high | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Any | Database | Oracle | Java version | |||||||
| OS Version | Database version | Ant version | |||||||||
| Product Version | SCM revision | ||||||||||
| Review Assigned To | |||||||||||
| Web browser | |||||||||||
| Modules | Core | ||||||||||
| Regression level | |||||||||||
| Regression date | |||||||||||
| Regression introduced in release | |||||||||||
| Regression introduced by commit | |||||||||||
| Triggers an Emergency Pack | No | ||||||||||
| Summary | 0038705: DB Functions returning CLOB type are not supported in Oracle | ||||||||||
| Description | Currently it is possible to define functions that return the text type in PostgreSQL. When exporting such functions in Oracle, this return type is stored as CLOB within the xml definition. But when installing a function like that in Oracle an error is thrown during update.database task. | ||||||||||
| Steps To Reproduce | 1) Apply the attached patch 2) Using PostgreSQL, execute ant smartbuild -Dlocal=no. OK 3) Using Oracle, execute ant smartbuild -Dlocal=no. It fails. | ||||||||||
| Proposed Solution | The return type is exported as CLOB. This type is currently not being mapped properly for Oracle by DBSM. - Postgres type mapping: https://code.openbravo.com/erp/devel/dbsm-main/file/tip/src/org/apache/ddlutils/platform/postgresql/PostgreSqlPlatform.java#l69 [^] - Oracle type mapping: https://code.openbravo.com/erp/devel/dbsm-main/file/8d1a581a7dcb/src/org/apache/ddlutils/platform/oracle/OraclePlatform.java#l87 [^] Decide how to map it | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files |  dbfunction.diff [^] (498 bytes) 2018-06-05 17:07 [Show Content]
| ||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||
|
|||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2018-06-05 17:02 | caristu | New Issue | |
| 2018-06-05 17:02 | caristu | Assigned To | => platform |
| 2018-06-05 17:02 | caristu | Modules | => Core |
| 2018-06-05 17:02 | caristu | Triggers an Emergency Pack | => No |
| 2018-06-05 17:02 | caristu | Category | A. Platform => Y. DBSourceManager |
| 2018-06-05 17:07 | caristu | File Added: dbfunction.diff | |
| 2018-06-05 17:16 | caristu | Summary | DB Functions returning text type are not supported in Oracle => DB Functions returning CLOB type are not supported in Oracle |
| 2018-06-05 17:16 | caristu | Description Updated | View Revisions |
| 2018-06-06 09:59 | psanjuan | Relationship added | causes 0038691 |
| 2018-06-15 11:01 | alostale | Status | new => acknowledged |
| 2018-06-15 11:01 | alostale | Type | defect => feature request |
| 2018-08-24 10:38 | caristu | Proposed Solution updated | |
| 2022-02-01 08:08 | alostale | Assigned To | platform => Triage Platform Base |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |