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 1whFq2-0006pj-0k for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Jul 2026 00:08: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 1whFpz-003loR-2T for pgsql-bugs@arkaria.postgresql.org; Wed, 08 Jul 2026 00:08:28 +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 1whFpz-003loJ-1h for pgsql-bugs@lists.postgresql.org; Wed, 08 Jul 2026 00:08:28 +0000 Received: from mail-oa1-x30.google.com ([2001:4860:4864:20::30]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1whFpx-000000008GI-2Urn for pgsql-bugs@postgresql.org; Wed, 08 Jul 2026 00:08:28 +0000 Received: by mail-oa1-x30.google.com with SMTP id 586e51a60fabf-44868d6a066so36016fac.3 for ; Tue, 07 Jul 2026 17:08:25 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1783469303; cv=none; d=google.com; s=arc-20260327; b=aevZmRkk5X20vCaNDwRs5XvcugmFUUxu3gZdqTdJFLD3/u7Xs5Cdv1NPlVQhBnSg4X yYAbkcB73uai770bhw8Crp6UPG+j+XMGAkNAA9VAad2nmclR6Z/fZgKZktoQdLT5Uun9 4O+syc6g6QgZ/nHJ6rUOq4xlq6pCKJxcYkkC3m+lBXn/avLr0MmOYc4Rt9NtwmnCvU0r CIpWnNBaW3kAXTq6r2cpC5lVsye/7ZFbfnVLhsDeokshm75yTOx8bpjPNkwPVfSzlbce 7LLW7kGEv7RsydLznwSeq7r5qdL6yPWXXhUTaNwj4PJVb+UFpD08CD+CaM9RIa3jAQoD h3MA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20260327; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=B5TjqSEs0Wss02PY2XjBHwuYa6QaX6sTvMU0qGUh7j0=; fh=fNPwCKKQjS7loeG0QdVScHdB5f+5X6umzsZdLK/kF0g=; b=R6ELrHkgOI2Ynl18qCXR1LUlxl/2UzDTsWqja8Rw7vPnJyj5zryW5kyyzuOYQJJTTj EetQyeOsGQNZYkfCguIIC8DIHFXokvAxS960+N3cK4iTNaz4ZhBzyvoawwjSQX8JGlTN 0oaFs21wa4NZLmsS9bVNR6jC+LhAowoGohp47QrvVS0Va+MJ6i0V7hTNmbfrKiQPU5xq JbJx7XpJ9G4qD+bhYov+vzfK+8cqltR9tB2gDoAHvWIifgS6E7AnRUH0J/6Iudq5/WJq BZWrKfG8Kx7NsCr0u0Gp9PrHqwfydDVsGbW/+sQeubMdoBPUg01S5piiIDnGFtWRZHgw gbWw==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1783469303; x=1784074103; darn=postgresql.org; h=content-transfer-encoding:content-type:cc:to:subject:message-id :date:from:in-reply-to:references:mime-version:from:to:cc:subject :date:message-id:reply-to:content-type; bh=B5TjqSEs0Wss02PY2XjBHwuYa6QaX6sTvMU0qGUh7j0=; b=GqU1J1ldXYEXC6YIIWQt/GW8Er4GBBMK92UwbqTSYnBpx+h5jefGtcFTOvgcuYgn0W GAqWHpqs0BXKcjNtq3UwJSztzqk4NSmRWdxHBt7XWskbr+CFDNl7M3krpv9Ho5RDioV/ O3c2LMJSUBEarRoth5Eq4bwiu4tolGSlbvyNeRYS3t1DJTLgHhToG1W9bExsH7fU/M6o lLPAqJEd3BnEebQfPIE9sxgjFcMH63CVLJy790y5DuyQ0XNtkj004qJe+lDSkUFhJFyB qQniKs6+GBu1JJIWWL0RBcVgl7meQatCK6Q1RWMkcyVJYwlh8D4fqArBWBZbrYxFkABR DnDw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1783469303; x=1784074103; h=content-transfer-encoding:content-type:cc:to:subject:message-id :date:from:in-reply-to:references:mime-version:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=B5TjqSEs0Wss02PY2XjBHwuYa6QaX6sTvMU0qGUh7j0=; b=RCKQbwAY/yjTzrJImBObbBkC4hlvgGj4A+Po7rbRz6/MUK1T6zBVXR2NpUyjbB3vBM WQj1gdCedN/cYa+Cu1ZNqzEq3aKbCXVAzaFUjgDJuJb2OCa1K9cEcxMF2IIQ8hifTto8 KX0YAocf4Y7A20jO89z5l2PSE7xxvFUt16LwM8aG2zJQgONCPHSTiGeax9B05bhDRomx rmQZ2kZxyqv6OUMZSn03gBquqnNRwKk2zFDFjdamvDGYtPE7qjE1v8BwAieAI9mnZWcS y6CpzT2P2VZ/giToGDflal0hCzh1mh4jtXC01YPgdgR7ONacvcfYvHWRF20LyfADirvu dC5g== X-Gm-Message-State: AOJu0Yw7clNGVweiztJfpRrO5QEq5wkSFBiN9Kg05Y/grHwY7+3xWfFr GECSd6ZyssP2YACf5or1896HqGles1fPFPKWAXWnq9C5DI13e3LMrDB1eQ+RIGQoUQx1YON5yc/ zC5MTOTOmW2YRzuoRFrYpvTidRHHgR9Q= X-Gm-Gg: AfdE7clJQ8PVdjl/ONs/n86gO5M0RoVsTKNWEjMcP38nyT+uJ3f4RgPgQah5p7dbRlq yP29OMUIPtAHFzCpzMcJh8drL+TFNPLHPZ4mKbo1xbLkqUeN5/FG+4yK0KlX2EUmwu0ZdaCavgC iW6td4iMOrVV/ui/MZPHZPZ2tCyG+ogxsSxD3H2PcJCIoeLDzHrkvcvzlyxLE+ijMmERApSt1O8 aGCwtbtFffIp6PMzFKxiVuHBpWt59VYwu1GEWE+XHxKnYMhgh9tfwIcaO2bdKdN6Nd3Gy6+38Dn DJAlq1g/ X-Received: by 2002:a05:6870:1c6:b0:44c:70d0:fe3 with SMTP id 586e51a60fabf-451637bb0e0mr148859fac.2.1783469303516; Tue, 07 Jul 2026 17:08:23 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Richard Guo Date: Wed, 8 Jul 2026 09:08:12 +0900 X-Gm-Features: AVVi8CdugCn0FkzvPBqyZbu5ZyNGdbQXhMvnl0x6az8zabBsRGWsMlBP0tVzxho Message-ID: Subject: Re: EXPLAIN (VERBOSE) fails with for JSON_ARRAYAGG/JSON_OBJECTAGG + window function To: Thom Brown Cc: pgsql-bugs Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Jul 7, 2026 at 11:20=E2=80=AFPM Thom Brown wrote: > So all looks good to me. Pushed and back-patched. - Richard