Actionb/MIZDB

Full text search: unexpected results when text search vector includes a forward slash

Actionb opened this issue · 0 comments

Example:
Ausgabe object with the name 2020/21-06 cannot be found when searching for 21 or 06 .

Cause:
Postgres recognizes the vector string as a file and uses the file parser, which does not split the string/token as expected.

SELECT * FROM ts_debug('simple_unaccent'::regconfig, '2020/21-06');
 alias |    description    |   token    | dictionaries | dictionary |   lexemes    
-------+-------------------+------------+--------------+------------+--------------
 file  | File or path name | 2020/21-06 | {simple}     | simple     | {2020/21-06}

 SELECT to_tsvector('2020/21-06');
  to_tsvector   
----------------
 '2020/21-06':1

Possible fixes: