BUG #12694: crash if the number of result rows is lower than gin_fuzzy_search_limit - Mailing list pgsql-bugs

From olaf.gw@googlemail.com
Subject BUG #12694: crash if the number of result rows is lower than gin_fuzzy_search_limit
Date
Msg-id 20150128181243.2579.80775@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #12694: crash if the number of result rows is lower than gin_fuzzy_search_limit  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12694
Logged by:          Olaf Gawenda
Email address:      olaf.gw@googlemail.com
PostgreSQL version: 9.4.0
Operating system:   Linux 3.2.0-4-amd64 #1 SMP Debian 3.2.65-1+deb7
Description:

the following sequence of commands get a crash if the numer of result rows
is lower than gin_fuzzy_search_limit:

create table test (t text, ts_vec tsvector);

insert into test (t) values (),(),(), ...; -- test data not posted

update test set ts_vec = to_tsvector('english', t);

create index on test using gin(ts_vec);
analyze test;
set enable_seqscan = off;
set gin_fuzzy_search_limit = 1000;

select t from test where ts_vec @@ to_tsquery('english', '...');

pgsql-bugs by date:

Previous
From: patrick@vanlaake.net
Date:
Subject: BUG #12690: EXECUTE statement fails with dynamic column name on record variable
Next
From: Stephen Frost
Date:
Subject: Re: RLS bug?