Feedback-ID: i0fe9450f:Fastmail
Date: Tue, 6 Feb 2024 10:32:25 +0900
From: Michael Paquier <michael@paquier.xyz>
To: sujeet.cha@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18333: Postgres is crashing if we have special character in
 the query
Message-ID: <ZcGMKdCN7D4UeB30@paquier.xyz>
References: <18333-8bd5cc3619b15618@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="yGU20SA1LMiWT0Y9"
Content-Disposition: inline
In-Reply-To: <18333-8bd5cc3619b15618@postgresql.org>
Archived-At: 
 <https://www.postgresql.org/message-id/ZcGMKdCN7D4UeB30%40paquier.xyz>
Precedence: bulk


--yGU20SA1LMiWT0Y9
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Mon, Feb 05, 2024 at 10:30:33AM +0000, PG Bug reporting form wrote:
> I have installed Postgres-14.10 and when executing the below query, the
> postgres crashes. but the same query work well with PostgreSQL-14-9.
> I have a crash dump, but not sure, how can I attach it here.
>=20
> 2024-02-05 06:08:53.936 GMT [1680576] LOG:  server process (PID 2627861) =
was
> terminated by signal 11: Segmentation fault
> 2024-02-05 06:08:53.936 GMT [1680576] DETAIL:  Failed process was running:
> SELECT DISTINCT badsql.id_code,badsql.id_nr FROM badsql LEFT OUTER JOIN
> newsql on badsql.id_nr =3D newsql.id_nr  and badsql.vk_ek%2=3Dnewsql.ku_v=
k_ek;

It is going to be hard to say what's wrong without more details, like
a backtrace, or even better a self-contained SQL sequence that makes a
problem reproducible.  14.11 is planned for this week, so you may want
to give it a try and double-check if your problem is going away:
https://www.postgresql.org/developer/roadmap/
--
Michael

--yGU20SA1LMiWT0Y9
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmXBjCkACgkQnvQgOdby
QH0eSg//QfB9gTUsjO5huHUxjxJvo3WziQXNU26Kj9W9ObDyyjkRjqXT3OKnQOKR
7vdw5ru2/khqby+Ch+idY6T6yM8Aj7CXSoNfeClqADPLVpCeTTwBmsu6Q1OdarZv
cij5CWQQbjBso4ZN1baH2CXulxFZT0Oidv5P5UmmgyI4Q3vYYBx6+2SvpQOtl7wb
xR28WaBcM6N97wZO8rKaCxcIHaauC3+PyXIzdAiZv8c0BUonDMYPQcTxWKb7EB0B
JQSMLkTsdnY6rK0ZMghYXeXg00TyTj47F2fassfx6ZDs5HeN96ERGncDc4wWDZB8
8o6vebDlDyNxd1aUeVVjAMe5/I6BcYmx/8Jbw6kH9VKo1bRvXXI1lYH/uov/Lum5
l+RfrbFdh4JSF4N4JsowM/fGN5GDJcU3Jd8cHZ0OtLu1FdlNJXKehZhZvQSVcybh
r5qHajA9PDLjNo90/Pf12wT8TwcK/y4/NvE7op+V4brOJJZzWSa6SRuaS6L+hfbY
pa+Srjx/HtyY3OsQhn+QLLIH3dBhAYZuvKGSOixG/7q7tofGJVgkkp+H/8NXiZZI
N8YRDKBgrjPHNI89fVmmrIxG7sl/fWhG65BSnIXsY9iccveNg+SIzVW48gYF82NF
wA3kvigzWHP2LWLP68tRgeSqCWDlJiWL9KmfaAwhdbLJiSjBdbY=
=AGwY
-----END PGP SIGNATURE-----

--yGU20SA1LMiWT0Y9--