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.96) (envelope-from ) id 1w0jms-002AMJ-1p for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Mar 2026 17:25:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w0jmq-00G7uq-3A for pgsql-bugs@arkaria.postgresql.org; Thu, 12 Mar 2026 17:25:29 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w0iVj-00FpLH-2r for pgsql-bugs@lists.postgresql.org; Thu, 12 Mar 2026 16:03:44 +0000 Received: from sigil.arcsin.de ([2a03:4000:2:cd1:0:8a5f:404d:8ee5]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w0iVe-00000001nB8-28K3 for pgsql-bugs@lists.postgresql.org; Thu, 12 Mar 2026 16:03:42 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=arcsin.de; h= in-reply-to:from:from:content-language:references:subject :subject:mime-version:date:date:message-id:content-type :content-type:x-amavis-category; s=dkim02; t=1773331410; x= 1775145811; bh=sql/aEiEiZ98bEfoGD7P1s1U9xRq90z60OwhpjLJGEc=; b=T 2Qo5lMB/8auTjp1GxnuTCQgzXMDhtMY5zmQwYbbAlL87x7d83b3kRWR8/pF6eBdM IVsVY0XaNLfd+fSQroIb9ic2EaaDE/58ph1ayfk4bw3fuNzZjbRl0yM5VnLyYSL+ FhqcaGZtN838Ns/wKw2b0ATeZ0hmotgGyrJGrqOwvBR8L/u+D4m8lFBi29DWNuo9 yQc3/L78r9KtUfV9PTre/993GsoZvHqbGI3bgO3O0uSbyLex10+wONL+ApTDoOJr EmFQRW/hFRhk0vtxrFSBc4dwJy64aEPCesSu+aM+so1kIfW+Wn/gXbRvQbLoVL/Z 0iCnsOzmnZmCGYGJE/jCQ== X-Amavis-Category: sigil.arcsin.de; category=Clean Content-Type: multipart/alternative; boundary="------------mI3h6R6eKwdZ0FVewwqK0YTU" Message-ID: <27d1be64-a052-4f5a-8cb8-53d48e94c97b@arcsin.de> Date: Thu, 12 Mar 2026 17:03:29 +0100 MIME-Version: 1.0 Subject: Re: BUG #19428: Lazy evaluation of type checking in CASE in SQL functions including subqueries no longer works in 18 To: "pgsql-bugs@lists.postgresql.org" References: <19428-d9ac6c4d84c0bc81@postgresql.org> <3708.1773251497@sss.pgh.pa.us> <0c78c92b-e3f5-42b6-a698-48855a1bd23b@arcsin.de> <4503.1773330394@sss.pgh.pa.us> Content-Language: en-US From: Damian Lukowski In-Reply-To: <4503.1773330394@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------mI3h6R6eKwdZ0FVewwqK0YTU Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit > Read up on custom vs. generic plans for some more background on this. Thanks for the hint, the query works again with > set plan_cache_mode to 'force_generic_plan'; --------------mI3h6R6eKwdZ0FVewwqK0YTU Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit

Read up on custom vs. generic plans for some more background on this.

Thanks for the hint, the query works again with

set plan_cache_mode to 'force_generic_plan';

--------------mI3h6R6eKwdZ0FVewwqK0YTU--