0025221: The query done when filtering a foreign key column should be improved

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0025221

Openbravo ERP

A. Platform

public

2013-11-26 23:48

2014-07-22 07:54

Reporter

AugustoMauch

Assigned To

AugustoMauch

Priority

normal

Severity

major

Reproducibility

have not tried

Status

new

Resolution

open

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Review Assigned To

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

0025221: The query done when filtering a foreign key column should be improved

Description

When the user filters a foreign key column, the generated query contains this:

upper((COALESCE(to_char(join_0.name),''))) like :alias_1 escape '|' ))

The coalesce and the to_char functions are applied over the referenced column. This prevents the database from using any indexes on that column.

The coalesce function is only needed when the table identifier is formed by several columns. The to_char function is needed in that case too, if any of those columns is not a varchar.

Steps To Reproduce

- Open Sales Order
- Enter any text in the organization filter
- Check that the query generated uses the functions defined in the description

Proposed Solution

Do not use the coalesce and to_char functions unless the table identifier is formed by several columns.

Additional Information