Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fqgvm-00032J-Oe for pgsql-bugs@arkaria.postgresql.org; Fri, 17 Aug 2018 15:44:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fqgvl-0003nB-3A for pgsql-bugs@arkaria.postgresql.org; Fri, 17 Aug 2018 15:44:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fqgvk-0003n4-Ta for pgsql-bugs@lists.postgresql.org; Fri, 17 Aug 2018 15:44:52 +0000 Received: from lungold.riddles.org.uk ([82.68.208.19]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fqgvi-0001WG-3e for pgsql-bugs@lists.postgresql.org; Fri, 17 Aug 2018 15:44:52 +0000 Received: from [192.168.127.1] (port=42441 helo=caithnard.riddles.org.uk) by lungold.riddles.org.uk with esmtps (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256) (Exim 4.88 (FreeBSD)) (envelope-from ) id 1fqgvf-000DYr-6N; Fri, 17 Aug 2018 15:44:47 +0000 Received: from [127.0.0.1] (port=59791 helo=caithnard.riddles.org.uk) by caithnard.riddles.org.uk with esmtp (Exim 4.89 (FreeBSD)) (envelope-from ) id 1fqgve-000LM0-E3; Fri, 17 Aug 2018 15:44:46 +0000 From: Andrew Gierth To: Tom Lane Cc: pgsql-bugs@lists.postgresql.org, v.g.baranoff@gmail.com Subject: Re: BUG #15336: Wrong cursor's bacward fetch results in select with ALL(subquery) In-Reply-To: <14723.1534514356@sss.pgh.pa.us> (Tom Lane's message of "Fri, 17 Aug 2018 09:59:16 -0400") Message-ID: <877ekp2e3g.fsf@news-spur.riddles.org.uk> References: <153449812167.1304.1741624125628126322@wrigleys.postgresql.org> <87va892tf5.fsf@news-spur.riddles.org.uk> <87mutl2pv1.fsf@news-spur.riddles.org.uk> <87in492jrn.fsf@news-spur.riddles.org.uk> <14723.1534514356@sss.pgh.pa.us> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (berkeley-unix) Date: Fri, 17 Aug 2018 16:44:46 +0100 MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk >>>>> "Tom" == Tom Lane writes: >> It turns out to be also necessary to do this in ExecSetParamPlan, >> though I couldn't find a way to make a stable regression test for >> that - my manual tests were based on putting a subselect inside a >> volatile construct like CASE WHEN random() < x THEN. Tom> Looks sane to me ... Pushed. -- Andrew (irc:RhodiumToad)