Mercurial > hg > egg-tcls
changeset 110:4aa1e1d545ed
urllog and quotedb: Use SQL LIKE operator for username search terms to avoid unnecessary case-sensitivity.
author | Matti Hamalainen <ccr@tnsp.org> |
---|---|
date | Mon, 19 Sep 2011 21:19:50 +0300 |
parents | 74cb254dbf09 |
children | e09c791b2a48 |
files | quotedb.tcl urllog.tcl |
diffstat | 2 files changed, 2 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- a/quotedb.tcl Mon Sep 19 21:18:57 2011 +0300 +++ b/quotedb.tcl Mon Sep 19 21:19:50 2011 +0300 @@ -416,7 +416,7 @@ if {$fprefix == "-"} { lappend fpatlist "utext NOT LIKE '%[qdb_escape $fpattern]%'" } elseif {$fprefix == "%"} { - lappend fpatlist "user='[qdb_escape $fpattern]'" + lappend fpatlist "user LIKE '[qdb_escape $fpattern]'" } elseif {$fprefix == "@"} { # foo } elseif {$fprefix == "+"} {
--- a/urllog.tcl Mon Sep 19 21:18:57 2011 +0300 +++ b/urllog.tcl Mon Sep 19 21:19:50 2011 +0300 @@ -581,7 +581,7 @@ if {$fprefix == "-"} { lappend fpatlist "url NOT LIKE '%[urllog_escape $fpattern]%'" } elseif {$fprefix == "%"} { - lappend fpatlist "user='[urllog_escape $fpattern]'" + lappend fpatlist "user LIKE '[urllog_escape $fpattern]'" } elseif {$fprefix == "@"} { # foo } elseif {$prefix == "+"} {