From: S.Çağlar Onur <caglar@cs.princeton.edu>
Date: Thu, 22 Jul 2010 20:46:22 +0000 (-0400)
Subject: use ILIKE instead of LIKE for case-insensitive searches
X-Git-Tag: plcapi-4.3-36~2
X-Git-Url: http://git.onelab.eu/?p=plcapi.git;a=commitdiff_plain;h=a2b3ff76d6d55a6085d44a90bc25858c261b9b43

use ILIKE instead of LIKE for case-insensitive searches
---

diff --git a/PLC/Filter.py b/PLC/Filter.py
index 520c6ff..ad412e1 100644
--- a/PLC/Filter.py
+++ b/PLC/Filter.py
@@ -176,7 +176,7 @@ class Filter(Parameter, dict):
                         value = "NULL"
                     elif isinstance(value, StringTypes) and \
                             (value.find("*") > -1 or value.find("%") > -1):
-                        operator = "LIKE"
+                        operator = "ILIKE"
                         # insert *** in pattern instead of either * or %
                         # we dont use % as requests are likely to %-expansion later on
                         # actual replacement to % done in PostgreSQL.py