BUG #6327: Prefix full-text-search fails for hosts with complicated names

Поиск
Список
Период
Сортировка
От Marcin.Kasperski@mekk.waw.pl
Тема BUG #6327: Prefix full-text-search fails for hosts with complicated names
Дата
Msg-id E1RXXq6-0000vH-BA@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #6327: Prefix full-text-search fails for hosts with complicated names  (Euler Taveira de Oliveira <euler@timbira.com>)
Re: BUG #6327: Prefix full-text-search fails for hosts with complicated names  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6327
Logged by:          Marcin Kasperski
Email address:      Marcin.Kasperski@mekk.waw.pl
PostgreSQL version: 9.1.1
Operating system:   Linux
Description:=20=20=20=20=20=20=20=20

Synopsis
=3D=3D=3D=3D=3D=3D=3D=3D=3D

'goog:*'  matches  google.com
but
'e-goog:*' does not match e-google.com

Example SQL
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

Try the queries below. Note ismatch column, which is t in the former, and f
in the latter case (IMHO should be t in both).

SELECT a query, b message, a@@b ismatch FROM (
   SELECT TO_TSQUERY('english', 'goog:*') a,
          TO_TSVECTOR('english', 'See google.com') b) as foo;

SELECT a query, b message, a@@b ismatch FROM (
   SELECT TO_TSQUERY('english', 'e-goog:*') a,=20
          TO_TSVECTOR('english', 'See e-google.com') b) as foo;

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: possible bug seen with -DCLOBBER_CACHE_ALWAYS and changing GUCs
Следующее
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: BUG #6327: Prefix full-text-search fails for hosts with complicated names