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

From: Marcin(dot)Kasperski(at)mekk(dot)waw(dot)pl
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6327: Prefix full-text-search fails for hosts with complicated names
Date: 2011-12-05 12:40:10
Message-ID: E1RXXq6-0000vH-BA@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6327
Logged by: Marcin Kasperski
Email address: Marcin(dot)Kasperski(at)mekk(dot)waw(dot)pl
PostgreSQL version: 9.1.1
Operating system: Linux
Description:

Synopsis
=========

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

Example SQL
=============

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,
TO_TSVECTOR('english', 'See e-google.com') b) as foo;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Euler Taveira de Oliveira 2011-12-05 15:02:24 Re: BUG #6327: Prefix full-text-search fails for hosts with complicated names
Previous Message Noah Misch 2011-12-05 06:23:52 Re: possible bug seen with -DCLOBBER_CACHE_ALWAYS and changing GUCs