0030488: API Change: Replacement of LOWER with UPPER in queries

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0030488

Openbravo ERP

A. Platform

public

2015-08-04 09:21

2015-11-11 12:16

Reporter

AugustoMauch

Assigned To

platform

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

closed

Resolution

suspended

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

0030488: API Change: Replacement of LOWER with UPPER in queries

Description

In order to solve this feature request [1], all instances of the LOWER function in SQL queries throughout the Openbravo codebase are going to be replaced with upper.

It is going to be done ensuring that the results returned by the queries does not change, but it is possible that some of those queries could take more time to execute for users that have defined function based indexes using the lower function, thus this change can be considered somewhat of an API change.

Note that Openbravo will not start giving support to function based indexes until PR15Q4, so if someone had defined those indexes, they would have to maintain them themselves (there was no way to export/import them)

[1] https://issues.openbravo.com/view.php?id=30476 [^]

Steps To Reproduce

Proposed Solution

Additional Information

Tags

Approved

Relationships

related to	feature request	0030476		new	AugustoMauch	Consolidate the user of UPPER/LOWER to achieve case insensitive filtering
related to	feature request	0030561		closed	AugustoMauch	Use UPPER to achieve case insensitive filtering in CustomQuerySelectorDatasource