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 1mwngg-0007zC-J0 for pgsql-bugs@arkaria.postgresql.org; Mon, 13 Dec 2021 15:56:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mwngf-00071R-FA for pgsql-bugs@arkaria.postgresql.org; Mon, 13 Dec 2021 15:56:25 +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 1mwmaf-0006DE-VL for pgsql-bugs@lists.postgresql.org; Mon, 13 Dec 2021 14:46:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mwmac-00082n-TX for pgsql-bugs@lists.postgresql.org; Mon, 13 Dec 2021 14:46:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=Da2bwbAex8X6xkUCWbmtUnutGF4Pvxr0bhFEo+q8nc8=; b=rcYryJJqL1f/+DpuRL2j+IyEtE qHDRxTFIhEdgS3RKevsGRrCaGP1ekh8BiiucGcr+y+7hnHJbY9Jok4V35R0laE2zn0cfkATHn4VoW 4m5TtXLOAgrudV1mVUuy/n1dCxI+M2sUlktJOUYEtuKoLVyNniUP6MWzjHzKf4UmSgEsicD3eDUvr DNWfe5KDStGHpV12SVVU7xCnGY5SE4PPOe5LhnhFF+15VZvWFtOuW1XzX7WZiGxzmcZsHffAtrZNV MxXdXLEM36cF+1lgFM8yKyF5htHyANOMm9fJW5D74/ypCM1FKiXaDXOMGN7l0REZDLA2/bracKPf7 wpktRCow==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mwmaa-0002bQ-Rv for pgsql-bugs@lists.postgresql.org; Mon, 13 Dec 2021 14:46:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mwmaY-0007OJ-8A for pgsql-bugs@lists.postgresql.org; Mon, 13 Dec 2021 14:46:02 +0000 Content-Type: multipart/mixed; boundary="===============5389850023209538807==" MIME-Version: 1.0 Subject: BUG #17335: Duplicate result rows in Gather node when "Suppress Append ... that have a single child" applied To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: y.sokolov@postgrespro.ru Reply-To: y.sokolov@postgrespro.ru, pgsql-bugs@lists.postgresql.org Date: Mon, 13 Dec 2021 14:45:36 +0000 Message-ID: <17335-4dc92e1aea3a78af@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5389850023209538807== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzMzNQpMb2dnZWQgYnk6ICAgICAgICAgIFl1cmEgU29rb2xvdgpFbWFp bCBhZGRyZXNzOiAgICAgIHkuc29rb2xvdkBwb3N0Z3Jlc3Byby5ydQpQb3N0Z3JlU1FMIHZlcnNp b246IDE0LjEKT3BlcmF0aW5nIHN5c3RlbTogICBhbnkKRGVzY3JpcHRpb246ICAgICAgICAKCk91 ciBjdXN0b21lciBmYWNlZCBhIHF1ZXJ5IHRoYXQgcmV0dXJucyBkdXBsaWNhdGUgcm93cyBpZiBw YXJhbGxlbCBleGVjdXRpb24KaXMgZW5hYmxlZA0KKG1heF9wYXJhbGxlbF93b3JrZXJzX3Blcl9n YXRoZXIgPiAwKSBhZnRlciAxMS0+MTIgdXBncmFkZS4NCg0KSW52ZXN0aWdhdGlvbiBzaG93cyBi dWcgd2VyZSBpbnRyb2R1Y2VkIGluCjhlZGQwZTc5NDYwYjQxNGIxZDk3MTg5NTMxMmU1NDllOTVl MTJlNGYNCiJTdXBwcmVzcyBBcHBlbmQgYW5kIE1lcmdlQXBwZW5kIHBsYW4gbm9kZXMgdGhhdCBo YXZlIGEgc2luZ2xlIGNoaWxkLiIgLg0KQnVnIGlzIHByZXNlbnQgaW4gYWxsIHZlcnNpb25zIHNp bmNlIDEyIGJldGEsIGFuZCBpdCBpcyByZXByb2R1Y2VkIGluIG1hc3RlcgpicmFuY2ggYXMgd2Vs bC4NCg0KUmVwcm9kdWN0aW9uLg0KaHR0cHM6Ly9naXN0LmdpdGh1Yi5jb20vZnVubnktZmFsY29u LzQ1ZmE5NDYwNTA3YzAxNTM5MGRiOTlhN2VmZDE4YTc1DQoNCkR1bXAgY29udGFpbnMgZGVmaW5p dGlvbiBvZiB0d28gdGFibGVzICh3aXRoIDMgYW5kIDIgZmllbGRzKSwgaW5kZXggYW5kIGRhdGEK ZHVtcA0KbGFyZ2UgZW5vdWdoIHRvIHRyaWdnZXIgcGFyYWxsZWwgcGxhbiBleGVjdXRpb24uDQpB bHNvIGBhbmFseXplIHB1YmxpYy50ZXN0aTMsIHB1YmxpYy50ZXN0aTRgIGxpbmUgaXMgYWRkZWQu DQoNCmh0dHBzOi8vZ2lzdC5naXRodWIuY29tL2Z1bm55LWZhbGNvbi80NWZhOTQ2MDUwN2MwMTUz OTBkYjk5YTdlZmQxOGE3NS9yYXcvMDZhNTVlNTdiYzZjNDYwZWE4ODAwNjAwYjFiNTk3YzFlZDIx NjI1OS9yZXByb19kdW1wLnNxbC56c3QNCg0KUXVlcnk6DQoNCiAgICBTRUxFQ1QgY291bnQoMSkN CiAgICBGUk9NICgNCiAgICAgIFNFTEVDVCBmaywgaWQNCiAgICAgIEZST00gdGVzdGkzDQogICAg ICBXSEVSRSBmbGFnZ2VkDQogICAgICBVTklPTiBBTEwNCiAgICAgIFNFTEVDVCBmaywgaWQNCiAg ICAgIGZyb20gdGVzdGkzDQogICAgICBXSEVSRSBmYWxzZQ0KICAgICkgYXMgdA0KICAgIExFRlQg T1VURVIgSk9JTiB0ZXN0aTQNCiAgICBVU0lORyAoZmspOw0KDQpXaGVuIGBzZXQgbWF4X3BhcmFs bGVsX3dvcmtlcnNfcGVyX2dhdGhlciA9IDA7YCB0aGVuIGl0IHJldHVybnMgNDQgd2hpY2ggaXMK Y29ycmVjdC4NCldoZW4gYHNldCBtYXhfcGFyYWxsZWxfd29ya2Vyc19wZXJfZ2F0aGVyID0gMjtg IHRoZW4gaXQgcmV0dXJucyA4OCB3aGljaCBpcwp3cm9uZy4NCg0KU29tZXRpbWVzIChmb3IgZXhh bXBsZSwgd2hlbiB5b3UgdHJ5IHRvIGRlYnVnIGl0KSBpdCByZXR1cm5zIDQ0IGV2ZW4NCndpdGgg bWF4X3BhcmFsbGVsX3dvcmtlcnNfcGVyX2dhdGhlciA9IDIuDQpJdCBzZWVtcyB0aGF0IGl0IGhh cHBlbnMgd2hlbiB3b3JrZXIgcmV0dXJucyBmaXJzdCByb3cgZmFzdCBlbm91Z2ggc28NCiJHYXRo ZXIiIG5vZGUgZG9lc24ndCBzdGFydCB0byBleGVjdXRlIHBsYW4gYnkgaXRzZWxmLg0KDQpJdCBp cyBjb25maXJtZWQgYnkgYHNldCBwYXJhbGxlbF9sZWFkZXJfcGFydGljaXBhdGlvbiA9IGZhbHNl YCwgd2hpY2ggZm9yY2VzCmNvcnJlY3QgcmVzdWx0Lg0KYHNldCBlbmFibGVfcGFyYWxsZWxfYXBw ZW5kID0gZmFsc2VgIGFsc28gZm9yY2VzIGNvcnJlY3QgcmVzdWx0Lg0KDQpPcmlnaW5hbCBwbGFu IGluY2x1ZGVkIEdhdGhlciBNZXJnZSBub2RlIGFuZCBtYXhfcGFyYWxsZWxfd29ya2Vyc19wZXJf Z2F0aGVyCj0gMSAuDQpSZXByb2R1Y3Rpb24gY29kZSB1c2VzIEdhdGhlciBpbnN0ZWFkIGFuZCBt YXhfcGFyYWxsZWxfd29ya2Vyc19wZXJfZ2F0aGVyID0KMiBqdXN0IGJlY2F1c2UgaXQgd2VyZSBl YXNpZXIgdG8gZ2V0IGJhZCBwbGFuLg0KDQpQbGFuIGJlZm9yZSBjaGFuZ2UgOGVkZDBlNzk0NjBi NDE0YjFkOTcxODk1MzEyZTU0OWU5NWUxMmU0ZiAocmV0dXJucyBjb3JyZWN0CnJlc3VsdCkNCg0K IEZpbmFsaXplIEFnZ3JlZ2F0ZSAgKGNvc3Q9MjUwMDMuMTYuLjI1MDAzLjE3IHJvd3M9MSB3aWR0 aD04KSAoYWN0dWFsCnRpbWU9NDM1LjQ3My4uNDM1LjQ3MyByb3dzPTEgbG9vcHM9MSkgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgIA0KICAgLT4gIEdhdGhlciAgKGNv c3Q9MjUwMDMuMDUuLjI1MDAzLjE2IHJvd3M9MSB3aWR0aD04KSAoYWN0dWFsCnRpbWU9NDM0LjY0 Ni4uNDU2Ljg4OSByb3dzPTIgbG9vcHM9MSkgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAKICAgICAgICAgIA0KICAgICAgICAgV29ya2VycyBQbGFubmVkOiAxICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKDQogICAgICAgICBXb3JrZXJz IExhdW5jaGVkOiAxICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IAoNCiAgICAgICAgIC0+ICBQYXJ0aWFsIEFnZ3JlZ2F0ZSAgKGNvc3Q9MjQwMDMuMDUuLjI0MDAz LjA2IHJvd3M9MSB3aWR0aD04KQooYWN0dWFsIHRpbWU9NDMzLjAwMC4uNDMzLjAwMCByb3dzPTEg bG9vcHM9MikNCiAgICAgICAgICAgICAgIC0+ICBQYXJhbGxlbCBIYXNoIExlZnQgSm9pbiAgKGNv c3Q9MjE3MDEuNDcuLjI0MDAyLjg2IHJvd3M9NzQKd2lkdGg9MCkgKGFjdHVhbCB0aW1lPTMxMi41 NzYuLjQzMi45ODEgcm93cz0yMiBsb29wcz0yKQ0KICAgICAgICAgICAgICAgICAgICAgSGFzaCBD b25kOiAoIipTRUxFQ1QqIDEiLmZrID0gdGVzdGk0LmZrKSAgICAgICAgICAgICAKDQogICAgICAg ICAgICAgICAgICAgICAtPiAgUGFyYWxsZWwgQXBwZW5kICAoY29zdD0wLjQyLi45LjE4IHJvd3M9 MjQgd2lkdGg9NCkKKGFjdHVhbCB0aW1lPTAuMDIxLi4wLjExMiByb3dzPTE2IGxvb3BzPTIpDQog ICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgU3VicXVlcnkgU2NhbiBvbiAiKlNFTEVDVCog MSIgCihjb3N0PTAuNDIuLjkuMTEgcm93cz0yNCB3aWR0aD00KSAoYWN0dWFsIHRpbWU9MC4wNDEu LjAuMjE2IHJvd3M9MzMgbG9vcHM9MSkKICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAtPiAgSW5kZXggU2NhbiB1c2luZyB0ZXN0aTNfaXggb24gdGVzdGkzIAoo Y29zdD0wLjQyLi44Ljg3IHJvd3M9MjQgd2lkdGg9OCkgKGFjdHVhbCB0aW1lPTAuMDM5Li4wLjIw NyByb3dzPTMzCmxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICBJbmRleCBDb25kOiAoZmxhZ2dlZCA9IHRydWUpICAgICAgICAgCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg DQogICAgICAgICAgICAgICAgICAgICAtPiAgUGFyYWxsZWwgSGFzaCAgKGNvc3Q9MTIwODQuOTEu LjEyMDg0LjkxIHJvd3M9NTg2MDkxCndpZHRoPTQpIChhY3R1YWwgdGltZT0zMDUuNDczLi4zMDUu NDczIHJvd3M9NzAzMzA5IGxvb3BzPTIpICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAg ICAgICAgICAgICBCdWNrZXRzOiAxMzEwNzIgIEJhdGNoZXM6IDMyICBNZW1vcnkgVXNhZ2U6CjI3 ODRrQiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAKICAgDQogICAgICAgICAgICAgICAgICAgICAgICAgICAtPiAgUGFy YWxsZWwgU2VxIFNjYW4gb24gdGVzdGk0IAooY29zdD0wLjAwLi4xMjA4NC45MSByb3dzPTU4NjA5 MSB3aWR0aD00KSAoYWN0dWFsIHRpbWU9MC4wMzIuLjEzOC45NTgKcm93cz03MDMzMDkgbG9vcHM9 MikNCg0KUGxhbiBhZnRlciB0aGF0IGNoYW5nZSAocmV0dXJucyB3cm9uZyByZXN1bHQpDQoNCiBG aW5hbGl6ZSBBZ2dyZWdhdGUgIChjb3N0PTI1MDAzLjg3Li4yNTAwMy44OCByb3dzPTEgd2lkdGg9 OCkgKGFjdHVhbAp0aW1lPTY1Mi4wNjIuLjY1Mi4wNjIgcm93cz0xIGxvb3BzPTEpICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAg IA0KICAgLT4gIEdhdGhlciAgKGNvc3Q9MjUwMDMuNzUuLjI1MDAzLjg2IHJvd3M9MSB3aWR0aD04 KSAoYWN0dWFsCnRpbWU9NjUxLjQ4Mi4uNjY4LjcxOCByb3dzPTIgbG9vcHM9MSkgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAg ICAgICAgDQogICAgICAgICBXb3JrZXJzIFBsYW5uZWQ6IDEgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICANCiAgICAgICAgIFdvcmtlcnMgTGF1bmNoZWQ6IDEgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICANCiAgICAgICAgIC0+ICBQYXJ0aWFsIEFnZ3JlZ2F0ZSAgKGNvc3Q9MjQwMDMu NzUuLjI0MDAzLjc2IHJvd3M9MSB3aWR0aD04KQooYWN0dWFsIHRpbWU9NjQ5LjE1MC4uNjQ5LjE1 MCByb3dzPTEgbG9vcHM9MikgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgCiAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAKICAgIA0KICAgICAgICAgICAgICAgLT4gIFBhcmFsbGVsIEhhc2ggTGVmdCBK b2luICAoY29zdD0yMTcwMS40Ny4uMjQwMDMuNDkKcm93cz0xMDYgd2lkdGg9MCkgKGFjdHVhbCB0 aW1lPTQ2MS43NTEuLjY0OS4xMTEgcm93cz00NCBsb29wcz0yKSAgICAgICAgICAgIAogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgCiAgICAgICAgDQogICAgICAgICAgICAgICAgICAgICBIYXNoIENvbmQ6ICgi KlNFTEVDVCogMSIuZmsgPSB0ZXN0aTQuZmspICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgICAtPiAgU3VicXVl cnkgU2NhbiBvbiAiKlNFTEVDVCogMSIgIChjb3N0PTAuNDIuLjkuNTEKcm93cz0zNiB3aWR0aD00 KSAoYWN0dWFsIHRpbWU9MC4wNTAuLjAuMjI5IHJvd3M9MzMgbG9vcHM9MikgICAgICAgICAgICAg ICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgCiAgICANCiAgICAgICAgICAgICAgICAgICAgICAgICAg IC0+ICBJbmRleCBTY2FuIHVzaW5nIHRlc3RpM19peCBvbiB0ZXN0aTMgCihjb3N0PTAuNDIuLjku MTUgcm93cz0zNiB3aWR0aD04KSAoYWN0dWFsIHRpbWU9MC4wNDguLjAuMjE0IHJvd3M9MzMgbG9v cHM9MikKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgSW5kZXggQ29uZDogKGZsYWdnZWQgPSB0cnVlKSAgICAgICAgICAgICAgIAog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAg ICAgLT4gIFBhcmFsbGVsIEhhc2ggIChjb3N0PTEyMDg0LjkxLi4xMjA4NC45MSByb3dzPTU4NjA5 MQp3aWR0aD00KSAoYWN0dWFsIHRpbWU9NDQ0LjkzMS4uNDQ0LjkzMSByb3dzPTcwMzMwOSBsb29w cz0yKSAgICAgICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKDQogICAgICAgICAgICAg ICAgICAgICAgICAgICBCdWNrZXRzOiAxMzEwNzIgIEJhdGNoZXM6IDMyICBNZW1vcnkgVXNhZ2U6 CjI3ODRrQiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICANCiAgICAgICAg ICAgICAgICAgICAgICAgICAgIC0+ICBQYXJhbGxlbCBTZXEgU2NhbiBvbiB0ZXN0aTQgCihjb3N0 PTAuMDAuLjEyMDg0LjkxIHJvd3M9NTg2MDkxIHdpZHRoPTQpIChhY3R1YWwgdGltZT0wLjA0NS4u MjAyLjkxMwpyb3dzPTcwMzMwOSBsb29wcz0yKQ0KDQotLS0tLS0NCg0KcmVnYXJkcywNCll1cmEK Cg== --===============5389850023209538807==--