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

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0034209

Openbravo ERP

A. Platform

public

2016-10-14 12:52

2016-11-22 09:52

Reporter

inigosanchez

Assigned To

platform

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

closed

Resolution

duplicate

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

caristu

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

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

Description

A 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 Reproduce

1.- 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

Proposed Solution

Additional Information

Tags

No tags attached.

Relationships

duplicate of	defect	0034488		closed	caristu	Unsolvable dbconsistency problems in index functions
related to	defect	0033659		closed	inigosanchez	DB consistency error with function index (Oracle only)

Attached Files

try-dbcons-oracle-differences (858) 2016-10-14 12:52
https://issues.openbravo.com/file_download.php?file_id=9914&type=bug

try-dbcons-pgsql-differences (855) 2016-10-17 14:01
https://issues.openbravo.com/file_download.php?file_id=9920&type=bug

Issue History

Date Modified

Username

Field

Change

2016-10-14 12:52