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 1wWeuk-002ljx-1i for pgsql-bugs@arkaria.postgresql.org; Mon, 08 Jun 2026 18:41:34 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wWetk-003Wbl-0S for pgsql-bugs@arkaria.postgresql.org; Mon, 08 Jun 2026 18:40:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wWetj-003Wbc-1P for pgsql-bugs@lists.postgresql.org; Mon, 08 Jun 2026 18:40:31 +0000 Received: from fhigh-a5-smtp.messagingengine.com ([103.168.172.156]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wWetg-0000000218U-1LB2 for pgsql-bugs@lists.postgresql.org; Mon, 08 Jun 2026 18:40:30 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfhigh.phl.internal (Postfix) with ESMTP id BCA211400116; Mon, 8 Jun 2026 14:40:24 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-02.internal (MEProxy); Mon, 08 Jun 2026 14:40:24 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm2; t=1780944024; x= 1781030424; bh=O8I5zOEx/B2jtDoUrDa61klj95c5pT2adHPRNHkwrVU=; b=O lZXHEgHdhPGyVd2Q0kiVMgQr8KldQfysDdVlyD8jtxrIxzZ8cYfaRNcqZkBS6NgJ YgrC5VPKmvVncpn4MO9xg1bORp5FtyN+vVj4J0XuQWLMYo5NdkAI2ufjXRw4dnbg 588Ikqa+WTy92RP7yEpHjNcUqCX5XygqIwz5tFUa3UR2Td0H1TTrsWqV9vr9TaiW EfQBqnRvB84hwQg5oqBaUxrDWDI9ivOPNDT6KK/OFHcLOQ8Cyly/8+ESV4OCOCwA VvepR7FVJClcKnFbYdxYOS54jd2VlSD8BWIaoOAvfD5sWnIlbIfyEeFuG3zmxySw bYHWqKxsYd2m3PbJIRHgA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1780944024; x=1781030424; bh=O 8I5zOEx/B2jtDoUrDa61klj95c5pT2adHPRNHkwrVU=; b=GPKlmYU64oMYRow/P sxJ+GhNir205CDOmXzJSzjuwrVVgt4kLf9k3C3VpQ6dXbv8Jc/ivJolNZwzl1P3J io+6Q+6RKwIWMGV52dcdvS5gH3N3EHWgfJf0bYvhbMRpsKYQWRs0Bo4dXpRiFQqF Of0bFvWXZxpE90MEfEM67ZtLCsP9+jN/Qg7jh+NTbXq+FKckGYjK5gM9DrHpipnN 00Uov04cnSC3P9tf3y8J6bMuNZanH/ILtukO4PzFChqM509OWB9l1GG85YgYCfoE C8aEtHk5yyd7i1QJ+SrPB6AZSRbjSwmLKVvasCwPknqc56wUwG6uiy/fhwOnwrna 9tapg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTEV0G0GaJgmF1qwCUEMP00uJCyTsUBgJ0LiMThxIsMCK9AlNKtijEYbaSIdC9igZ1 fpif0BUPN244Kra+0usoLZTwRjhqYqrdylUhRKJ8DEFx49m6xOGXMv0i0SiHrUs+GtYhm1 RA+DesspkKk3RIxHs7rDwKwHWpmz6D8voGbkdu6OoCgTI+uKkDizimWHoP5YAZhHWQNWxv svjKLkl7OMuJU8O6coIFdEPdgat+v8VzulNL2TQucIL13h6np1QJO9p+TQsTulndMI3rQ8 qiCdmylox9mmRyZs+hvCpLEDasFk2SUXn+b3gUbKYUTT/O4bvdsWTuHIKKswDte8ESGWEl ljcdF9fxWOQTFE3DN/1obBMXabxhL4fJ79YBQa22tLjB0gMwjeuV3vulQ6Z96E19k3aECD Ub+jf6bzzjaBc9bKz/tH6s7vDqGAvM90E/KVUrUNfk/ZTQqKFsIuKzE2UTqAC34eB1tJd1 oCvzXQUqEa752nthHe84exV5wRCZR64T5IHkB1PVsJGSlqYpo+4XcTOFNelKSXbu4Mzi76 hESMbrU90KpLa7E4/XzZOX/eEILz+MscfvKK7wcoydgo9uaudE9rqmRRUOHUYIU+5HkJtc 4DDXjQxAHw+ppdhko4otD5gmPVHM/HcGq2PmAUOltB/a1JqeusxSKTHf/BAQ X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 8 Jun 2026 14:40:23 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1780944020; bh=63F93TfTSfjfn44Rmv8bVWir1Tufl3ICXTDqtj9q/10=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=mOLlfEYxEbaN3yGpYBjUoa4c0fb8E0AVY6qweAr3tQSKY6fq0CpqA4tsOFJ7wSlUI l8rgL55p829U8rI6PiYOhZAw4ZMpJwj/pM8RsOQ7nuApBySci3jkVh0wx0m44O782n jICIWhFNsqY0IOqke+WQX/68o/ctfz7Zbu+3LcyIXa4hzc/BN77A7kIteVk656NA6s BS4MiMWg3nepymDmRHcCdFxHsap+kMLRRorYy8IxgR9hyHSHPEa06AmFM5bjFK11r6 48nL/zRyQnf4FTvMHMGehtLEda7xU5JaB/u2zeEQDHuEL2WoR+gFSqO3M5Rsb5jXwH R7Jo9ZAsJTWZw== Received: by ida.kurilemu.internal (Postfix, from userid 1000) id B29F3B0065B; Mon, 08 Jun 2026 20:40:20 +0200 (CEST) Date: Mon, 8 Jun 2026 20:40:20 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Srinath Reddy Sadipiralla Cc: Ayush Tiwari , 798604270@qq.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #19491: Segmentation fault triggered by IS NULL Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026-Jun-06, Srinath Reddy Sadipiralla wrote: > > Thanks, that reads better. v2 attached, raising ERRCODE_CANNOT_COERCE > > right where the coercion fails: > > > > ERROR: cannot cast type sqljson_mystr to text > > > > which also covers the JSON() WITH UNIQUE KEYS path. > > Thanks for the updated patch, LGTM. Thanks -- will review, hoping to push soon. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "That sort of implies that there are Emacs keystrokes which aren't obscure. I've been using it daily for 2 years now and have yet to discover any key sequence which makes any sense." (Paul Thomas)