From 27d7455edb329f590aa55b3932500b74f9926855 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Wed, 1 Apr 2009 20:00:47 +0000 Subject: - Patch #333054 by c960657: page cache should be case sensitive. --- modules/user/user.module | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) (limited to 'modules/user') diff --git a/modules/user/user.module b/modules/user/user.module index ac15ecdbe..c6ccc530e 100644 --- a/modules/user/user.module +++ b/modules/user/user.module @@ -216,14 +216,12 @@ function user_load_multiple($uids = array(), $conditions = array(), $reset = FAL } // If the conditions array is populated, add those to the query. if ($conditions) { - // TODO D7: Using LIKE() to get a case insensitive comparison because Crell - // and chx promise that dbtng will map it to ILIKE in postgres. if (isset($conditions['name'])) { - $query->condition('u.name', $conditions['name'], 'LIKE'); + $query->where('LOWER(u.name) = LOWER(:name)', array(':name' => $conditions['name'])); unset($conditions['name']); } if (isset($conditions['mail'])) { - $query->condition('u.mail', $conditions['mail'], 'LIKE'); + $query->where('LOWER(u.mail) = LOWER(:mail)', array(':mail' => $conditions['mail'])); unset($conditions['mail']); } foreach ($conditions as $field => $value) { -- cgit v1.2.3