| From: | jian he <jian(dot)universality(at)gmail(dot)com> |
|---|---|
| To: | shihao zhong <zhong950419(at)gmail(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Noah Misch <noah(at)leadboat(dot)com> |
| Subject: | Re: [PG19] Bugs found comparing 19 with 18, list before I open threads |
| Date: | 2026-10-13 04:02:57 |
| Message-ID: | CACJufxFgvMLd5xevbtucxRAiYKmU2Q2-7Ujz-FA9v0RoiEA6Hw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Oct 13, 2026 at 10:19 AM shihao zhong <zhong950419(at)gmail(dot)com> wrote:
>
> Hi hackers,
>
> I compared 19 with 18 over the last two weeks and have a list of bugs
> new in 19. I plan to report them one thread per root cause, with a repro
> and a patch each.
>
> Medium
>
> 7. JSON_ARRAY and JSON_OBJECT with a ROW argument are treated as
> immutable. With a timestamptz in the row an expression index misses rows
> after a timezone change and a unique index accepts duplicates. From
> ecd9288624a. Robert reported the immutability part in [1], I will reply
> there.
>
I’m currently working on fixing this issue.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shihao zhong | 2026-10-13 04:06:06 | [PG19] pg_dump --statistics restores extended statistics by attribute number |
| Previous Message | Sho Ito | 2026-10-13 03:54:57 | [PATCH v1] Fix tab completion for concurrent materialized view refresh |