[Tickets #2030] NEW: SQL module's LIKE operator broken if LHS contains uppercase characters

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: https://dev.horde.org/horde/whups/ticket/?id=2030
-----------------------------------------------------------------------
 Ticket             | 2030
 Created By         | Matt Selsky <selsky at columbia.edu>
 Summary            | SQL module's LIKE operator broken if LHS contains uppercase characters
 Queue              | Horde Framework Packages
 State              | Unconfirmed
 Priority           | 1. Low
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


Matt Selsky <selsky at columbia.edu> (2005-05-25 03:20) wrote:

I'm using Kronolith (with an Oracle backend) to search for events with title
"Meeting".  This generates SQL similar to:

select * from kronolith_events where event_title like lower('%Meeting%');

This returns no results since my events use "Meeting" with a capital "M" and
we search for '%meeting%' essentially.

framework/SQL/SQL.php says:

 case 'LIKE':
            if ($dbh->phptype == 'pgsql') {
                $query = '%s ILIKE %s';
            } else {
                $query = '%s LIKE LOWER(%s)';
            }

Why was the LOWER() function removed from the LHS in 1.20?

http://cvs.horde.org/diff.php/framework/SQL/SQL.php?r1=1.19&r2=1.20&ty=u

Any reason not revert that?