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 1mpyG7-0002Kh-MH for pgsql-bugs@arkaria.postgresql.org; Wed, 24 Nov 2021 19:48:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mpyG6-00074t-EX for pgsql-bugs@arkaria.postgresql.org; Wed, 24 Nov 2021 19:48:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mpyG6-00074k-5X for pgsql-bugs@lists.postgresql.org; Wed, 24 Nov 2021 19:48:46 +0000 Received: from mail-pg1-x52c.google.com ([2607:f8b0:4864:20::52c]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mpyFz-0001Jq-T7 for pgsql-bugs@lists.postgresql.org; Wed, 24 Nov 2021 19:48:45 +0000 Received: by mail-pg1-x52c.google.com with SMTP id m15so3085372pgu.11 for ; Wed, 24 Nov 2021 11:48:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=from:to:subject:date:message-id:in-reply-to:references:mime-version :content-transfer-encoding; bh=vPNMIQvOMxx3PXTrjexM7N928YC+61n8EpPYO+P8G9w=; b=Vi5j8d6eCBGivHsXgwkH5khwI53Z01bhsOR8lMbN6wncXC5DlvQVOHaWti4ZcA6Du1 pwuIhQaEg2viXkW6/YGssP7ED9xNo4llp9lwCYowBruvdUy2xyltowTsPOlN+DZ0QuN8 FfZxYSrNWWkrjzL3j3/FVIwFpYTcwU3ThuvRp+IHwGTmXXERlue1CKiad8GcEmjn7m+J XKlOAPoawMuuiHiionz0Cup8d5EEG/FdrAVcSSGA2gfK5mcM5ZnNAQpkuviFMOBJEmMC b93/8re9oRlOnbNcf/n1ztIZWUuekBHMZyRfhgTT83QDaDdT6/zJevtpB1sSOjIUu6Jm YOPw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:from:to:subject:date:message-id:in-reply-to :references:mime-version:content-transfer-encoding; bh=vPNMIQvOMxx3PXTrjexM7N928YC+61n8EpPYO+P8G9w=; b=rI6nvBpEj93vrJNQsHeksYOEn3IqW57KaLFtdbHz5ecApMauitRcf/FiTOmfYehHnB rQNDHxIMxXgsZcichK24pgMmXxOvTLlRm/CI6EZ4a+HKItu4bWjkUEe1fRCRYN2UxwKT irVZxVtdUB9QuR8rcsrdRFBsn1GBWjkGlxmW2qBCeZvz7T4YGvhuBOKLVrKnPV4JLTch TRHMy5sLDWqtY6pR0dCJ8wLsbOrYtiBDQXC9fy6Svp5RYsXGH7Rl/qQx9k/WlVE+lV/n gkq79fMuwggNMCVGW6ZgREGwSnwBswi9HHcOhJZ7neGa9tyCeFe9xOFWa4CnniOoZAnP sEVQ== X-Gm-Message-State: AOAM532j83Sh9Gx7EKiKyVgn0q4BevN9WBgffEeU5dM4r/VJEo942og9 SXZtLKhhG6ax2/ZtpPuQl8UXN9WLNJv35g== X-Google-Smtp-Source: ABdhPJwjIAfIw75SIO4RhahkNqY1ISt4CVkBUdLVAxVFoq0d11fhKWRiOZMTxC+Q9JxMOKp0Z4RZ6Q== X-Received: by 2002:a63:a809:: with SMTP id o9mr11661494pgf.65.1637783318542; Wed, 24 Nov 2021 11:48:38 -0800 (PST) Received: from vulcan.edgedb.net (c-98-47-239-19.hsd1.ca.comcast.net. [98.47.239.19]) by smtp.gmail.com with ESMTPSA id c5sm350487pgi.89.2021.11.24.11.48.37 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 24 Nov 2021 11:48:38 -0800 (PST) From: Elvis Pranskevichus To: PostgreSQL mailing lists , David Rowley Subject: Re: BUG #17213: Wrong result from a query involving Merge Semi Join and Memoize Date: Wed, 24 Nov 2021 11:48:37 -0800 Message-ID: <3214388.mvXUDI8C0e@vulcan.edgedb.net> In-Reply-To: References: <17213-988ed34b225a2862@postgresql.org> MIME-Version: 1.0 Content-Transfer-Encoding: 7Bit Content-Type: text/plain; charset="us-ascii" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tuesday, November 23, 2021 5:58:30 PM PST David Rowley wrote: > On Mon, 22 Nov 2021 at 23:36, David Rowley > > I'm planning on giving the patch I submitted another look with the > > intention of pushing it tomorrow. > > Pushed with the addition of a test to exercise the cache flushing > code. > > Thanks for reporting this. Excellent! Thank you for tackling the bug, David! Elvis