Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0033647 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2016-08-08 10:01 | 2016-08-08 13:10 | |||
| Reporter | vmromanos | View Status | public | |||||
| Assigned To | platform | |||||||
| Priority | normal | Resolution | no change required | Fixed in Version | ||||
| Status | closed | 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 | vmromanos | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0033647: New function in index doesn't work (Oracle only) | |||||||
| Description | New created functions included in an index are not working fine in Oracle only. The update process seems to be changing the function name; original function name is "EQUALS", but it seems to be changed to "OGC_EQUALS": Finished preparing SQL SQL Command failed with: ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_EQUALS' ORA-06553: PLS-306: wrong number or types of arguments in call to 'OGC_EQUALS' -- END CREATE INDEX FIN_PAYMENT_BP_CREDIT_IX ON FIN_PAYMENT (C_BPARTNER_ID, EQUALS(GENERATED_CREDIT, USED_CREDIT)) Executed 13189 SQL command(s) with 1 error(s) | |||||||
| Steps To Reproduce | 1. Apply the attached patch in issue 0033581. It defines a function EQUALS inside the prescripts* files, which is linked to a new index in FIN_PAYMENT table. 2. Run ant smartbuild -Dlocal=no (or install source). Verify the error message in Description section is shown. Please note that this code is working fine for Postgresql (9.3) | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0088880) alostale (manager) 2016-08-08 11:39 edited on: 2016-08-08 11:40 |
The problem is caused because EQUALS is an internal Oracle function, if you run this before applying the patch, this is the result you get:SQL> desc equals FUNCTION equals RETURNS NUMBER(38) Argument Name Type In/Out Default? ------------------------------ ----------------------- ------ -------- G1 ST_GEOMETRY IN G2 ST_GEOMETRY IN Proposal, change function name. |
|
(0088888) vmromanos (manager) 2016-08-08 13:10 |
Wrongly reopened |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2016-08-08 10:01 | vmromanos | New Issue | |
| 2016-08-08 10:01 | vmromanos | Assigned To | => platform |
| 2016-08-08 10:01 | vmromanos | Modules | => Core |
| 2016-08-08 10:01 | vmromanos | Triggers an Emergency Pack | => No |
| 2016-08-08 10:02 | vmromanos | Relationship added | blocks 0033581 |
| 2016-08-08 11:39 | alostale | Note Added: 0088880 | |
| 2016-08-08 11:39 | alostale | Status | new => closed |
| 2016-08-08 11:39 | alostale | Resolution | open => no change required |
| 2016-08-08 11:40 | alostale | Note Edited: 0088880 | View Revisions |
| 2016-08-08 12:55 | vmromanos | Note Added: 0088885 | |
| 2016-08-08 12:55 | vmromanos | Status | closed => new |
| 2016-08-08 12:55 | vmromanos | Resolution | no change required => open |
| 2016-08-08 13:10 | vmromanos | Note Deleted: 0088885 | |
| 2016-08-08 13:10 | vmromanos | Review Assigned To | => vmromanos |
| 2016-08-08 13:10 | vmromanos | Note Added: 0088888 | |
| 2016-08-08 13:10 | vmromanos | Status | new => closed |
| 2016-08-08 13:10 | vmromanos | Resolution | open => no change required |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |