pgsql: Fix contrib/pg_trgm's similarity() function for trigram-free str

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pgsql: Fix contrib/pg_trgm's similarity() function for trigram-free str
Дата
Msg-id E1U5hgS-0005bm-S8@gemulon.postgresql.org
обсуждение исходный текст
Список pgsql-committers
Fix contrib/pg_trgm's similarity() function for trigram-free strings.

Cases such as similarity('', '') produced a NaN result due to computing
0/0.  Per discussion, make it return zero instead.

This appears to be the basic cause of bug #7867 from Michele Baravalle,
although it remains unclear why her installation doesn't think Cyrillic
letters are letters.

Back-patch to all active branches.

Branch
------
REL9_2_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/7b058a2dc8fd5889cd443fd6ee40f51068357245

Modified Files
--------------
contrib/pg_trgm/expected/pg_trgm.out |    6 ++++++
contrib/pg_trgm/sql/pg_trgm.sql      |    2 ++
contrib/pg_trgm/trgm_op.c            |    8 ++++++--
3 files changed, 14 insertions(+), 2 deletions(-)


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: pgsql: Fix contrib/pg_trgm's similarity() function for trigram-free str
Следующее
От: Tom Lane
Дата:
Сообщение: pgsql: Fix CVE-2013-0255 properly.