• Status Closed
  • Percent Complete
  • Task Type Bug Report
  • Category Backend/Core
  • Assigned To
  • Operating System All
  • Severity Low
  • Priority Very Low
  • Reported Version
  • Due in Version 1.0
  • Due Date Undecided
  • Votes
  • Private
Attached to Project: Flyspray
Opened by Outdoor83 - 03.08.2009
Last edited by jahto - 19.03.2015

FS#1591 - PostgreSQL Advanced Search is Case-Sensitive; MySQL is appropriately Case-Insensitive

I apologize if this is a duplicate... I did search pretty hard for another filing.

Text searches are case-sensitive on PostgreSQL where they aren't on MySQL (I'm guessing MySQL is the desired behavior). When checking the code, it has to do with the use of the 'LIKE' keyword: it's case-insensitive on MySQL and case-sensitive on PostgreSQL.

I fixed it for my own uses by changing it to ILIKE instead (PostgreSQL-only), but a more generic approach would be more appropriate for Flyspray Proper. The Right Way To Fix This™ probably involves a change to ADOdb to allow for an abstraction of the LIKE keyword depending on the database in use. The Mostly-Right Way To Fix This would be to use something generic across MySQL and PostgreSQL like UPPER() or something to compare the data.

Closed by  jahto
19.03.2015 17:59
Reason for closing:  Fixed in devel
Project Manager

Assigned jahto to that, because he made postgresql tests before. :-)

jahto commented on 11.03.2015 21:38

Fixed in development version and will be in 1.0. But not in "The Right Way" or "The Mostly-Right Way", but just using ILIKE instead for PostgreSQL.


Available keyboard shortcuts


Task Details

Task Editing