View Issue Details

IDProjectCategoryView StatusLast Update
0026133mantisbtdb postgresqlpublic2019-09-12 15:22
ReporterShadowKatmandu Assigned To 
Status newResolutionopen 
Summary0026133: Case sensitivity on View Issues searches

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.


related to 0012145 confirmed Search should do case insensitive lookups 


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