From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: xinwen@stu.scu.edu.cn
Subject: BUG #17819: The assert failed #17334 has not been repaired
Date: Thu, 02 Mar 2023 11:46:06 +0000
Message-ID: <17819-1e12c61d0829db39@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17819
Logged by: xin wen
Email address: xinwen@stu.scu.edu.cn
PostgreSQL version: 15.2
Operating system: Ubuntu 20.04
Description:
The assert failed reported in #17334
(https://www.postgresql.org/message-id/17334-135f485c21739caa%40postgresql.org)
has not been repaired.
When executing the following query:
CREATE TABLE point_tbl(f1 point);
CREATE INDEX gpointind ON point_tbl USING gist(f1);
INSERT INTO point_tbl SELECT ('0,0') FROM generate_series(1, 185);
INSERT INTO point_tbl VALUES ('0,NaN');
SET enable_seqscan=off; SELECT f1 <-> point '(0,0)' AS dist FROM point_tbl
ORDER BY dist;
The FailedAssertion("box->low.y <= box->high.y", File:
"/backend/access/gist/gistproc.c") will still occur.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, xinwen@stu.scu.edu.cn
Subject: Re: BUG #17819: The assert failed #17334 has not been repaired
In-Reply-To: <17819-1e12c61d0829db39@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox