BUG #12694: crash if the number of result rows is lower than gin_fuzzy_search_limit

From: olaf(dot)gw(at)googlemail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12694: crash if the number of result rows is lower than gin_fuzzy_search_limit
Date: 2015-01-28 18:12:43
Message-ID: 20150128181243.2579.80775@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: 12694
Logged by: Olaf Gawenda
Email address: olaf(dot)gw(at)googlemail(dot)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', '...');

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Stephen Frost 2015-01-29 02:57:47 Re: RLS bug?
Previous Message Andres Freund 2015-01-28 15:26:03 Re: BUG #12670: Can't create postgis extension in single-user mode