回复:RE: BUG #19464: Server crash (SIGABRT) with UPDATE containing multiple multi-column assignments

From: 飞鱼 <303677365(at)qq(dot)com>
To: Hayato Kuroda (Fujitsu) <kuroda(dot)hayato(at)fujitsu(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: 回复:RE: BUG #19464: Server crash (SIGABRT) with UPDATE containing multiple multi-column assignments
Date: 2026-04-21 12:35:02
Message-ID: tencent_C74D6B5B708EC49C7087C0F74EA1511D9C0A@qq.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Developer,&nbsp;

Thanks for the reply. I have verified this on PG 14.22 and can confirm that the issue is not reproducible on 14.22—it returns the expected error:
ERROR: multiple assignments to same column "a"

Best regards,
Chunling

------------------&nbsp;原始邮件&nbsp;------------------
发件人: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com&gt;;
发送时间:&nbsp;2026年4月21日(星期二) 晚上8:20
收件人:&nbsp;"飞鱼"<303677365(at)qq(dot)com&gt;;"pgsql-bugs(at)lists(dot)postgresql(dot)org"<pgsql-bugs(at)lists(dot)postgresql(dot)org&gt;;

主题:&nbsp;RE: BUG #19464: Server crash (SIGABRT) with UPDATE containing multiple multi-column assignments

Dear Chunling,

Thanks for reporting issues.

&gt; This issue could not be reproduced with the latest version, but we can
&gt; easily reproduced&nbsp; by&nbsp; PostgreSQL 14devel. I am submitting this report for
&gt; official confirmation.

To confirm, can it happen on the latest PG14 (14.22)? It's the old development
version which should not be used. Same things can be said for other reports.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Hayato Kuroda (Fujitsu) 2026-04-21 13:00:20 RE: 回复:RE: BUG #19464: Server crash (SIGABRT) with UPDATE containing multiple multi-column assignments
Previous Message Hayato Kuroda (Fujitsu) 2026-04-21 12:20:38 RE: BUG #19464: Server crash (SIGABRT) with UPDATE containing multiple multi-column assignments