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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0033647
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2016-08-08 10:012016-08-08 13:10
ReportervmromanosView Statuspublic 
Assigned Toplatform 
PrioritynormalResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Tovmromanos
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033647: New function in index doesn't work (Oracle only)

DescriptionNew 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 Reproduce1. 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)
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 00335813.0PR17Q2 closedvmromanos slow defaults retrieval in add payment 

-  Notes
(0088880)
alostale (viewer)
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 (viewer)
2016-08-08 13:10

 Wrongly reopened

- 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 OBNetwork customer => No
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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker