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.94.2) (envelope-from ) id 1rT6r4-000UUZ-Sz for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Jan 2024 21:01:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rT6r4-003vAe-4s for pgsql-hackers@arkaria.postgresql.org; Thu, 25 Jan 2024 21:01:46 +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.94.2) (envelope-from ) id 1rT6r3-003vAW-N5 for pgsql-hackers@lists.postgresql.org; Thu, 25 Jan 2024 21:01:45 +0000 Received: from mail-qt1-x834.google.com ([2607:f8b0:4864:20::834]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rT6r0-003MUT-7v for pgsql-hackers@lists.postgresql.org; Thu, 25 Jan 2024 21:01:44 +0000 Received: by mail-qt1-x834.google.com with SMTP id d75a77b69052e-429915eefa5so8529241cf.1 for ; Thu, 25 Jan 2024 13:01:41 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=dunslane-net.20230601.gappssmtp.com; s=20230601; t=1706216500; x=1706821300; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=AuPcn1EZmcRMzJK8cAyxHS798NRRxwCNdLYJnlHOXPM=; b=md542rPPcXfpRX2KmKW9SXe3cpoWv0QVUA6dhB8MwcRiWYHsMtgtNJRQSi6f/oe9nt D+WCwYhfb7y6srKdL5domsPwyeObv+DApr0OpUtfPxyEpwo8wLiUYS0k/JhNCSItC+ts xo94Hv7N1/Z6UmTbaMnPXBYKF30bDufN8FEuvzdGmWKUVFcs0qx3bA6zU5ayILv6fN1c I8c7HkJE0A7GoBpy8YI+CkU6XsVrcKJeHjSd6XKvgpwzv6Y6waergkraG557Wqq4Uxj/ EHi0HAo42D8ezIymEl0RIhzcSkJbf3DDIO5fHiq2L7L1L5HN02LxEgNLE2g+EaSrCPwq Es+g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1706216500; x=1706821300; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=AuPcn1EZmcRMzJK8cAyxHS798NRRxwCNdLYJnlHOXPM=; b=MZji1tSKRkAwE4OYVBzKxh/NnAEa13vRN5ToyafKh7ySrmtvY0HxMqjpJiAJQAu/8n hHvxrWNEEW/Kcbvo37o860duVwgc1ZqRozOwBLG2tTAlKq1MxKPuPl9uYoRAbYCXCZ6m sgYbRBUXQ+VfJqCbOXUX/F44gIuyoqtT1131YLSU0CLRMp2Xe2uXm1e9i2N9XEzbEFkx mJ08RdORJhEASheaeqC49UpxNUyoChLBQ+mZ08nsE16ObdAd3ie/EG6fYo5MwMb0WEou du/tAl/tFsark6FGFrVM+Kf8U+18dFD1Efarxsq+5Kyff4MHvUXz3cOVbXQ4L36vg0pn zPZQ== X-Gm-Message-State: AOJu0YwkNWBRxHyWFmRJ6X/dTEeVvQmmmNZPcBlrZop5EZJDXDYrJLmR X/QhT+ADnoBU/GG5kzGT11sY3McF2b6P5Ayp2n2CfBLnG1avwyUJZ4EXDj6XJfs= X-Google-Smtp-Source: AGHT+IESE3oA59peHpBcNff2pp2WQxW4n4Rahebza8DCuAN+an5l0+fCnRcaPcFEdrnsi0J8Ef3Qqg== X-Received: by 2002:a05:622a:1042:b0:42a:749d:f2f9 with SMTP id f2-20020a05622a104200b0042a749df2f9mr227244qte.50.1706216500416; Thu, 25 Jan 2024 13:01:40 -0800 (PST) Received: from ?IPV6:2605:a601:91f3:1900::2bb? ([2605:a601:91f3:1900::2bb]) by smtp.googlemail.com with ESMTPSA id x13-20020ac8730d000000b004283695a39bsm5705347qto.94.2024.01.25.13.01.39 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 25 Jan 2024 13:01:40 -0800 (PST) Message-ID: <09ca4c4a-9f73-eeee-47ce-2c08f8db5ad8@dunslane.net> Date: Thu, 25 Jan 2024 16:01:39 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.15.1 Subject: Re: More new SQL/JSON item methods Content-Language: en-US To: Tom Lane Cc: Jeevan Chalke , Peter Eisentraut , PostgreSQL Hackers References: <1d092c02-8249-4e56-8b8e-ae4db95b8fde@eisentraut.org> <5d37428e-0753-e721-8e77-81cc4d0dc9f1@dunslane.net> <439811.1706211069@sss.pgh.pa.us> <448055.1706214831@sss.pgh.pa.us> From: Andrew Dunstan In-Reply-To: <448055.1706214831@sss.pgh.pa.us> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2024-01-25 Th 15:33, Tom Lane wrote: > Andrew Dunstan writes: >> On 2024-01-25 Th 14:31, Tom Lane wrote: >>> (The reported crashes seem to be happening later during a >>> recursive invocation, seemingly because JsonbType(jb) is >>> returning garbage. So there may be another bug after this one.) >> I don't think so. AIUI The first call deals with the '$' and the second >> one deals with the '.string()', which is why we see the error on the >> second call. > There's something else going on, because I'm still getting the > assertion failure on my Mac with this fix in place. Annoyingly, > it goes away if I compile with -O0, so it's kind of hard to > identify what's going wrong. > > Curiouser and curiouser. On my Mac the error is manifest but the fix you suggested cures it. Built with -O2 -g, clang 15.0.0, Apple Silicon. cheers andrew -- Andrew Dunstan EDB: https://www.enterprisedb.com