Re: BUG #19849: queries fail after ANALYZE with expression stats on arrays

From: shihao zhong <zhong950419(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Michael Paquier <michael(at)paquier(dot)xyz>, Atisss hh <125atishprak(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #19849: queries fail after ANALYZE with expression stats on arrays
Date: 2026-11-09 23:09:19
Message-ID: CAGRkXqSbEG3M-Nfop4P-n+Mq16EebEH3EK3AP+qwiH8zMoKgWQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi folks,

Thanks for reviewing my patch.

> But I wonder if
> it's practical to refactor so that there's just one copy?

Thanks, Tom. The refactor turned out to be small. The code that fills
in the pg_statistic columns can move into one function in analyze.c,
and both places call it.

v3-00x goes to master
v3-REL_19 goes to 19

Thanks,
Shihao

Attachment Content-Type Size
v3-0001-Store-empty-stavalues-for-expression-statistics-a.patch application/octet-stream 2.7 KB
v3-0002-Test-expression-statistics-with-no-common-array-e.patch application/octet-stream 1.9 KB
v3-REL_19-0002-Test-expression-statistics-with-no-common-array-e.patch application/octet-stream 1.9 KB
v3-REL_19-0001-Store-empty-stavalues-for-expression-statistics-a.patch application/octet-stream 2.7 KB
v3-0003-Share-the-pg_statistic-tuple-building-code-with-e.patch application/octet-stream 10.2 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Previous Message Masahiko Sawada 2026-11-09 22:43:34 Re: BUG #19702: decode() accepts Base64 payload after terminal padding