View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0026133||mantisbt||db postgresql||public||2019-09-12 14:30||2019-09-12 15:22|
|Summary||0026133: 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.
|Tags||No tags attached.|