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 1pnIgW-0000Zc-Hq for pgsql-hackers@arkaria.postgresql.org; Fri, 14 Apr 2023 12:37:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pnIgV-0003Md-FD for pgsql-hackers@arkaria.postgresql.org; Fri, 14 Apr 2023 12:37:47 +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 1pnIgV-0003MU-5o for pgsql-hackers@lists.postgresql.org; Fri, 14 Apr 2023 12:37:47 +0000 Received: from mail-lj1-x232.google.com ([2a00:1450:4864:20::232]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1pnIgS-002rQS-3N for pgsql-hackers@postgresql.org; Fri, 14 Apr 2023 12:37:46 +0000 Received: by mail-lj1-x232.google.com with SMTP id k15so748658ljq.4 for ; Fri, 14 Apr 2023 05:37:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1681475862; x=1684067862; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=gvCVHW/yncWak/RxL0owea025jldQOI8waiJx+Lgom8=; b=oPrvWE4QdRP3bsOQgt8VDMLLpRZeLqTiyzVVaRgqY9/VnPtbRonBtBzuLgvEozUd49 AJLQKdfJkPVypqlWDkjKvpEnap3yImPpFJWmzbz9rDbjdfEp791ig6VOvyIhSLmR1Hqc E0vVxfvfS0QENT8r7WQUMLGEkjA7ExROnQdwJDT4YASbnjwQtnRCqK8IEt2zG0M1O/Dz UbcXYhZPk+yLsJyeRSljxBcNq4nV6NNijDwiS2LErUDmUXG05HdentnhyPAc2YpFfnbX +4kCENCQvON3MrFn80W/15gjosQInh5dzvIsw9/se9wB1XWFU3XHctIk+21ZZ0jf+wzC xSPg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1681475862; x=1684067862; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=gvCVHW/yncWak/RxL0owea025jldQOI8waiJx+Lgom8=; b=b4DXGaKLFnKN9M/aLO6qxjb4a7aZtPsrl8qNM2xGLtGtdPCiPSvs35dKgI+4V2V7rU 4lRHi+3llS0rHh6hsRlX7Y7iCaiRzBF4eepkyMoUZMxK6QpT4PbPwCr5wD7SZvkXZZ2z NjfIAYYrkMZQor4kXJkFm2u32v2i5jwYRMQUe0T6haFGKAKxLzuHV4WtLir6ZSy5czWi uQv3YHGqwsJdlSxo3QQaGcNXS4/squL7F9cO9JnAPovQ3EYRz0d7BQfr7pglQ3ol/DJK K4dqIo5BbZzB9ucv/SetpT2xaJWVQtsxspwZTJKnMHh5Pr6uNWenEiSs3ZcoS1BXXaDL J4FQ== X-Gm-Message-State: AAQBX9cba94Zl8cd2ipJHXogzy2xG4om2N8nloBn2BbaLllz17uMLEf4 QkX75TJUzN6HsRhzOshliSMF5KM7ZkVP1QMFRls= X-Google-Smtp-Source: AKy350YJ/m2whr8mMSjWZqgkmjte7Cxr3r+6V+pUhOu19ZYgG5E895ekwSUAbusumGWVJSPPvq4t3mYf0UWd4LXsPTo= X-Received: by 2002:a2e:9082:0:b0:2a7:828c:591b with SMTP id l2-20020a2e9082000000b002a7828c591bmr1883286ljg.10.1681475862004; Fri, 14 Apr 2023 05:37:42 -0700 (PDT) MIME-Version: 1.0 References: <20230412181452.cyfduw2ka2atqmii@awork3.anarazel.de> In-Reply-To: From: Robert Haas Date: Fri, 14 Apr 2023 08:37:30 -0400 Message-ID: Subject: Re: Wrong results from Parallel Hash Full Join To: Thomas Munro Cc: Melanie Plageman , Andres Freund , Richard Guo , PostgreSQL-development 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 Thu, Apr 13, 2023 at 7:06=E2=80=AFPM Thomas Munro wrote: > For some reason I thought we weren't supposed to use the flat thing, > but it looks like I'm just wrong and people do that all the time so I > take that back. > > Pushed. Thanks Richard and Melanie. I tend to use http://postgr.es/m/ or https://postgr.es/m/ just to keep the URL a bit shorter, and also because I like to point anyone reading the commit log to the particular message that I think is most relevant rather than to the thread as a whole. But I don't think there's any hard-and-fast rule that committers have to do it one way rather than another. --=20 Robert Haas EDB: http://www.enterprisedb.com