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 1ntfFf-0007he-25 for pgsql-bugs@arkaria.postgresql.org; Wed, 25 May 2022 00:51:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ntfFd-0001SU-Om for pgsql-bugs@arkaria.postgresql.org; Wed, 25 May 2022 00:51:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ntfFd-0001SK-GE for pgsql-bugs@lists.postgresql.org; Wed, 25 May 2022 00:51:49 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ntfFb-00021o-8z for pgsql-bugs@lists.postgresql.org; Wed, 25 May 2022 00:51:48 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.nyi.internal (Postfix) with ESMTP id 562DF5C02C5; Tue, 24 May 2022 20:51:46 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Tue, 24 May 2022 20:51:46 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm1; t=1653439906; x=1653526306; bh=MIUlGr71lp WOV+t/LCZpWNlA9J8FKGJoCm7YsAIfjh0=; b=i7pDH5vhBHVK31uClYo8rGOCkA SMZUVB0Z4CF3n+5Gt8yZ0ooux/p83nYNNIEfJNyQX66WWcl63ZHGc7CdSjJjAqV5 YPpzhWdJBlIn5rmJ9T87Cb9Ku0UzgwqeNu6dO3cvMxuXzGvkoKlAoMuTDcYQFHhu R+zIc8CJw7Bzfg3bUNV11D2uoYDx+NZ71JmK3tMzYv57kAMQMK5Br9qcwAbVBIMy Qf/sV1XYdzju8HyH9lFjKEGHqvxT2xgaa38EHJ86mTqzbCc9kjmSsDs9BJv61jmM cvxgHYnPat+zZpe/iWiiTvCoqGiHAH/S/aucA0ttEYIyMopufV0ifgFb2PQg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:date:feedback-id :feedback-id:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:sender:subject:subject:to:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm1; t=1653439906; x=1653526306; bh=MIUlGr71lpWOV+t/LCZpWNlA9J8F KGJoCm7YsAIfjh0=; b=zM/SqSXPB5AjyCk0TLlEOP+0Jnw6/ilHC2RGQpzO2Rto cgz+ZCAh1yvHEnNQwUAmJM1d8TrgaA1cmKgpne8ng5lZM69WSzISGAj9wpwZNFVD QSwdfF8aY0j7t1AgHG7Alv0RCYKFr+P25VKvAKK1YO65LEStLpDr+zI6BfHOTzld TE4vA3sunJmvCHz54l5I4AfJZssf3L/JmzoNCbDTcNPRdheOf+ug7m7q4CB4j8wh EXWWv5W5tzEgvMOIiZ7ZSC6m7zT/7ue2TyLx5gPPvvsedHtPttXvY/ZdccPGmOqi sevlG45lxl1NiS9/pTwsuv8up4ZlZx7yqbnJnVZzTw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrjeeggdefkecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdefhedmnecujfgurhepfffhvf fukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnh epffdufeeflefghfekudekkeevvddugfeiteekkeduleefvefhhffftdduffeiuedtnecu ffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpe dtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdig hiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 24 May 2022 20:51:45 -0400 (EDT) Date: Wed, 25 May 2022 09:51:42 +0900 From: Michael Paquier To: jeremyevans0@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #17495: Regression in 15beta1 when filtering subquery including row_number window function Message-ID: References: <17495-7ffe2fa0b261b9fa@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="zJVm5fsCJDo5owUl" Content-Disposition: inline In-Reply-To: <17495-7ffe2fa0b261b9fa@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --zJVm5fsCJDo5owUl Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, May 24, 2022 at 04:17:35PM +0000, PG Bug reporting form wrote: > From testing with 15beta1, I think there is a regression in filtering a > subquery using the result of the row_number window function. Here is the > code: >=20 > This was discovered by the tests for Sequel, a Ruby database access > library. Inconsistency reproduced here, thanks for the detailed report and the test case! I have added an open item: https://wiki.postgresql.org/wiki/PostgreSQL_15_Open_Items -- Michael --zJVm5fsCJDo5owUl Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmKNfZ4ACgkQnvQgOdby QH3rNxAAi6FgyIjNHWtFCEfaB6IWNt3ulQeaI2puPJvLSVZoXROfso4eU8VDfjf+ n9I2RhfBhqgkLoVMdsGQ/6TRtex2MqyhH2JaSPzjTZr6JASjlZRwJ6kJZcrSSr4C xnvz3b6Lfdhg2ftkgI3tgzmx5qq/ECj2NhWwQM5XCjhnhc12Xmai3K7ZHGdtnF+W ShMqSEKCAOGgAVtAxK+Q3gJEJ+DDg75u+7Kkdkx70sX+KI2cTQQhO+wSyWhY9rP3 xI1jgjkF2yioPjhA+/uz0pYquKg1F0x/XV5Z4NozdiJSXkeUsnN59N2rZS4dECKk tjnUJVN7V89UGUm2/UprDRfIxEjasaiVz7FgtfT5A/X4ooiPvp89D3QekMhipiem inhhK31WM78VHTheJMbcG2sH2WoISGIUSwRZ4sYYi4NmNIYxs1Oc2PpbJzIajlIf ho9ILnkejQTvH+hWsxiS+lZeHXWKbZM0a65tSN8uLXJs4IrVDnK4xuOWOCI1nava p0brUUIWYbjPkYOZsZZrygq/wiJOmu4t4yvtQHgrkYgEJVIEBw6P0OA2Q1XQtw7Q IyAj44W8CoAyFETaBCrXvCCkCjmntxeFOW6OXQ1ACRRj+vav47yjv8ltSqELT8qN WDSzQGdWacVh9/u3LuXP3nLrQJetYuFFDoh3NwR5YmrIC6u1jag= =KHVC -----END PGP SIGNATURE----- --zJVm5fsCJDo5owUl--