Add 2 missing LOWER()'s to fix non-recursive case of

get_subcontainers_of_container query.

diff --git a/server/qsupport.pc b/server/qsupport.pc
index 8a441d3b0baab35fc3645be5856fc0236e8f4944..4d489953fa1336ab6e7150622a05364a5a15a5f9 100644 (file)
--- a/server/qsupport.pc
+++ b/server/qsupport.pc
@@ -2113,7 +2113,7 @@ int get_subcontainers_of_container(struct query *q, char *argv[], client *cl,
   strcpy(querystring, "SELECT name FROM containers ");
   
   if (!isrecursive)
-    sprintf(tmp, "WHERE LOWER(name) LIKE '%s/%%' and name NOT LIKE LOWER('%s/%%/%%') ",
+    sprintf(tmp, "WHERE LOWER(name) LIKE LOWER('%s/%%') and LOWER(name) NOT LIKE LOWER('%s/%%/%%') ",
            containername, containername);
   else
     sprintf(tmp, "WHERE LOWER(name) LIKE LOWER('%s/%%') ", containername);