| From: | shihao zhong <zhong950419(at)gmail(dot)com> |
|---|---|
| To: | Atisss hh <125atishprak(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paquier <michael(at)paquier(dot)xyz> |
| Subject: | Re: BUG #19849: queries fail after ANALYZE with expression stats on arrays |
| Date: | 2026-11-09 05:10:33 |
| Message-ID: | CAGRkXqSbfQ4nbaf5jh4cxoEBZX86iLjoVhdCBqH0J_Osviskyg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hi,
Thanks for the report and the patch, Atish. I can reproduce it on
master and 19rc1, and 18 works.
0001 is your fix plus the same change for stanumbers. Now
serialize_expr_stats() matches update_attstats() again.
0002 adds a test to stats_ext with empty arrays and tsvectors.
This came with 261f89a976b, so it should go to 19 too.
Thanks,
Shihao
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-Store-empty-stavalues-for-expression-statistics-as-A.patch | application/octet-stream | 1.5 KB |
| v2-0002-Test-expression-statistics-with-no-common-array-elem.patch | application/octet-stream | 1.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shihao zhong | 2026-11-09 05:16:41 | Re: BUG #19834: eager aggregation still evaluates volatile join clauses when the volatile function is inside a SubPl |
| Previous Message | shihao zhong | 2026-11-09 04:57:20 | Re: BUG #19843: decode(..., 'base64url') returns an extra byte for "ab=" |