Summary | SQL module's LIKE operator broken if LHS contains uppercase characters |
Queue | Horde Framework Packages |
Type | Bug |
State | Resolved |
Priority | 1. Low |
Owners | selsky (at) columbia (dot) edu |
Requester | selsky (at) columbia (dot) edu |
Created | 05/25/2005 (7344 days ago) |
Due | |
Updated | 05/25/2005 (7344 days ago) |
Assigned | 05/25/2005 (7344 days ago) |
Resolved | 05/25/2005 (7344 days ago) |
Github Issue Link | |
Github Pull Request | |
Milestone | |
Patch | No |
State ⇒ Resolved
Assigned to Matt Selsky
State ⇒ Feedback
doesn't have anything about a problem. I think it'll be fine.
State ⇒ Unconfirmed
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ SQL module's LIKE operator broken if LHS contains uppercase characters
Queue ⇒ Horde Framework Packages
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?