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
Re: BUG #6327: Prefix full-text-search fails for hosts with complicated names |
| Список | 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 по дате отправления: