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 1uK4SR-00Cz7e-Rf for pgsql-bugs@arkaria.postgresql.org; Wed, 28 May 2025 00:15:47 +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 1uK4SQ-00CZb1-6E for pgsql-bugs@arkaria.postgresql.org; Wed, 28 May 2025 00:15:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uK4SP-00CZat-U3 for pgsql-bugs@lists.postgresql.org; Wed, 28 May 2025 00:15:45 +0000 Received: from fhigh-b2-smtp.messagingengine.com ([202.12.124.153]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uK4SN-000HkP-1x for pgsql-bugs@lists.postgresql.org; Wed, 28 May 2025 00:15:44 +0000 Received: from phl-compute-10.internal (phl-compute-10.phl.internal [10.202.2.50]) by mailfhigh.stl.internal (Postfix) with ESMTP id E8A5E254015E; Tue, 27 May 2025 20:15:42 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-10.internal (MEProxy); Tue, 27 May 2025 20:15:43 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm1; t=1748391342; x=1748477742; bh=8VMZsH6R5y Ti7qwyf0LmTJRQWVZRAtv2VOzom06v3Aw=; b=tf/9b67XlveZ6JoGDofx0EuSPQ Z7ZTgPWDIFeCpDGVOXaccIL+maWSpmEjDBrg8CwCXkTmI2gWo11TTrbS6Inxcgcv o/RJJcqVuBPiu40wRKr3enyf3tMw8dDo5V3CmUSSTpelv8NhhwmbqeC3bvaWLp3g VHfdN9aTCLaLzq4T8SNhwKGPftz7DAVj9nY5XXSZ8ZytHnefMfnAAp/sP5sz8n3r ekTByIyYhpj48rspBZD8wvaBoG9O/FWb71FY5ffSuS8YZWO+ADaz4zehEuAoG+/3 t/PuWCruxPSL8KiL6as/rwT/78rC0V6E0In2x/uYaJPJCtnNvn1ffQudeo1g== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1748391342; x=1748477742; bh=8VMZsH6R5yTi7qwyf0LmTJRQWVZRAtv2VOz om06v3Aw=; b=FhECRIWv1M7yCjMYUDO7AnYIaozWC3rwwx0Ez5q1TOYk247q2XU INx+GLhvwcZPo3LV7YZQGncz31kdB5U7JXGU9BBytaOpj9muQF854+afRF5OpV0C 4xKNcyUwr521jYs6Nbe9Gn+fPyb13XOlc1hb/aKg/f8v6iLhVZtdHGqKKx9BtmDW fM2k+ddNOB7bkBnxfyP/Bkth1yJC157OPezv5f7V0KupgDVIVBykNT+EA4FMlqf8 LO4EY2A6S4Zcw6N0C2F/6Gsqmk72q9ArlOu/zFj+JGNvbnk2v7KocsvOEdBi6Hqm vKab1pRi8cJddaRejSMZ8VbQLj/K17uZb/A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtddtgddvudektdculddtuddrgeefvddrtd dtmdcutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggft fghnshhusghstghrihgsvgdpuffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftd dtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlhcuvffnffculdejtddm necujfgurhepfffhvfevuffkfhggtggujgesghdtreertddtvdenucfhrhhomhepofhitg hhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeen ucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteelgeeggeffhfekueevteeigfduud evudetgfegiedvjeenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhl fhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiipdhnsggprhgtphhtthhope efpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehlrghurhgvnhiirdgrlhgsvges tgihsggvrhhtvggtrdgrthdprhgtphhtthhopehtghhlsehsshhsrdhpghhhrdhprgdruh hspdhrtghpthhtohepphhgshhqlhdqsghughhssehlihhsthhsrdhpohhsthhgrhgvshhq lhdrohhrgh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 27 May 2025 20:15:40 -0400 (EDT) Date: Wed, 28 May 2025 09:15:33 +0900 From: Michael Paquier To: Laurenz Albe Cc: Tom Lane , pgsql-bugs@lists.postgresql.org Subject: Re: SIMILAR TO expressions translate wildcards where they shouldn't Message-ID: References: <16ab039d1af455652bdf4173402ddda145f2c73b.camel@cybertec.at> <5498224d1d5a6a3be7f29ae7725f76162d48372f.camel@cybertec.at> <37584c1321b984a0c5c05d213ef70b869d95a12a.camel@cybertec.at> <1101508.1748357652@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="ZHMvRZIwy704StAe" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --ZHMvRZIwy704StAe Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, May 28, 2025 at 09:00:20AM +0900, Michael Paquier wrote: > Nice trick that makes the test output much smaller. I've used this > idea and applied the fix down to v13 after a second lookup this > morning. And I've managed to miss that the case with an opening parenthesis throws an error due to an unbalanced set of parentheses because the regexp is processed when the query is written the way Tom has mentioned. Will fix in a bit after an extra round of check-world, sorry about that.. -- Michael --ZHMvRZIwy704StAe Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmg2VaUACgkQnvQgOdby QH3kiw/7BglBam04I6wl2JsssxyzO5k6UNJ7/0C0FgSNrRt3llST7wcWnxkFTTM3 CfS/8/QXxjDWum7YAG2PljT9EcbqNK8lUvCjec0pAKM8f+tzXgFaIokuO15swAVR 2SZELklpy0jVJZDgdJPd1Fsq559dg4QFM3UZ9gVfkKG5v78Qw5T58ubQH/uXWSB9 wPrrPgzuiQj6WQ3G1vrBlshK44paVXO3VdgD+lLo1TpDDf+CXpSLmx9wn1bLQOiM yq4A9oh8TmVI1j/P7/75qsXE9txlN6FNSqrpwF9xh5OpvEblixN0LTKgg+U9K9Ze toPom5gqRUDXKmGdFYtPnPRduPwTYwrT8b8ApUcn7Yg5bbjm0I786ULTiY1L0cUr vPfe+YDKhFN/JwvzCWJL07OjxRLML5Lhi7lWgX8vS453WYGBu8+ATU149s72XVBm I1iemQ5jpDWY0pFo1+A4QFTWcjtkbpEHZoTNBxlD3838xkryGFX8KhKC3wS7175j a01wsB/oEuEiIHK0b5mN+zghYbxaG8d7w5BMKkW8cnBGvJrEEiKrufmS9da05mSF MAyi8lLzOkjo7c+vW1Fo9qmuFU1DdhZ/l8znmOiEWBybr4VNw7Gd5hSmUOSdB1Qg zaL8fbrPR5WQwIjnI4vfoI/dvKn3F8BqJyxD+S2KMtYsH7f7m0Q= =Cqwt -----END PGP SIGNATURE----- --ZHMvRZIwy704StAe--