View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0026133 | mantisbt | db postgresql | public | 2019-09-12 14:30 | 2023-02-14 05:09 |
Reporter | ShadowKatmandu | Assigned To | |||
Priority | normal | Severity | minor | Reproducibility | always |
Status | new | Resolution | open | ||
Summary | 0026133: Case sensitivity on View Issues searches | ||||
Description | With a case-sensitive back end (such as PostgreSQL), searches in View Issues are case-sensitive. There is code in core/classes/DbQuery.class.php to handle this, but it does not appear to get used. There is a function, sql_ilike, which calls sql_like with the final parameter set to true to force case insensitive searches. However, there are no calls to sql_ilike anywhere I could find. Setting $g_db_type to pgsql does not help; sql_like is still called with the final parameter set to the default set to false. In my opinion, this default should be set to true. The code only responds to a "true" setting if the back end is case-sensitive. | ||||
Tags | No tags attached. | ||||