Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0025221 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| design defect | [Openbravo ERP] A. Platform | major | have not tried | 2013-11-26 23:48 | 2014-07-22 07:54 | |||||||
| 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 | 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. | |||||||||||
| Tags | Performance | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2013-11-26 23:48 | AugustoMauch | New Issue | |
| 2013-11-26 23:48 | AugustoMauch | Assigned To | => AugustoMauch |
| 2013-11-26 23:48 | AugustoMauch | Modules | => Core |
| 2013-11-26 23:48 | AugustoMauch | Triggers an Emergency Pack | => No |
| 2013-11-26 23:48 | AugustoMauch | Relationship added | depends on 0025211 |
| 2014-07-22 07:54 | alostale | Tag Attached: Performance | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |