tsearch bug in 7.2.1? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject tsearch bug in 7.2.1?
Date
Msg-id GNELIHDDFBOCMGBFGEFOCELHCDAA.chriskl@familyhealth.com.au
Whole thread Raw
Responses Re: tsearch bug in 7.2.1?
List pgsql-hackers
Hi,

I noticed this behaviour:

usa=# SELECT rr.id, rr.name, rr.description FROM recipe_recipes rr WHERE
rr.ftiidx ## 's';id  |               name               |
description
-----+----------------------------------+-----------------------------------
------------------------------------------------202 | Bird's Nest                      | An egg nestled in a crispy,
hot
bread roll.293 | Reuben Triple S                  | Corn beef, swiss cheese and
sauerkraut on pumpernickel. 30 | Hedgehogs                        | This is comfort food at it's
yummiest.130 | Hearty Apple & Cinnamon Porridge | A great way to warm you up on a
winter's morning. 83 | Banana & Apple Compote           | Great way to finish a meal on a
cool winter's day.139 | Minestrone                       | Served with a crusty roll, this
soup is a meal on it's own. 75 | Mango Sorbet                     | A mango-lover's delight. 19 | Chunky Vegetable
Chowder        | Serve this soup with a crusty roll
 
and it's a hearty meal on a cold winter's eve. 36 | Lemon Fish Rolls                 | A pleasant way to include fish
in
your family's diet.
(9 rows)

usa=# SELECT rr.id, rr.name, rr.description FROM recipe_recipes rr WHERE
rr.ftiidx ## 's|a';
ERROR:  Your query contained only stopword(s), ignored
usa=# SELECT rr.id, rr.name, rr.description FROM recipe_recipes rr WHERE
rr.ftiidx ## 's|x';id  |               name               |
description
-----+----------------------------------+-----------------------------------
------------------------------------------------202 | Bird's Nest                      | An egg nestled in a crispy,
hot
bread roll.293 | Reuben Triple S                  | Corn beef, swiss cheese and
sauerkraut on pumpernickel. 30 | Hedgehogs                        | This is comfort food at it's
yummiest.130 | Hearty Apple & Cinnamon Porridge | A great way to warm you up on a
winter's morning. 83 | Banana & Apple Compote           | Great way to finish a meal on a
cool winter's day.139 | Minestrone                       | Served with a crusty roll, this
soup is a meal on it's own. 75 | Mango Sorbet                     | A mango-lover's delight. 19 | Chunky Vegetable
Chowder        | Serve this soup with a crusty roll
 
and it's a hearty meal on a cold winter's eve. 36 | Lemon Fish Rolls                 | A pleasant way to include fish
in
your family's diet.
(9 rows)
usa=# SELECT rr.id, rr.name, rr.description FROM recipe_recipes rr WHERE
rr.ftiidx ## 'st|a';
ERROR:  Your query contained only stopword(s), ignored
usa=# SELECT rr.id, rr.name, rr.description FROM recipe_recipes rr WHERE
rr.ftiidx ## 'st|ar';id | name | description
----+------+-------------
(0 rows)

I don't see how that's correct?  Those ERRORs seem to be valid syntax to
me...

Chris



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: Open 7.3 issues
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: tsearch bug in 7.2.1?