diff options
| author | M Somerville <matthew-github@dracos.co.uk> | 2020-08-05 15:55:29 +0100 |
|---|---|---|
| committer | M Somerville <matthew-github@dracos.co.uk> | 2020-08-06 20:28:57 +0100 |
| commit | 21efead606530cb754bb7b54586dbb8c1a1502ca (patch) | |
| tree | a143c488adb35be9ed06a5c7632a7f9331ea3c12 | |
| parent | 52b1410f91669fab5f22cae9a9d9a040a0144c9a (diff) | |
Perform translate on full text search query too.
| -rw-r--r-- | perllib/FixMyStreet/Roles/FullTextSearch.pm | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/perllib/FixMyStreet/Roles/FullTextSearch.pm b/perllib/FixMyStreet/Roles/FullTextSearch.pm index 78dbd5c18..dc7730798 100644 --- a/perllib/FixMyStreet/Roles/FullTextSearch.pm +++ b/perllib/FixMyStreet/Roles/FullTextSearch.pm @@ -13,9 +13,11 @@ sub search_text { my $col = $rs->me($_); $nulls{$_} ? "coalesce($col, '')" : $col; } $rs->text_search_columns; - my $vector = "translate(" . join(" || ' ' || ", @cols) . ", '/.', ' ')"; + my $vector = join(" || ' ' || ", @cols); + $vector = "translate($vector, '/.', ' ')"; + my $bind = "translate(?, '/.', ' ')"; my $config = FixMyStreet->config('DB_FULL_TEXT_SEARCH_CONFIG') || 'english'; - $rs->search(\[ "to_tsvector('$config', $vector) @@ plainto_tsquery('$config', ?)", $query ]); + $rs->search(\[ "to_tsvector('$config', $vector) @@ plainto_tsquery('$config', $bind)", $query ]); } 1; |