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.98.2) (envelope-from ) id 1xQII3-00000001IPv-1Ihc for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Nov 2026 05:51:37 +0000 Received: from localhost ([127.0.0.1]:53106 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xQII3-00000008NEM-37iN for pgsql-bugs@arkaria.postgresql.org; Mon, 09 Nov 2026 05:51:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]:41952) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xQIEj-00000008LMl-2lN8 for pgsql-bugs@lists.postgresql.org; Mon, 09 Nov 2026 05:48:09 +0000 Received: from fhigh-b5-smtp.messagingengine.com ([202.12.124.156]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xQIEh-000000019wn-0OGb for pgsql-bugs@lists.postgresql.org; Mon, 09 Nov 2026 05:48:09 +0000 Received: from phl-compute-12.internal (phl-compute-12.internal [10.202.2.52]) by mailfhigh.stl.internal (Postfix) with ESMTP id E0EEC7A010D for ; Mon, 9 Nov 2026 00:48:04 -0500 (EST) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-12.internal (MEProxy); Mon, 09 Nov 2026 00:48:04 -0500 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=fm3; t=1794203284; x=1794289684; bh=+J9FfT9N2Q pGamCZZbdIFN/wNRxB8ue79uMxSh6Y7Mk=; b=HAmFlBUCtp4BsCjDYLQxFxcTVx +rohMzEseuZonk6wy3prQQl0r2+s3urMAKGEJNZQ5NtMyJkYdzwxGkHQ0W/uBIRQ BXdABSi8bQSzjqqott667UF02QjsJNPbsnojGlYKfVB40+xycUg5kLh5BUg7UQgb ec91qLrSFHOjHwVYHJU/zQlMdMX2A9cg9Xq2Alz6kEAWScmuC87f6IK2WoTg4Uhz W82614KlCZZ/gLcZttBaTjNnsvAQAYtSuqM+A4Pb/6l38vdii+QooiOrbME5KmJi LgaPmDXmzzl/QHCfr44EgG3opgePBfrxmvU9UXBtKx5+3eCVidn/DYXbC+0A== 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=fm3; t= 1794203284; x=1794289684; bh=+J9FfT9N2QpGamCZZbdIFN/wNRxB8ue79uM xSh6Y7Mk=; b=5xcZkMyCtXBfxRIMyZbzB+VPisPRBC/ugYjz5Qv6MhcVyqoQ7Xb 8I51f7T4rL5W3xBPYLfWsZMSWwCJocEkZLHkHza7i+FQmQBdRbAGvpFW7JfhIacE qjvs+SKE8a/PcrePbrB/WAaeUXG5H4zJ+1yCiaTNG7FJFtvjWPiGBL74me0b9sp2 x3vqUsaDf8Xh3hLfIF5ZHY+lnKm/d+qfYn+1+LO1n2tARYlikk6fpJq54JA6pzBq 32gA6stTszGP1UX77KxnRZWmIXboBN3Fdve8+Rma8iMQnKWbPzJFFA4EZEzA3Vec /z7tHOMHj/x0zzrTPTv55CUvdNys0HmsjOg== X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-09; repo=github.com/dkim2wg/interop; date=2026-11-03; sw=lmtpprox; action=sign d=paquier.xyz a=rsa-sha256; DKIM2-Signature: i=1; m=1; t=1794203284; d=paquier.xyz; mf=PG1pY2hhZWxAcGFxdWllci54eXo+; rt=PHBnc3FsLWJ1Z3NAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm3:rsa-sha256:VhCWBkXXkXb/W7Ve7GLVSrImawnISFbmE8IKKbxiw83ybgH jKeu2gkcubhO7iZ/wt4vviaoFvf5oEoSv0jX+1OG0TbuGlETkVgMvO5TEGn8TLFA W8M9Od9l8w7GnipJp4MjgGGLvik1JP8Ey2j7T7U6JHRU8lvfZIsdlls/NAGQdu3L aUA/gmPJQu37ewmUcR51ge7CLPXgzc2RRa0ePH18Xeilw8KC76gCjn0Rm/PUAlnL oTd0Vi+8lMsUiuN5T9BhOoKTxHZvLnmb9sNFhGQr0u1qKnW1wgsUFlX25cffu3IO X2oz9W5WoKbzzpxoeGm74YizvcXsOjE1ukLWsoA==; X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-09; repo=github.com/dkim2wg/interop; date=2026-11-03; sw=lmtpprox; action=mi-m=1; hc=12; hn=cc,content-disposition,content-type,date,feedback-id,from, in-reply-to,message-id,mime-version,references,subject,to; Message-Instance: m=1; h=sha256:WA9i/ZDYIGkoDyjdOoUbw4f75YLmsrjyMYXoHRQwAJo=:lBNmUpWRwWDImCLuox0ViX7xvS4M7LIUQa8sT+IJ2CI=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTGSlDZE9dckX97/iF39Xsuul3Bqj1Alat7+/xk/FTsoNajxq1CmrBgrbd72LNoH5A u9+o3um6idzowVhA/btzAUi2oEKE9/hQA4LSSvI6oQkyG5iWlqwgon32ui/R2gZ97XQ1e0 KgtK6OkO2fCy6LB+02Z5anAQ3pCWvie9Lm9+xVnLoEta8t4sRm5h5fmVU+eEqUt6kWSjq2 JGnK8s6J5aIFufyYvwd05fBPFw9UB8U7MUl/ME5ENszHlkdRSVG1PeUbnau3CCbS+N8mlb ezA5GuNOhK0SKWvpbzT6n/NGcUfxUw5/P0a7WAiUdFcVPZaWj0X54TA4ZYmYKamDaUFmCW fvq+H+q9rL3H+o/WLx8rc3ejgVxueRbx6o+Sie+5ek/aRvJOWdF+JA+GKYiyn6YCtXBNzb LYzII02VKgmN7+q3wgtYmdLz4h9yEZtvY8xp3D0DzJszHoe2j6aiv9Iq+YtFCyxQ3tRPyx O785QgOiM6rNw2Ed3zvF/N2MHai0AkaMGGSigzbm+j/YRvDyrNGL59J1f7KOFgYPVWsBTU 3bH5hwOSb64iYpMmzn0wyw1Zoy6DtAWWE+cyI1F4TGif3Uy30nf55YeLMOatAMFwawGtmq 291OxOn9jQk3QdeBLhk7KzNLIs/jkyNETMPeyqk7W9kKlg+phHhgbTyVRuFw X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 9 Nov 2026 00:48:03 -0500 (EST) Date: Mon, 9 Nov 2026 14:48:00 +0900 From: Michael Paquier To: shihao zhong Cc: Atisss hh <125atishprak@gmail.com>, pgsql-bugs@lists.postgresql.org, Tom Lane Subject: Re: BUG #19849: queries fail after ANALYZE with expression stats on arrays Message-ID: References: <19849-38b8bd2fea807154@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="KsdwU74RWpII5Eu6" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --KsdwU74RWpII5Eu6 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Nov 09, 2026 at 12:10:33AM -0500, shihao zhong wrote: > Thanks for the report and the patch, Atish. I can reproduce it on > master and 19rc1, and 18 works. >=20 > 0001 is your fix plus the same change for stanumbers. Now > serialize_expr_stats() matches update_attstats() again. >=20 > 0002 adds a test to stats_ext with empty arrays and tsvectors. >=20 > This came with 261f89a976b, so it should go to 19 too. Hmm, yeah, that looks like an oversight in the serialization of the expression stats, and we should map to a non-NULL check. I would not call this error a expected: ERROR: unexpected null value in cached tuple for catalog pg_statistic column stavalues1 FWIW, I have been puzzled by this failure while looking a bit at the surroundings of this code for a different bug, just today. when dealing with empty arrays for MCEs: https://www.postgresql.org/message-id/avFaBdhb4ONGhIjH%40paquier.xyz And then noted that this thread already reported something.. Tom, any thoughts? -- Michael --KsdwU74RWpII5Eu6 Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmrxXpAACgkQnvQgOdby QH0XEg/8DDyj9TARk3Ow4biwv81tC8mI5N3NfTMQG4Mds6KNI6w+uC5phQcEF8l+ ehBRxvsD3e0Oyb6FZwCtgLew+Qy7dwWLa+XUT10MtUCsuJCyRLrv6GlgugF1kqyK PXu+O3XLja48zE039MxZ+NXtHc3dG+iCQxkvnl3uAaBEzKXQKJyh2JE+83zJ4pte ZkkRvQuXJoQZP2kWXUKqRQYOuV596DWv2rCGIAhpQBSw1F72NwHzQGdUzODezVi7 1LCCizaY/9zK8XOSUUkXktszV1w2oeQAnFvtuMTKh1PSG+lIuh3O4Ir8KhBwSUPg MNvKZHRYw7XtS0W/2GG7IK6lUZ9aBk0GA72CP3MLo1ooY0Xf2c+VJN95NfI+EjNm TUf7kzCOn6TINkzpRhFhf6OJ+rX2BX3tWTSl28a2gbubTIsS3XpcxxT3tMBpfKta KbJ8AheE/+cfwBSx8DSGslG8RUeSdGMEXmCqqQ/fMkQZp/zYeA9EQxc9MhsFuqX8 xgnh+rWwNx5F5gqjBrzNsEDntMqcwLnUETDpVsFp0rJnwl3xJ4obhuTgU+pUAAV8 Amie9Sn9IXdK1a3ZvBtyYo4RMwR06kvRwYl0uJtv9TUpx4v2d94FyJSjt8gS5uQt XcbybPQqfpa1DEw8cUhifHyvovz9HUsm7WXY47jULP1iX08XQlA= =Kzuj -----END PGP SIGNATURE----- --KsdwU74RWpII5Eu6--