BUG #18835: spgist index fails to accept point with NaN

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #18835: spgist index fails to accept point with NaN
Дата
Msg-id 18835-deaf2add28625ed3@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #18835: spgist index fails to accept point with NaN
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      18835
Logged by:          Alexander Lakhin
Email address:      exclusion@gmail.com
PostgreSQL version: 17.4
Operating system:   Ubuntu 24.04
Description:

The following script:
CREATE TABLE t(p point);
INSERT INTO t SELECT point(g, g) FROM generate_series(1, 1000) g;
INSERT INTO t VALUES ('(0,NaN)'::point);

CREATE INDEX spgist_idx ON t USING spgist(p);
triggers:
ERROR:  XX000: getQuadrant: impossible case
LOCATION:  getQuadrant, spgquadtreeproc.c:77

Reproduced starting from 8daeb5ddd.

This anomaly is discovered with SQLsmith.


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