Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kKmoM-0002SA-9c for pgsql-bugs@arkaria.postgresql.org; Tue, 22 Sep 2020 18:14:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kKmoK-0008Qu-Ei for pgsql-bugs@arkaria.postgresql.org; Tue, 22 Sep 2020 18:14:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kKmL0-0007LP-NS for pgsql-bugs@lists.postgresql.org; Tue, 22 Sep 2020 17:44:22 +0000 Received: from mail-io1-xd2c.google.com ([2607:f8b0:4864:20::d2c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kKmKy-000488-8O for pgsql-bugs@lists.postgresql.org; Tue, 22 Sep 2020 17:44:22 +0000 Received: by mail-io1-xd2c.google.com with SMTP id r25so20621054ioj.0 for ; Tue, 22 Sep 2020 10:44:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=consumeracquisition.com; s=google; h=from:references:in-reply-to:mime-version:thread-index:date :message-id:subject:to:cc; bh=JGmy3xMnJ9jQZWUeFLXP+ON75oXrR3r8q9XN6hfS2sQ=; b=E7JlTIIYC3QInHKg2eBb5G0bo9dNhFNP3JW+Vp0iFC9v4w0opceQdkZfTBvZjTLQ3z sLmkpOsr/xTksQbqLlj0mM3+xFDgKoVQeUQTNFvi3XcuMGvRcMvZdJ7dSqlu4nBIa2qd LpROb5mjQ4Nv+QIDoTq1PY8tjulI/+tJnZdjFY2kpC0Ec6XES/tvHOTdI1RX893GyONn hgGdCOI5MAE2Bv+5xx/Iz/yKsBB19u3SXmtD6Ue/99zAjwIPOgss30vV0v54lbFRJMJ4 2U9hDJ1jw0mlnrNCmIyCmlqukQMIZTaA5YsoKX18sKRDG18NElcluws2AQeFJ6NL8DyU 8Duw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:references:in-reply-to:mime-version :thread-index:date:message-id:subject:to:cc; bh=JGmy3xMnJ9jQZWUeFLXP+ON75oXrR3r8q9XN6hfS2sQ=; b=FWgjCwA+lY7k7rMjxpIrG7zF2f2VyjAxEr3ZnHUCvClQk17d5l5ohv6HoBjz+Sf0C4 YGJUa6A3jegXHH0pt8Y12yzrZOh88uksqpzKY0NszgDAbfQgJJPnJod4fjya0I7SSY6L XC5m5LHtvoSu7ENNxuskQK3B9LK1Imwlv5TC+YMNATe9aiannsAM3G6CyN96+xI+JYEl 8iDHFGzVhUUIX5+mK71x8DZsrluv7bMxSLs+qy3SQFVWWmhag0du0yDzv09vnQAnfnjf lX2ZKnAs2Tko80DYBkPBAgPNXCrLMJUId3eouxlRgLJQDNlDPXPLxw1qGran7mqN/Nei 3cNA== X-Gm-Message-State: AOAM530wsae1iV/zeifCjKn0o+W1FuXbYX0by9Md8w5+zP4zXGpoKGK0 H/d/FcblNBey58bK7zx+8KUi0fYJNy80RxQMNhzMcg== X-Google-Smtp-Source: ABdhPJw0yNis3gFaIJ//pNsPaF5phqPLiBne5ul6HPtleweO1ok/Yi7DgGSdwdEwSOLVw4PSTM7yQ9Y0fYNnWbaWijw= X-Received: by 2002:a05:6638:ec5:: with SMTP id q5mr5051310jas.13.1600796658298; Tue, 22 Sep 2020 10:44:18 -0700 (PDT) From: Brian Kanaga References: <16627-1a2233d31af8d35b@postgresql.org> <1247744.1600790017@sss.pgh.pa.us> In-Reply-To: <1247744.1600790017@sss.pgh.pa.us> MIME-Version: 1.0 X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQFCGk40Jq6YRioKLCTOIuxDFmlbqwMTjWxUqoU+GGA= Date: Tue, 22 Sep 2020 12:41:25 -0500 Message-ID: Subject: RE: BUG #16627: union all with partioned table yields random aggregate results To: Tom Lane Cc: pgsql-bugs@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, confirming it happens in 11.9 and 12.4. -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Tuesday, September 22, 2020 10:54 AM To: kanaga@consumeracquisition.com Cc: pgsql-bugs@lists.postgresql.org Subject: Re: BUG #16627: union all with partioned table yields random aggregate results PG Bug reporting form writes: > The following bug has been logged on the website: > Bug reference: 16627 > Logged by: Brian Kanaga > Email address: kanaga@consumeracquisition.com > PostgreSQL version: 11.4 > Operating system: Linux > Description: > Hoping this is something already discovered as the amount of data to > recreate is cumbersome. Well, 11.4 is more than a year out of date. Can you still reproduce this on the current minor release (11.9)? regards, tom lane