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 1xP7mA-00000000V3z-362n for pgsql-bugs@arkaria.postgresql.org; Fri, 06 Nov 2026 00:25:52 +0000 Received: from localhost ([127.0.0.1]:53318 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xP7m9-0000000FJTr-2Z4a for pgsql-bugs@arkaria.postgresql.org; Fri, 06 Nov 2026 00:25:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]:56190) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xP7m9-0000000FJTi-0Ywo for pgsql-bugs@lists.postgresql.org; Fri, 06 Nov 2026 00:25:49 +0000 Received: from meldrar.postgresql.org ([2a02:c0:301:0:ffff::31]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xP7m4-00000000TFi-12Xs for pgsql-bugs@lists.postgresql.org; Fri, 06 Nov 2026 00:25:48 +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=WiR0S4484Ozvrdm/YYaGo1Ablj7uKeLFGFzXNoOcA9Y=; b=UuasjXMtC2nPGHeR39fk7uE5aj aeikYRQRotnUFecWrqz2t9lyHPDGr+V2BbStsfo0C05X1Z+peJj0JFD/rcb089oBHApJE4wRjpdf/ 26+pzcdOL0hq808vJQLd+Y0yxSJQu34IZ4+bIa1KrZPUrBxk+L5HHV2AGaN8SSptOhO8UiXbCnWWX CdDp83C0sQwiFO+dEXa8ZdVyS8arJMsgnzhd0epslZ6ap7J1ImkqqF5SL1/+ctt6g0BzR8dJ/X9X2 LRLtwH3nOiO0DpQ5jZniSrKPWbbiYamZL8OaoopWw9DkEQ1rqLZyovRu3Wx4eayfQpr8pHol44+iU +jOo4ZgQ==; Received: from [2409:11:4120:300:23b2:d451:bf4d:ef0a] (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 1xP7m1-000000012yq-3agT; Fri, 06 Nov 2026 00:25:44 +0000 Date: Fri, 06 Nov 2026 09:25:31 +0900 (JST) Message-Id: <20261106.092531.2094637405208239588.ishii@postgresql.org> To: zhong950419@gmail.com, c.bhuvan@iitg.ac.in Cc: 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: <20261105.142957.1216400569926986716.ishii@postgresql.org> References: <20261105.091947.1557138019099337522.ishii@postgresql.org> <20261105.142957.1216400569926986716.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:23b2:d451:bf4d:ef0a (failed) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > Attached is the v1 patch, based on Bhuvan's second patch, minus the > last_value test case. The commit message is almost copied from his > patch, except comments about the test cases, which I feel too verbose > for a commit message. IMO attached patch is ready for commit, but > comments are welcome. If there's no objection, I will push it to > master and 19 branches soon. Pushed. Thank you! https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=69b20fdd20de68b0f0eaa855669a6657c65c8533 -- Tatsuo Ishii SRA OSS K.K. English: http://www.sraoss.co.jp/index_en/ Japanese:http://www.sraoss.co.jp