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 1m15ID-0001v9-EP for pgsql-bugs@arkaria.postgresql.org; Wed, 07 Jul 2021 11:00:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m15IC-0007G9-6k for pgsql-bugs@arkaria.postgresql.org; Wed, 07 Jul 2021 11:00:36 +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 1m15IA-0007G1-TP for pgsql-bugs@lists.postgresql.org; Wed, 07 Jul 2021 11:00:35 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m15I7-0001fo-4n for pgsql-bugs@lists.postgresql.org; Wed, 07 Jul 2021 11:00:34 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id C5B21320097F; Wed, 7 Jul 2021 07:00:23 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Wed, 07 Jul 2021 07:00:23 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm2; bh=nffnvDlEamx7PSBK8NfgzsOCjr2 rQ62JNCvAAuYJEPc=; b=DwhxjcY+sbc9XWPpRAxgyjMr6aPO7sXV+scM0ga+r2P jnxHbREiKL7W7+R4cvTKiexrwIJOC6+o4kMdNBX6yDon/3ralhuTAVBfNp5juMJU FSwtyo9jT//+QR9xFzuJ6JKY/XT7zBrmlTbrMCAvjiI0tzzP1OOY78dkI16WYA36 VqwMz8/zRqru+y4At1SBiXwp8dDi3DSoSbviJbO/dDy+51xBFXQ3dvhc2I/DYB6C sD2Bz20/Phnq9cmr37tq+4BB2Z47VMBkUnR0O3Syl4xpJi0YUlLy3nfWWGSs47bs SbH7pFEnFsmY/2jSaW3AMvh4ew0Dac+2H/3cMuMRkig== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; bh=nffnvD lEamx7PSBK8NfgzsOCjr2rQ62JNCvAAuYJEPc=; b=WpnsQ20lc4KDpO/Ib51afv non7fp4DOHdEK568mdh0NPPNpiVHNwMefFH4Cf+jQAKuZLIdryJ1YxBB2Lb70BfE bIC/ZJGrisfI55CWq4YH2Hi1rUyovOJwiNjuCZG2xBdWIqViB4h++qgIOGkQv0ig CHR/tsPXDnn/WV05gZITfhYGWhgbS1MJl1OoRxqXEfyMX5H6tCJISz9FzcKNQ6KP 3nXvXzCOaJNpDfN5svobSmFM3Gn1+5BQs/ZDb3dcWp0UcIFN3H3o4sPKro/Sm8HS TfJyGVYyMx5K+Rxs7ds2afWbeB0OZChO+ZDcHqJvw9XEcLVDWdLGBMU9saCK0U3Q == X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvtddrtddvgdefgecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecufghrlhcuvffnffculdejtddmnecujfgurhepfffhvf fukfhfgggtuggjsehgtderredttddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhi vghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnh epvdegudeuhfdtueeltedtveejheehieevueeigeelteegleejleeiueeiheegvefhnecu vehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrg gvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 7 Jul 2021 07:00:21 -0400 (EDT) Date: Wed, 7 Jul 2021 20:00:17 +0900 From: Michael Paquier To: cyg0810@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #17088: FailedAssertion in prepagg.c Message-ID: References: <17088-e33882b387de7f5c@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="B/tOVHhWs9gs78qQ" Content-Disposition: inline In-Reply-To: <17088-e33882b387de7f5c@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --B/tOVHhWs9gs78qQ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jul 07, 2021 at 06:33:07AM +0000, PG Bug reporting form wrote: > run the following sql command through client and the PostgreSQL database > process will crash: >=20 > CREATE TEMP TABLE v0 ( v1 INT PRIMARY KEY ) ON COMMIT DELETE ROWS ;=20 > SELECT FROM ( VALUES ( ( SELECT - - 84 FROM v0 LIMIT - -1 ) ) ) v1 ( v1 ) > GROUP BY ROLLUP ( v1 , v1 ) , ROLLUP ( ROW ( ) , ROW ( - - - - -128 , > 6099928.000000 ) , v1 ) ORDER BY v1 =3D v1 AND v1 =3D - - ( SELECT GROUPI= NG ( v1 > ) GROUP BY v1 ) ASC FETCH FIRST ROWS WITH TIES Reproduced here, thanks for the test case. As far as I can see, this is not limited to 14. -- Michael --B/tOVHhWs9gs78qQ Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmDliUEACgkQnvQgOdby QH0Tsg//RnzdFVO7sv5XaXN8SQ7uJ1ec/8/s7YWO4FopOgf5Pcmn2tkQcO6ljLLY i+Y5UX3nDpsXqBf/sELiZJBb/T/1PFR5vJYEnhibdE7sKDywoHanI1DvhxJIJNpA ko0DB6H89+BtQWOqG6wMH0XcWlDhP3UNtZTxpGUlmhNe7rELTVK/TSa0PYQPOApq a7r9SPZO6n7dEm6BgOyP6+hmth5WPrxoEVeDbHveC6tyEy0qIM2bAwIiWaUSVm2g LVuE9GTCyd0xscv7jGtcJSi4dudnmU/v54DK0zOPtXRWWlbA8fZ/0vEALulI3XVW 5+50cStA5KXHPNmocV9InU3oJyXC9OOZ8TV2Q25BkQgjMbd4iFirdnpGWkvr+NaM dYM0IWAwm4mwwwPN4Khfx94w/H+iIYX1oYrIdFVNf4OXrAeXlkA1BRpAJJYejtmv CWdm92elvhVX8fhhijlkV4gvwARIOvGTYqDI40P7WzeMqWzcXbxlxc5BY3xKgkxn frGqbR53LteAFAzmMk91nzIO49/7wUg0W/T6Hq4R5C0F8lQcJ2TDDBnev/nY6WN1 MNEyHW1Fk8Zlfm1CuTx8G8Jq2xFVRTquISslxuT19UbCZFUFtpYRD0VTMaq1Q17s JlVHMjFl8opysubOaVeQyLKqZt1DipuHOOas13gWDiplUMnA5Ko= =2yo1 -----END PGP SIGNATURE----- --B/tOVHhWs9gs78qQ--