Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xOlD5-00000000Jx5-1Wsu for pgsql-bugs@arkaria.postgresql.org; Thu, 05 Nov 2026 00:20:08 +0000 Received: from localhost ([127.0.0.1]:46356 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xOlD4-00000009Y6H-2OEY for pgsql-bugs@arkaria.postgresql.org; Thu, 05 Nov 2026 00:20:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]:41814) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xOlD4-00000009Y67-1KjE for pgsql-bugs@lists.postgresql.org; Thu, 05 Nov 2026 00:20:06 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xOlD1-00000000IeJ-3jXy for pgsql-bugs@lists.postgresql.org; Thu, 05 Nov 2026 00:20:06 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Content-Transfer-Encoding:Content-Type: Mime-Version:References:In-Reply-To:From:Subject:Cc:To:Message-Id:Date:Sender :Reply-To:Content-ID:Content-Description; bh=aJy1YAGcv3gi+P4OLJy0D2HfOTBu6WFa4FTyqRTcvxc=; b=3InmMtRuaDHM+zQiEhTkWVJyjy fJe8GJwJo5jk/lkDVoSzUyuP7qaFjA13kN8/eADZIc729rtg2MWwV9eJHSPD7jHq5zEtNKGMDtY4D xwkyGuU2clkyKzlOC2+mdd/i/tlSTzxhbEsk6X2ZoiDlHpG9pkrslrTWO5fMeEBLEKgWO2bzYANt3 gjFtMrdk51WKZ4edaeGMrwezpajfaMkTR3adeZIZxHDbI3UD0EpTsNJh6m42tVgZiJbicyltmZH8s S6uxJNjw7zPzutxevlzD/YBvfk02zA3VNBBjzBMYSKPO84GP4hGy8ChraqtfRVoAUhFAmL8IMkR/g wJ7unEDA==; Received: from [2409:11:4120:300:38e0:b7d5:109:e07e] (helo=localhost) by meldrar.postgresql.org with esmtpsa (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xOlCz-00000000aH3-153K; Thu, 05 Nov 2026 00:20:03 +0000 Date: Thu, 05 Nov 2026 09:19:47 +0900 (JST) Message-Id: <20261105.091947.1557138019099337522.ishii@postgresql.org> To: zhong950419@gmail.com Cc: c.bhuvan@iitg.ac.in, pgsql-bugs@lists.postgresql.org Subject: Re: first_value()/nth_value() with IGNORE NULLS loop forever (EXCLUDE GROUP/TIES, frame past partition end, no ORDER BY) From: Tatsuo Ishii In-Reply-To: References: <20261104.164415.1303787863463904189.ishii@postgresql.org> <20261104.184930.23012853607805816.ishii@postgresql.org> X-Mailer: Mew version 6.8 on Emacs 29.3 Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Host-Lookup-Failed: Reverse DNS lookup failed for 2409:11:4120:300:38e0:b7d5:109:e07e (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > Yes, the last_value test passes with or without the fix and only > guards against a later change to row_is_in_frame that returns -1 for > rows after the current row. The change to row_is_in_frame has not been decided in the community yet. Why we need to install a test for it now? Regards, -- Tatsuo Ishii SRA OSS K.K. English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp