Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0030476 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| feature request | [Openbravo ERP] A. Platform | major | have not tried | 2015-07-31 14:21 | 2015-07-31 14:24 | |||||||
| Reporter | AugustoMauch | View Status | public | |||||||||
| Assigned To | AugustoMauch | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | SCM revision | |||||||||||
| Review Assigned To | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0030476: Consolidate the user of UPPER/LOWER to achieve case insensitive filtering | |||||||||||
| Description | Although most of the times we use the UPPER function to achieve case insensitive filtering, there are a few cases where we use the LOWER function. In some cases it is possible to define a function based index that can be used to do case insensitive filtering. If both UPPER and LOWER are used throughout the OB codebase, it will be needed to define UPPER and LOWER function based indexes for them. For this reason it is better to use only UPPER or LOWER. | |||||||||||
| Steps To Reproduce | Look in the Openbravo codebase for instances of UPPER and LOWER. You will find that UPPER instances appear almost 10x more ofthen than LOWER ones | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||||||||||||||||
|
||||||||||||||||||||||
 Relationships |
|
Notes |
|
|
(0079149) AugustoMauch (manager) 2015-07-31 14:24 |
Taking into account the nowadays UPPER is used around 10 times more often than LOWER, all the instances of LOWER are going to be replaced with UPPER. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2015-07-31 14:21 | AugustoMauch | New Issue | |
| 2015-07-31 14:21 | AugustoMauch | Assigned To | => AugustoMauch |
| 2015-07-31 14:21 | AugustoMauch | Modules | => Core |
| 2015-07-31 14:21 | AugustoMauch | Triggers an Emergency Pack | => No |
| 2015-07-31 14:24 | AugustoMauch | Note Added: 0079149 | |
| 2015-07-31 14:57 | AugustoMauch | Relationship added | related to 0030477 |
| 2015-08-04 09:22 | AugustoMauch | Relationship added | related to 0030488 |
| 2015-08-12 14:56 | AugustoMauch | Relationship added | related to 0030561 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |