Postgres Pro
Downloads
Home   >   mailing lists

BUG #15048: pg_trgm extension: <% and %> operators ignore wordboundaries - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15048: pg_trgm extension: <% and %> operators ignore wordboundaries
Date
Msg-id 151779751884.1243.13037281871936473992@wrigleys.postgresql.org
Whole thread Raw
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      15048
Logged by:          Dmitry Ryabov
Email address:      dmitry-ryabov@mail.ru
PostgreSQL version: 10.1
Operating system:   Debian 9
Description:

Affected versions: 9.6, 10. How to reproduce:
set pg_trgm.word_similarity_threshold = 0.5;
set pg_trgm.similarity_threshold = 0.5;

select
  /* space was ignored */
  'startstop' <% 'xxxxstar stopyyyy', 'xxxxstar stopyyyy' %> 'startstop',
  /* words tests */
  'startstop' %> 'stopyyyy', 'startstop' %> 'xxxxstar',
  'startstop' <% 'stopyyyy', 'startstop' <% 'xxxxstar',
  'startstop' % 'stopyyyy', 'startstop' % 'xxxxstar';

pgsql-bugs by date:

Previous
From: Keith Fiske
Date:
Subject: Re: BUG #15043: postgresql yum repository dependency problem
Next
From: PG Bug reporting form
Date:
Subject: BUG #15049: Initdb.exe failing to create DB