Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e71bX-0007Se-U0 for pgsql-bugs@arkaria.postgresql.org; Tue, 24 Oct 2017 15:59:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e71bW-0003Xr-PB for pgsql-bugs@arkaria.postgresql.org; Tue, 24 Oct 2017 15:58:58 +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.84_2) (envelope-from ) id 1e71Wo-0000qA-Hy for pgsql-bugs@postgresql.org; Tue, 24 Oct 2017 15:54:06 +0000 Received: from wrigleys.postgresql.org ([204.145.124.246]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e71Wl-0005bN-QU for pgsql-bugs@postgresql.org; Tue, 24 Oct 2017 15:54:05 +0000 MIME-Version: 1.0 Subject: BUG #14870: wrong query results when using WITH with UPDATE To: pgsql-bugs@postgresql.org From: andreigorita@gmail.com Cc: andreigorita@gmail.com Date: Tue, 24 Oct 2017 15:53:58 +0000 Message-ID: <20171024155358.1471.82377@wrigleys.postgresql.org> Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-bugs Precedence: bulk Sender: pgsql-bugs-owner@postgresql.org VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDg3MApMb2dnZWQgYnk6ICAg ICAgICAgIEFuZHJlaSBHb3JpdGEKRW1haWwgYWRkcmVzczogICAgICBhbmRy ZWlnb3JpdGFAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjogOS42LjEK T3BlcmF0aW5nIHN5c3RlbTogICBDZW50T1MKRGVzY3JpcHRpb246ICAgICAg ICAKCndoZW4gdXBkYXRpbmcgYSB0YWJsZSB3aXRoIHVuaXF1ZSBpbmRleCB3 aXRoaW4gYSBXSVRIIHBhcnQgb2YgYSBxdWVyeSwgaW4KY2VydGFpbiBjb25k aXRpb25zIHRoZSBxdWVyeSByZXBvcnRzIHRoYXQgdXBkYXRlZCBtb3JlIHRo YW4gb25lIHJvdy4NCg0KQSBzaW1wbGUgd2F5IHRvIHJlcHJvZHVjZToNCg0K dGVzdD0+IGNyZWF0ZSB0YWJsZSB0bXBfdGVzdChpZCBpbnQgbm90IG51bGws IHRlc3QgdGV4dCBub3QgbnVsbCk7DQpDUkVBVEUgVEFCTEUNCnRlc3Q9PiBj cmVhdGUgdW5pcXVlIGluZGV4IG9uIHRtcF90ZXN0KGlkKTsNCkNSRUFURSBJ TkRFWA0KdGVzdD0+IElOU0VSVCBJTlRPIHRtcF90ZXN0IFZBTFVFUyAoMSwg J3Rlc3QnKTsNCklOU0VSVCAwIDENCnRlc3Q9PiBjcmVhdGUgdGFibGUgdG1w X3Rlc3QyKGlkIGludCBub3QgbnVsbCwgdGVzdCB0ZXh0IG5vdCBudWxsKTsN CkNSRUFURSBUQUJMRQ0KDQp0ZXN0PT4gV0lUSCB1cGRhdGVkIEFTIChVUERB VEUgdG1wX3Rlc3QgU0VUIHRlc3QgPSAndGVzdCcgV0hFUkUgaWQgPSAxClJF VFVSTklORyBpZCksIGluc2VydGVkIEFTIChJTlNFUlQgSU5UTyB0bXBfdGVz dDIgKGlkLCB0ZXN0KSBTRUxFQ1QgMSwKJ3Rlc3QnIFdIRVJFIE5PVCBFWElT VFMgKFNFTEVDVCAxIEZST00gdXBkYXRlZCkgUkVUVVJOSU5HIGlkKSBTRUxF Q1QgKiBGUk9NCnVwZGF0ZWQ7DQogaWQgDQotLS0tDQogIDENCigxIHJvdykN Cg0KVGhpcyBpcyB0aGUgZXhwZWN0ZWQgcmVzdWx0LCBidXQgd2hlbiBhbm90 aGVyIHNlc3Npb24gaXMgZXhlY3V0aW5nIGluCnBhcmFsbGVsOg0KdGVzdD0+ IGJlZ2luOw0KQkVHSU4NCnRlc3Q9PiBVUERBVEUgdG1wX3Rlc3QgU0VUIHRl c3QgPSAndGVzdCcgV0hFUkUgaWQgPSAxOw0KVVBEQVRFIDENCnRlc3Q9PiBj b21taXQ7DQpDT01NSVQNCg0KDQp0aGUgcmVzdWx0IGlzOg0KDQp0ZXN0PT4g V0lUSCB1cGRhdGVkIEFTIChVUERBVEUgdG1wX3Rlc3QgU0VUIHRlc3QgPSAn dGVzdCcgV0hFUkUgaWQgPSAxClJFVFVSTklORyBpZCksIGluc2VydGVkIEFT IChJTlNFUlQgSU5UTyB0bXBfdGVzdDIgKGlkLCB0ZXN0KSBTRUxFQ1QgMSwK J3Rlc3QnIFdIRVJFIE5PVCBFWElTVFMgKFNFTEVDVCAxIEZST00gdXBkYXRl ZCkgUkVUVVJOSU5HIGlkKSBTRUxFQ1QgKiBGUk9NCnVwZGF0ZWQ7DQogaWQg DQotLS0tDQogIDENCiAgMQ0KKDIgcm93cykNCg0Kd2hpY2ggaXMgYXQgbGVh c3Qgc3RyYW5nZS4KCgotLSAKU2VudCB2aWEgcGdzcWwtYnVncyBtYWlsaW5n IGxpc3QgKHBnc3FsLWJ1Z3NAcG9zdGdyZXNxbC5vcmcpClRvIG1ha2UgY2hh bmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjoKaHR0cDovL3d3dy5wb3N0Z3Jl c3FsLm9yZy9tYWlscHJlZi9wZ3NxbC1idWdzCg==