View Issue Details

IDProjectCategoryView StatusLast Update
0026133mantisbtdb postgresqlpublic2019-09-12 15:22
ReporterShadowKatmandu Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status newResolutionopen 
Summary0026133: 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.

TagsNo tags attached.

Relationships

related to 0012145 confirmed Search should do case insensitive lookups 

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-09-12 14:30 ShadowKatmandu New Issue
2019-09-12 15:22 atrol Relationship added related to 0012145