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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0034209
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2016-10-14 12:522016-11-22 09:52
ReporterinigosanchezView Statuspublic 
Assigned Toplatform 
PrioritynormalResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tocaristu
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0034209: DB consistency error with function index with 2 or more parameters separated by blank space or not

DescriptionA new function is defined in the prescript-Oracle.sql. This function is linked to a function index in any table.

The install source and update database processes are working fine, however the export database modifies the function index definition. See attached file: try-dbcons-oracle-differences.
Steps To Reproduce1.- Apply the attached patch in issue 0033581. It defines a function called OBEQUALS inside the prescripts* files, which is linked to a new index in FIN_PAYMENT table.

*Note than functionExpression is defined with a blank space between parameters:
+ <index-column name="functionBasedColumn" functionExpression="OBEQUALS(GENERATED_CREDIT, USED_CREDIT)"/>

2.- Run ant smartbuild -Dlocal=no (or install source). Verify it works fine.
3.- Set Core in development.
4.- Run ant export.database. Verify the index definition has changed. This creates a db consistency problem

Please note that this code is working fine for Postgresql (9.3)

Otherwise, If you define this functionExpression without blank space between parameters, the problem is raised in db consistency of postgresql:

*For this case functionExpression is defined without a blank space between parameters:
+ <index-column name="functionBasedColumn" functionExpression="OBEQUALS(GENERATED_CREDIT,USED_CREDIT)"/>

Repeat steps defined above. See attached file to see the results of the export database: try-dbcons-pgsql-differences
TagsNo tags attached.
Attached Files? file icon try-dbcons-oracle-differences [^] (858 bytes) 2016-10-14 12:52 [Show Content]
? file icon try-dbcons-pgsql-differences [^] (855 bytes) 2016-10-17 14:01 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of defect 0034488 closedcaristu Unsolvable dbconsistency problems in index functions 
related to defect 0033659 closedinigosanchez DB consistency error with function index (Oracle only) 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2016-10-14 12:52 inigosanchez New Issue
2016-10-14 12:52 inigosanchez Assigned To => platform
2016-10-14 12:52 inigosanchez File Added: try-dbcons-oracle-differences
2016-10-14 12:52 inigosanchez Modules => Core
2016-10-14 12:52 inigosanchez Triggers an Emergency Pack => No
2016-10-14 12:53 inigosanchez Relationship added related to 0033659
2016-10-14 12:53 inigosanchez Steps to Reproduce Updated View Revisions
2016-10-17 14:01 inigosanchez Summary DB consistency error with function index with 2 or more parameters separated by blank space (Oracle only) => DB consistency error with function index with 2 or more parameters separated by blank space or not
2016-10-17 14:01 inigosanchez Description Updated View Revisions
2016-10-17 14:01 inigosanchez Steps to Reproduce Updated View Revisions
2016-10-17 14:01 inigosanchez File Added: try-dbcons-pgsql-differences
2016-11-22 09:52 inigosanchez Review Assigned To => caristu
2016-11-22 09:52 inigosanchez Relationship added duplicate of 0034488
2016-11-22 09:52 inigosanchez Status new => closed
2016-11-22 09:52 inigosanchez Resolution open => duplicate

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker