summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorMax Kanat-Alexander <mkanat@bugzilla.org>2010-07-09 00:57:21 +0200
committerMax Kanat-Alexander <mkanat@bugzilla.org>2010-07-09 00:57:21 +0200
commit2e756dd204328d22836054cbc726a53ca222faa8 (patch)
treedf3263409e6bea9949f63dcd1557cc0c4dad074a
parentaf5698b499f43761e3604f4520532e1c287cb095 (diff)
downloadbugzilla-2e756dd204328d22836054cbc726a53ca222faa8.tar.gz
bugzilla-2e756dd204328d22836054cbc726a53ca222faa8.tar.xz
Bug 577569: [PostgreSQL] Make sql_position explicitly cast both its arguments
to text, to avoid an error when searching "longdescs.isprivate" with the "casesubstring" operator in Search.pm. r=mkanat, a=mkanat (module owner)
-rw-r--r--Bugzilla/DB/Pg.pm2
1 files changed, 1 insertions, 1 deletions
diff --git a/Bugzilla/DB/Pg.pm b/Bugzilla/DB/Pg.pm
index 018900129..7aaafd88f 100644
--- a/Bugzilla/DB/Pg.pm
+++ b/Bugzilla/DB/Pg.pm
@@ -117,7 +117,7 @@ sub sql_istring {
sub sql_position {
my ($self, $fragment, $text) = @_;
- return "POSITION($fragment IN ${text}::text)";
+ return "POSITION(${fragment}::text IN ${text}::text)";
}
sub sql_regexp {