diff roundup/backends/back_mysql.py @ 3147:dbf80d7db63f

consistent text searching behaviour (AND everywhere) [SF#1101036]
author Richard Jones <richard@users.sourceforge.net>
date Sun, 13 Feb 2005 22:38:57 +0000
parents 2487b070043b
children 57b60bda9473
line wrap: on
line diff
--- a/roundup/backends/back_mysql.py	Sun Feb 13 22:04:32 2005 +0000
+++ b/roundup/backends/back_mysql.py	Sun Feb 13 22:38:57 2005 +0000
@@ -1,4 +1,4 @@
-#$Id: back_mysql.py,v 1.54 2005-02-13 21:15:04 richard Exp $
+#$Id: back_mysql.py,v 1.55 2005-02-13 22:37:00 richard Exp $
 #
 # Copyright (c) 2003 Martynas Sklyzmantas, Andrey Lebedev <andrey@micro.lt>
 #
@@ -573,7 +573,7 @@
 
                 # now add to the where clause
                 where.append('('
-                    +' or '.join(["_%s._%s LIKE '%s'"%(cn, k, s) for s in v])
+                    +' and '.join(["_%s._%s LIKE '%s'"%(cn, k, s) for s in v])
                     +')')
                 # note: args are embedded in the query string now
             elif isinstance(propclass, Link):

Roundup Issue Tracker: http://roundup-tracker.org/