Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXlUX-00089b-AK for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Mar 2023 16:09:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pXlUU-0007dP-K9 for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Mar 2023 16:09:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXlUU-0007dG-C5 for pgsql-bugs@lists.postgresql.org; Thu, 02 Mar 2023 16:09:10 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pXlUN-00085j-2y for pgsql-bugs@lists.postgresql.org; Thu, 02 Mar 2023 16:09:09 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 322G908s1908491; Thu, 2 Mar 2023 11:09:01 -0500 From: Tom Lane To: xinwen@stu.scu.edu.cn cc: pgsql-bugs@lists.postgresql.org Subject: Re: BUG #17819: The assert failed #17334 has not been repaired In-reply-to: <17819-1e12c61d0829db39@postgresql.org> References: <17819-1e12c61d0829db39@postgresql.org> Comments: In-reply-to PG Bug reporting form message dated "Thu, 02 Mar 2023 11:46:06 +0000" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1908489.1677773340.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Thu, 02 Mar 2023 11:09:00 -0500 Message-ID: <1908490.1677773340@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PG Bug reporting form writes: > The assert failed reported in #17334 > (https://www.postgresql.org/message-id/17334-135f485c21739caa%40postgres= ql.org) > has not been repaired. If supporting NaNs in geometric types excites you, then by all means step up and work on it, but it's not a high-priority thing for most of us. We've put some effort into the area before (e.g. [1]) but arriving at self-consistent definitions is hard, and implementing them is messy, and TBH the geometric types are a development backwater in the first place. At this point I'd be about ready to forbid NaNs in geometric types. But even making that happen is work that nobody's volunteered for. regards, tom lane [1] https://www.postgresql.org/message-id/flat/CAGf+fX70rWFOk5cd00uMfa__0y= P+vtQg5ck7c2Onb-Yczp0URA@mail.gmail.com