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 1uK4De-00Csxu-VV for pgsql-bugs@arkaria.postgresql.org; Wed, 28 May 2025 00:00:31 +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 1uK4Dd-00CSwF-Dz for pgsql-bugs@arkaria.postgresql.org; Wed, 28 May 2025 00:00:29 +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 1uK4Dc-00CSuk-JJ for pgsql-bugs@lists.postgresql.org; Wed, 28 May 2025 00:00:29 +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 1uK4Da-000HVE-1e for pgsql-bugs@lists.postgresql.org; Wed, 28 May 2025 00:00:27 +0000 Received: from phl-compute-06.internal (phl-compute-06.phl.internal [10.202.2.46]) by mailfhigh.stl.internal (Postfix) with ESMTP id 5876A2540158; Tue, 27 May 2025 20:00:25 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-06.internal (MEProxy); Tue, 27 May 2025 20:00:25 -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=1748390425; x=1748476825; bh=DJg27nr8oT C7l8KpkcbQKHhUvsrjhGTPWtoNE54Ka2M=; b=cpd0drKAHZPoCJ42l7y69pypQw EoD16vptKcP6Fz+zOLG07bmFnddy8RABmOzZ4TnX1uAVg6IfKFCUEbaOWm78VNIe SUka402XefnESgEe1rVZAMn/9vqd9MrSHRJIdY4PyFTQz1Dj5YM8PQCOr2QJz8FE ZKabu8v9ISUyO+E0lAZCF7zBLq5IqACHeZwraMlz0bXl6GTH45HKQ3pdeKIxLlI/ t/FHGtk+b4knBYfLIuXAow5zuIKMhPTxSeUVK2xsLGONKjTGpxP8Uz7qHW/y5XLp c4ND7/6tmvo5p2qPFX+FjjBGKbxqgmnrdQTg73ghySYmczrZHd+ioFueuT0w== 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= 1748390425; x=1748476825; bh=DJg27nr8oTC7l8KpkcbQKHhUvsrjhGTPWto NE54Ka2M=; b=aP8FoFjQCYVDY14HED8GatfnSWoNcThTbw6jJd5GqYNa6Ugfgyi qQwcoSgXaGdK5mAT9qAhmz/WmvVKpBY6TJDzcyp+T467vUC+ne2E5Ed1q8knSmj3 0SH7Dhyta5UlskC6cSBidxgLs1XHuGBAf4QU5sPqw6LC6ds1t3rC3HqhXpYf2xvr f3bow4wTt1v4c7OPSawYnGoDyxZ8v9a3oPyCXQHr6rOVLz5Dxqpwk53eX2P/HefR 4hh2wAiutCrHV+AcK13/7QlXL6kWkHVvCTJfBws2hSFXED6FTw2PkbOytrCc+ZfB zTL+9LriBjlbKRMRXtEJ+OIQ7nypId4H5cQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtddtgddvudejieculddtuddrgeefvddrtd dtmdcutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggft fghnshhusghstghrihgsvgdpuffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftd dtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlhcuvffnffculdejtddm necujfgurhepfffhvfevuffkfhggtggujgesghdtroertddtvdenucfhrhhomhepofhitg hhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeen ucggtffrrghtthgvrhhnpeffudelheeghfekfefgfedthfekuddtvdfhudekgeegheeike fflefhleekheetfeenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhl 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:00:23 -0400 (EDT) Date: Wed, 28 May 2025 09:00:20 +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="tnYuGQqfwINlo9tc" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --tnYuGQqfwINlo9tc Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, May 27, 2025 at 11:39:02PM +0200, Laurenz Albe wrote: > I originally considered EXPLAIN (GENERIC_PLAN), but that would only > backpatch so far. 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. -- Michael --tnYuGQqfwINlo9tc Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmg2UhQACgkQnvQgOdby QH1e3BAAkJZaXN1bExEYEYGB0H7OOWYdQLwP3pl7weZW1Eb+jtqGjVuGGkIbZTS0 /UvVIndEhp6QVS+3onTTFIhZhrEyMC/CrH/ozZveIcZhHJ2aCQuiAfHNjJOaxdY8 KFNoB6P/R8pZIj653d6WsuiwS42xjHQxA5LzxxB8WSodT3KKzdlvOwQLvqUjP+Z7 OWLw059ml4bRVAqtcQTIrff6nQUqRZl6b5WlXBYgDOAMI6xJflzyWKtbx3lxA4o4 GqV7fkKLZW2eaysTeheETIPPvxwOP4/laQzqAH8v/Fj/u/6o4k0cdvCjiJ0j9NTU 0bFMS0iu77NGFPOP2b6AJbq2oT9hbl2xoGfJdmZi/hW4usM1WhRDkMkoP2G3DqSN we5HmiAE/j2cFcHkswTmWg1575D72dfqCcX2oGL+CMwZ4vt56K3t6PerZ3l+f3Sc rHMFTlxOuR4U7LaCfV01TZHAR+bO5mAyQFCMgAtGG0CFocsAzqMhYaFnRHUXaeN0 WsYBFNp26jRZr42HeqKkhZLP5ymAQFabFzUkWdiCntsX7bqrRgOYGL9o1KTaufl9 Z0+oJF/yaE0lh15QNDP3qA/F3hFm/womCslCiE71EV3T+XLmMk7I83MPA+lM511p HQktYr6Twj9HKCSycFsaNoSzII0a558e4JHO5ZlJ8DTCDfEKTZk= =0zzV -----END PGP SIGNATURE----- --tnYuGQqfwINlo9tc--