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.98.2) (envelope-from ) id 1xM2jw-00000001pHX-2R8I for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Oct 2026 12:26:49 +0000 Received: from localhost ([127.0.0.1]:34696 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xM2jw-0000000GXZf-0OGP for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Oct 2026 12:26:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]:47896) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xM2jv-0000000GXZX-39nQ for pgsql-bugs@lists.postgresql.org; Wed, 28 Oct 2026 12:26:47 +0000 Received: from mail-ua1-x933.google.com ([2607:f8b0:4864:20::933]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xM2jt-00000001PpJ-0g4u for pgsql-bugs@lists.postgresql.org; Wed, 28 Oct 2026 12:26:47 +0000 Received: by mail-ua1-x933.google.com with SMTP id a1e0cc1a2514c-9906034086cso291938241.1 for ; Wed, 28 Oct 2026 05:26:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20260707; t=1793190403; x=1793795203; darn=lists.postgresql.org; h=content-transfer-encoding:content-type:in-reply-to:from :content-language:references:cc:to:subject:user-agent:mime-version :date:message-id:from:to:cc:subject:date:message-id:reply-to :content-type; bh=Pqw+Ak50y6V6zuLMlD17AJ350/Kn7jgcAj9B7SxSMRc=; b=PDSuUB55k/rgoUaw2QaRvGX4Mm3+RIpjTwMJkq6A7O7zIBsXQXYE8sqMFUnIERBiMK Sx0wjuUDIz7JpEBlfehFuBrjKxRoQPBXVbSjTpUoKG7c8WWA7MvGDPTvUUKQ/3cWDZNK uWcWvFhlyy5VSuEBUE0/xxrJguVAvPm4GoOZYLuYCoxavUpHzfbu5AgEfQ+H5QiCeOZL 8qpTw8H4/hiwDU0ethHLEToEIUOwXDy03bALbIvTJ9usOoDwVAaVnOrgH3Roiqkty2uX gP11tyf549n9Qmug+/kE5DElMvbhN1DZaw0A1t8zfXS+3D+JPgqj78bWxPJeLjTfJ7M5 /JgQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1793190403; x=1793795203; h=content-transfer-encoding:content-type:in-reply-to:from :content-language:references:cc:to:subject:user-agent:mime-version :date:message-id:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to:content-type; bh=Pqw+Ak50y6V6zuLMlD17AJ350/Kn7jgcAj9B7SxSMRc=; b=wAlz6A3l+ZYyoZxODvV5UXuaUyLDxyEvUZd4gDYeIKAfqUWrmd8beOyD9cgYPSykya DOdv0xKYfB/+rP866BgFE0vjJw/gzKmbNarlTMru61k9+dpkAOaIkV93vbTJRxMPayiT AleHrui+QGQi39IE4SdHJASwbOQKAoAR+RWaoPywCVAdsuVtj25qadd+a/VwIn4qR+L7 Vg4ucBiHdm6XOt346Beywk8oqb38oseJ7qQ8kA2By8/dqGQObp2yvjRWqjiUOGB5wF/A H94/LBn2jMLfuhkLDEaJErE1mgX4xr4YIwQ5X519/lDm54JX3aKTmpNVcuTKU+1VMas9 D4lw== X-Forwarded-Encrypted: i=1; AKwUvBz6VmEVcS+LZK4PImDW28YIaySyEF+Sj6C1+fhCipAj4SVwHpIBeKvsqimAJ1EyZHECNK5nY5/bTX1c@lists.postgresql.org X-Gm-Message-State: AFq9FYKjTjuXh2FgGw2OMnQIGOPonq7T+OOuFnCuxozByKuIzFyMiSDq 2h6VbZ9S6sKB1EGvhgphrLz+AvVB5JGtIq0v9xeRJD76aNQV5TD+sb9v X-Gm-Gg: AYBFou27Omg2XWeXJjVbVEi45RjW7F8HXXVwBl5lyb+2+But48PBvSZOFevF/4qpREa LW4qks/snW8U9r8h8iHp0YCUZEKeHdN8r3R4j22sOJciBUQ8o+Z9FG0Rn6FcQLj6lgSIbHDKJlj KfuWiros/qqZZwLFXiaAyif2QTwRTMXNZuSyHbmgOZMN9o7NRc1Y/eiLYr+DINqMJKGihv+6eSH Uh1GnkivTTQDpEKw5JGRa8cxvYG4PAeNJM9yE9Z4u36n6oXvZbdBZlRZ7JJJ0EfsmCeP1zkR4R9 8o7MQFMiaZ+iIOn7vGQ4Pqg3hkbmFeGMnZKInnY2b9SdheX2kACIbvbJqxsqiOIBlwd50fos8gv 1fgR0dpH97kc58f7P7805ahMVBpttkCYCfbh4OYGsUnzBn0rnuG3b0GbHTi3CnCoedWIBPcbsux Mq5u42aAj03mYsaqjKaqb5wKnZplqrYs+50b9RKPXxeSZlV4qotXcosFWtJCfhI2eFTjD4FbVpU HdCa4lwiLGgd03sejW3SBJDMUUGUHsZtBr8+BnLx2pUFGRNr5yV7p/gPadFxLHqmFRlt32yYbOb HXs57BMtBNM3uGDXUTuUu/s+KjhryT/dmpUM8V6qVpNGgHsyJWzQ4wXPud86zi5uuiakXtcavmx uql84TJwSy0c0ynjbIKGX0hs= X-Received: by 2002:a05:6102:b10:b0:7cc:33c9:b3d2 with SMTP id ada2fe7eead31-7d03a5b84admr722970137.25.1793190403052; Wed, 28 Oct 2026 05:26:43 -0700 (PDT) Received: from ?IPV6:2804:14d:32a7:4273:7536:ae02:4f2c:ca14? ([2804:14d:32a7:4273:7536:ae02:4f2c:ca14]) by smtp.gmail.com with ESMTPSA id a1e0cc1a2514c-9912dad26fcsm3161562241.11.2026.10.28.05.26.40 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 28 Oct 2026 05:26:42 -0700 (PDT) Message-ID: <537b32fc-8724-4c1a-bcdf-a260e2dea606@gmail.com> Date: Wed, 28 Oct 2026 09:26:38 -0300 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: BUG #19752: GROUP BY on a constant and a cast to a length-limited array type crashes the server while planning To: Andrey Rachitskiy Cc: Tom Lane , mertkul669@gmail.com, pgsql-bugs@lists.postgresql.org, Richard Guo References: <19752-928339cd23b58a33@postgresql.org> <2530849.1791487908@sss.pgh.pa.us> <2533535.1791490239@sss.pgh.pa.us> Content-Language: en-US From: Matheus Alcantara In-Reply-To: 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 26/10/26 06:16, Andrey Rachitskiy wrote: > Thanks for the review and the v2. You understood Tom better than I did. v3 > keeps the same code. > The queries that do not use grouping sets moved to aggregates.sql. > Thanks for the new version. I've created a CF entry for this bug: https://commitfest.postgresql.org/patch/7545/ -- Matheus Alcantara EDB: https://www.enterprisedb.com