From b1220d1f71a4f2c6e75a5f2b4f4d8ad2bcb72f24 Mon Sep 17 00:00:00 2001
From: zacheiss <zacheiss>
Date: Fri, 2 Aug 2002 15:12:27 +0000
Subject: [PATCH] Add 2 missing LOWER()'s to fix non-recursive case of
 get_subcontainers_of_container query.

---
 server/qsupport.pc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/server/qsupport.pc b/server/qsupport.pc
index 8a441d3b..4d489953 100644
--- 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);
-- 
2.45.2