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.94.2) (envelope-from ) id 1ux6hW-00AsvW-FH for pgsql-general@arkaria.postgresql.org; Fri, 12 Sep 2025 16:32:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ux6hU-002dNy-AQ for pgsql-general@arkaria.postgresql.org; Fri, 12 Sep 2025 16:32:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ux6hT-002dNh-Nr for pgsql-general@lists.postgresql.org; Fri, 12 Sep 2025 16:32:40 +0000 Received: from fhigh-a6-smtp.messagingengine.com ([103.168.172.157]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ux6hQ-000Rvy-0q for pgsql-general@postgresql.org; Fri, 12 Sep 2025 16:32:40 +0000 Received: from phl-compute-06.internal (phl-compute-06.internal [10.202.2.46]) by mailfhigh.phl.internal (Postfix) with ESMTP id 478271400428; Fri, 12 Sep 2025 12:32:36 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-06.internal (MEProxy); Fri, 12 Sep 2025 12:32:36 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm3; t=1757694756; x= 1757781156; bh=cYhBOVGbrOeXIluCE59C1CvYT7qzSCEPxV07pschI5s=; b=o bSelgYDp0JglsV+fONlSHPleZamHI9tfdGqhMI8MeQy7G+qzX+TiOWoDvrX8HXdp kGx2StXBp8HkcYg4VN62pl6jWJsQo9SNWSwKpKuDa+KdsYkhfoZtHfnzVDN9vGrX nyrBgnl/GuuG8Q76G5YUH2ENk1ECcAPQdO1oKXy9cLOF7VBeiP8Vr8IMpwqszsVj /Hw2QJjFx6q3jaZMDIazBikNaOsbdbasxqTffFn3A5nNwhtnf9G1pMKAhOvLr6t6 oTdMXtNyfd7DMNnKOyEtNk1PqNSw56GaamGkv0KzLso+1rPE2dNunJ5jGiwG4OqC fl0wBmC8HmpMuDGf64ysg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1757694756; x=1757781156; bh=c YhBOVGbrOeXIluCE59C1CvYT7qzSCEPxV07pschI5s=; b=E8paggxZjzEsVCf9M wKmVmpgdOnxC/sn+cvbI7XIe+w/3ZRCi2Gjje11divQYh2P1rpyddTyz/M1BoLst snWseXZJCLQM0SFfp9RTDP1d6atthf8lIIY45Yt74sUPr/JAcgQcVN7AzZj7qLE3 bPTpoTGoAuRirar3jzn4B1hiqFA0faZNVfYumRu+9cOAxLPdcU6goouAoClqBmrg B6zp4hWjDqAyK1WKHPtxuZ6PFJ1e8kwO3Qs3aGxhhNAXIQ/fko8EvrYbaZpHUxuL +6OpUoVXYtBLZHfegcdXRujCj2xQsouhCr2IVzYYv4cskV0aBhAqx/QM3wAianba mhQeA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggddvleehgecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpemllhhvrghrohcu jfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgeqnecuggftrf grthhtvghrnhepkefgkefhgffghedvgfdtvddvieehveduiedtieehkeduhefgteetveek tdefkeegnecuffhomhgrihhnpehpohhsthhgrhdrvghspdgvnhhtvghrphhrihhsvggusg drtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgdpnhgspghrtghpthhtohephedpmh houggvpehsmhhtphhouhhtpdhrtghpthhtoheplhgruhhrvghniidrrghlsggvsegthigs vghrthgvtgdrrghtpdhrtghpthhtohepugguvghvihgvnhhnvgesghhmrghilhdrtghomh dprhgtphhtthhopehmihgthhgrvghlsehprghquhhivghrrdighiiipdhrtghpthhtohep phhgshhqlhdqghgvnhgvrhgrlhesphhoshhtghhrvghsqhhlrdhorhhgpdhrtghpthhtoh epthhglhesshhsshdrphhghhdrphgrrdhush X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 12 Sep 2025 12:32:35 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1757694753; bh=uiw5iHrO8AGWfweUidzpdkQhHgxe6EqvRf/rfPE/Ozw=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=Rz37PPkUuu5RBk4FDFY8iX0tIoIcz0PkxvRyNJbzgbRFw2R6DR+a35COPlzxky63V h1vvd06F7UViFicqiftD70CgTpSxMSQTdy564bE56dXqtWpUA62VlXtwCO+9e2POiu yS5MIbcY62L6aOdVJjP/Y+tlYPCT8YpM4igXpFgUjA8ktp2NB+JDUwLiLNuMDMDGj5 WDo+YcC0zQLncKvBfOUC88ayFT2uPF896S280tzVnbQAYb+UOm4KVcGbOVz1s5PTOd Va6XE8bJwG233f2vBvTlje9zSdISmvM5V67jlw/2rQvgo9NuUX+PLG092W3FscJgzj 8BoQuZ6N3Vpgg== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id 19F7E6A; Fri, 12 Sep 2025 18:32:33 +0200 (CEST) Date: Fri, 12 Sep 2025 18:32:33 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Tom Lane Cc: Dominique Devienne , Laurenz Albe , pgsql-general@postgresql.org, Michael Paquier Subject: Re: Latest patches break one of our unit-test, related to RLS Message-ID: <202509121631.dtn5kw5er2m5@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <2109533.1757686026@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Sep-12, Tom Lane wrote: > Dominique Devienne writes: > >> This DOES look like a bug, no? I've done regexes for a long time, > >> and these two forms should be equivalent IMHO. --DD > > Yeah, I agree it's busted. You can use EXPLAIN VERBOSE to see the > translated-to-POSIX pattern, and it's wrong: And now we also have https://postgr.es/m/41a37137-f8bb-8fc5-2948-31b528f166dc@bfw-online.de CC'ed the committer here. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ "La victoria es para quien se atreve a estar solo"