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 1fqb4A-0002KF-6U for pgsql-bugs@arkaria.postgresql.org; Fri, 17 Aug 2018 09:29:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fqb46-0005Z1-EW for pgsql-bugs@arkaria.postgresql.org; Fri, 17 Aug 2018 09:29:06 +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 1fqb46-0005Yu-8H for pgsql-bugs@lists.postgresql.org; Fri, 17 Aug 2018 09:29:06 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fqb43-0001JW-PG for pgsql-bugs@lists.postgresql.org; Fri, 17 Aug 2018 09:29:05 +0000 Content-Type: multipart/mixed; boundary="===============8989414097542936998==" MIME-Version: 1.0 Subject: BUG #15336: Wrong cursor's bacward fetch results in select with ALL(subquery) To: pgsql-bugs@lists.postgresql.org From: =?utf-8?q?PG_Bug_reporting_form?= Cc: v.g.baranoff@gmail.com Reply-To: v.g.baranoff@gmail.com, pgsql-bugs@lists.postgresql.org Date: Fri, 17 Aug 2018 09:28:41 +0000 Message-ID: <153449812167.1304.1741624125628126322@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8989414097542936998== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTMzNgpMb2dnZWQgYnk6ICAgICAgICAgIFZsYWRpbWlyIEJhcmFub2Zm CkVtYWlsIGFkZHJlc3M6ICAgICAgdi5nLmJhcmFub2ZmQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZl cnNpb246IDEwLjAKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMTguMDQKRGVzY3JpcHRpb246 ICAgICAgICAKCmNyZWF0ZSB0YWJsZSBsb25ncyAodmFsdWUgaW50OCApIHdpdGggKCBvaWRzPWZh bHNlICk7DQppbnNlcnQgaW50byBsb25ncyAodmFsdWUpIHZhbHVlcyAoMSksICgyKSwgKDMpLCAo NCksICg1KSwgKDYpLCAoNyksICg4KSwKKDkpOw0KDQpOb3cgZmV0Y2ggcmVzdWx0cyB3aXRoIHRo ZSBjdXJzb3IgaW4gZm9yd2FyZCBkaXJlY3Rpb246DQoNCmJlZ2luOw0KZGVjbGFyZSAibXljdXJz b3IiIGJpbmFyeSBzY3JvbGwgY3Vyc29yIGZvcg0KICBzZWxlY3QgImwiLnZhbHVlIGFzICJjb2x1 bW4xIg0KICAgIGZyb20gbG9uZ3MgYXMgImwiDQogICB3aGVyZSAibCIudmFsdWUgPD4gYWxsKCBz ZWxlY3QgNSB1bmlvbiBhbGwgc2VsZWN0IDYgdW5pb24gYWxsIHNlbGVjdCA3KQ0KOw0KbW92ZSBh YnNvbHV0ZSAwIGluICJteWN1cnNvciI7DQpmZXRjaCBmb3J3YXJkIDkgZnJvbSAibXljdXJzb3Ii Ow0KY29tbWl0Ow0KVGhlIHJlc3VsdCBzZXQgaXMgY29ycmVjdCAoMSwgMiwgMywgNCwgOCwgOSku DQoNClRoZW4gZXhlY3V0ZSB0aGUgZm9sbG93aW5nIHNjcmlwdDoNCg0KYmVnaW47DQpkZWNsYXJl ICJteWN1cnNvciIgYmluYXJ5IHNjcm9sbCBjdXJzb3IgZm9yDQogIHNlbGVjdCAibCIudmFsdWUg YXMgImNvbHVtbjEiDQogICAgZnJvbSBsb25ncyBhcyAibCINCiAgIHdoZXJlICJsIi52YWx1ZSA8 PiBhbGwgKCBzZWxlY3QgNSB1bmlvbiBhbGwgc2VsZWN0IDYgdW5pb24gYWxsIHNlbGVjdCA3CikN CjsNCm1vdmUgYWJzb2x1dGUgMTAgaW4gIm15Y3Vyc29yIjsNCmZldGNoIGJhY2t3YXJkIDkgZnJv bSAibXljdXJzb3IiOw0KY29tbWl0Ow0KVGhlIHJlc3VsdCBzZXQgaXMgd3JvbmcgKDksIDgsIDcs IDYsIDUsIDQsIDMsIDIsIDEpLg0KSXQgc2VlbXMgdGhhdCBzZWxlY3Rpb24gcHJlZGljYXRlIGlz IGlnbm9yZWQuDQpSZXBsYWNpbmcgQUxMKHN1YnF1ZXJ5KSBieSBOT1QgSU4gKHN1YnF1ZXJ5KSBz b2x2ZXMgdGhlIHByb2JsZW0sIGJ1dCB0aGlzCnZpb2xhdGVzIHN0YXRlbWVudCB0aGF0ICJOT1Qg SU4gaXMgZXF1aXZhbGVudCB0byA8PiBBTEwuIi4NClRoaXMgYnVnIGhhcyBiZWVuIHJlcHJvZHVj ZWQgd2l0aCBQb3N0Z3JlU1FMIDkuNiBhbmQgMTAuMAoK --===============8989414097542936998==--