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 1m0mh5-0006Bb-4K for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Jul 2021 15:09:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m0mh4-0002Nq-2z for pgsql-bugs@arkaria.postgresql.org; Tue, 06 Jul 2021 15:09:02 +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 1m0mAL-0003Pf-4q for pgsql-bugs@lists.postgresql.org; Tue, 06 Jul 2021 14:35:13 +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 1m0mAE-0007Tu-J2 for pgsql-bugs@lists.postgresql.org; Tue, 06 Jul 2021 14:35:12 +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=c2uRV9T54ibnYyNF8MQCB7WLHsTy/SwEYkw0j0NwDYo=; b=H1sIcTwN/91B6YuKnMPiyAnaIK iCSQG5EI7xNr11yA57j7TRY0/dR4JzU7gID97llVMxqqX3h2UAP4upunyzrrHBGOGUQ/LSyyXXu1z rBnEt1TANkUe+wejPAwBm/gHPNBU2uzI8GcVFRqN1GLIDwlEEn34gbhgbzLzTox55gzhXvhMsfVGX rJXPNAqWVl9bxo8j/S6kmShlNuTvH9PIqRfF/gqV/uuRLx4zND5GehQklrIVkdRIkaKJoDOOdmmGz AnamcuFNM603tXDiqK3rTusZ7e0cK9vOX8LQX9xxeeeeadqiFP1t9kjJvODuaa220HF9DQBwqbN6j dfWmBcSQ==; 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 1m0mAC-0001iE-3D for pgsql-bugs@lists.postgresql.org; Tue, 06 Jul 2021 14:35:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m0mAA-0000wL-PB for pgsql-bugs@lists.postgresql.org; Tue, 06 Jul 2021 14:35:02 +0000 Content-Type: multipart/mixed; boundary="===============2165645804116504051==" MIME-Version: 1.0 Subject: BUG #17084: Wrong results of distinct node. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: maxim.boguk@gmail.com Reply-To: maxim.boguk@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 06 Jul 2021 14:34:35 +0000 Message-ID: <17084-9f83b67ab464cc69@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 --===============2165645804116504051== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzA4NApMb2dnZWQgYnk6ICAgICAgICAgIE1heGltIEJvZ3VrCkVtYWls IGFkZHJlc3M6ICAgICAgbWF4aW0uYm9ndWtAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTMuMwpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpEdXJp bmcgaW52ZXN0aWdhdGlvbiBvZiB3ZWlyZCBhcHAgYmVoYXZpb3VyIEkgZm91bmQgdmVyeSBzdHJh bmdlIHJlc3VsdHMKd2l0aCBzb3J0aW5nL2Rpc2luZyBvZiBzb21lIGRhdGFzZXQuDQpJc3N1ZSB3 YXMgcmVwcm9kdWNlZCBvbiAxMi43IHNlcnZlciBhbmQgMTMuMyBteSBsb2NhbCBsYXB0b3AuDQpE YXRhc2V0IHRhYmxlIGR1bXAgKDI1TUIgZmlsZSkgYXZhaWxhYmxlIHBlciByZXF1ZXN0Lg0KDQpR VUVSWToNCldJVEggdDEgQVMgKA0KICAgICAgICAgU0VMRUNUDQogICAgICAgICAgICBhZF9pZCwg DQogICAgICAgICAgICBhZHZlcnRpc2VyX2lkLCANCiAgICAgICAgICAgIGNhbXBhaWduX2lkLCAN CiAgICAgICAgICAgIGNhbXBhaWduX3R5cGVfaWQsIA0KICAgICAgICAgICAgYWRfZ3JvdXBfaWQs IA0KICAgICAgICAgICAgdGFyZ2V0X2lkLCANCiAgICAgICAgICAgIGRldmljZV90eXBlX2lkLCAN CiAgICAgICAgICAgIGNvdW50cnlfY29kZSwgDQogICAgICAgICAgICBibG9ja19mb3JtYXRfdHlw ZV9pZCwgDQogICAgICAgICAgICBjYXRlZ29yeV9ncm91cF9pZCwNCiAgICAgICAgICAgIGFycmF5 X2FnZyhnZW9faWQpIEFTIGdlb19pZHMNCiAgICAgICAgICBGUk9NIHRlc3QgDQogICAgICAgICAg R1JPVVAgQlkgDQogICAgICAgICAgICBhZF9pZCwgDQogICAgICAgICAgICBhZHZlcnRpc2VyX2lk LCANCiAgICAgICAgICAgIGNhbXBhaWduX2lkLCANCiAgICAgICAgICAgIGNhbXBhaWduX3R5cGVf aWQsIA0KICAgICAgICAgICAgYWRfZ3JvdXBfaWQsIA0KICAgICAgICAgICAgdGFyZ2V0X2lkLCAN CiAgICAgICAgICAgIGRldmljZV90eXBlX2lkLCANCiAgICAgICAgICAgIGNvdW50cnlfY29kZSwg DQogICAgICAgICAgICBibG9ja19mb3JtYXRfdHlwZV9pZCwgDQogICAgICAgICAgICBjYXRlZ29y eV9ncm91cF9pZA0KKSwNCnQyIEFTICgNClNFTEVDVCANCkRJU1RJTkNUIA0KICBhZF9ncm91cF9p ZCwgDQogIGNvdW50cnlfY29kZSwgDQogIGRldmljZV90eXBlX2lkLCANCiAgdGFyZ2V0X2lkLCAN CiAgYmxvY2tfZm9ybWF0X3R5cGVfaWQsDQogIGNhdGVnb3J5X2dyb3VwX2lkLA0KICBnZW9faWRz DQpGUk9NICB0MQ0KKQ0KDQpTRUxFQ1QgQ09VTlQoKikgRlJPTSB0MjsNCg0KDQpUZXN0Og0Kc2V0 IGppdCB0byBvZmY7DQpzZXQgbWF4X3BhcmFsbGVsX3dvcmtlcnNfcGVyX2dhdGhlciB0byAwOw0K c2V0IHdvcmtfbWVtIHRvIDRNQjsNCiBjb3VudCANCi0tLS0tLS0NCiA4MzkyMQ0KDQpzZXQgd29y a19tZW0gdG8gJzY0TUInOw0KIGNvdW50IA0KLS0tLS0tLQ0KIDU1NjM0DQoNClBsYW4gd2l0aCA0 TUIgd29ya19tZW06DQogQWdncmVnYXRlICAoY29zdD0zMjU4NzMwLjUyLi4zMjU4NzMwLjUzIHJv d3M9MSB3aWR0aD04KSAoYWN0dWFsCnRpbWU9MTY2MDcuNjc5Li4xNjYwNy42ODAgcm93cz0xIGxv b3BzPTEpDQogICAtPiAgSGFzaEFnZ3JlZ2F0ZSAgKGNvc3Q9MzIzMjY0OS40OS4uMzI1NzQ2MS4z NyByb3dzPTEwMTUzMiB3aWR0aD02NykKKGFjdHVhbCB0aW1lPTE2MTI2LjMxNS4uMTY2MDQuMzk0 IHJvd3M9ODM3MDAgbG9vcHM9MSkNCiAgICAgICAgIEdyb3VwIEtleTogdGVzdC5hZF9ncm91cF9p ZCwgdGVzdC5jb3VudHJ5X2NvZGUsCnRlc3QuZGV2aWNlX3R5cGVfaWQsIHRlc3QudGFyZ2V0X2lk LCB0ZXN0LmJsb2NrX2Zvcm1hdF90eXBlX2lkLAp0ZXN0LmNhdGVnb3J5X2dyb3VwX2lkLCBhcnJh eV9hZ2codGVzdC5nZW9faWQpDQogICAgICAgICBQbGFubmVkIFBhcnRpdGlvbnM6IDggIEJhdGNo ZXM6IDc3ICBNZW1vcnkgVXNhZ2U6IDQzMTNrQiAgRGlzawpVc2FnZTogMTM5Nzg0a0INCiAgICAg ICAgIC0+ICBHcm91cEFnZ3JlZ2F0ZSAgKGNvc3Q9Mjc3MTk0OC4wNC4uMzA4OTIzNS41NCByb3dz PTEwMTUzMjAKd2lkdGg9OTkpIChhY3R1YWwgdGltZT0xMjA5Ny41MzYuLjE1Njc1LjgwNyByb3dz PTcwNTgzNiBsb29wcz0xKQ0KICAgICAgICAgICAgICAgR3JvdXAgS2V5OiB0ZXN0LmFkX2lkLCB0 ZXN0LmFkdmVydGlzZXJfaWQsIHRlc3QuY2FtcGFpZ25faWQsCnRlc3QuY2FtcGFpZ25fdHlwZV9p ZCwgdGVzdC5hZF9ncm91cF9pZCwgdGVzdC50YXJnZXRfaWQsCnRlc3QuZGV2aWNlX3R5cGVfaWQs IHRlc3QuY291bnRyeV9jb2RlLCB0ZXN0LmJsb2NrX2Zvcm1hdF90eXBlX2lkLAp0ZXN0LmNhdGVn b3J5X2dyb3VwX2lkDQogICAgICAgICAgICAgICAtPiAgU29ydCAgKGNvc3Q9Mjc3MTk0OC4wNC4u Mjc5NzMzMS4wNCByb3dzPTEwMTUzMjAwCndpZHRoPTc1KSAoYWN0dWFsIHRpbWU9MTIwOTcuNTI0 Li4xMzM1NC43MzEgcm93cz0xMDE1MzE5NyBsb29wcz0xKQ0KICAgICAgICAgICAgICAgICAgICAg U29ydCBLZXk6IHRlc3QuYWRfaWQsIHRlc3QuYWR2ZXJ0aXNlcl9pZCwKdGVzdC5jYW1wYWlnbl9p ZCwgdGVzdC5jYW1wYWlnbl90eXBlX2lkLCB0ZXN0LmFkX2dyb3VwX2lkLCB0ZXN0LnRhcmdldF9p ZCwKdGVzdC5kZXZpY2VfdHlwZV9pZCwgdGVzdC5jb3VudHJ5X2NvZGUsIHRlc3QuYmxvY2tfZm9y bWF0X3R5cGVfaWQsCnRlc3QuY2F0ZWdvcnlfZ3JvdXBfaWQNCiAgICAgICAgICAgICAgICAgICAg IFNvcnQgTWV0aG9kOiBleHRlcm5hbCBtZXJnZSAgRGlzazogODk0MTg0a0INCiAgICAgICAgICAg ICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiB0ZXN0ICAoY29zdD0wLjAwLi4yMzY5MDguMDAKcm93 cz0xMDE1MzIwMCB3aWR0aD03NSkgKGFjdHVhbCB0aW1lPTAuMDE1Li43NzkuNzIyIHJvd3M9MTAx NTMxOTcgbG9vcHM9MSkNCiBQbGFubmluZyBUaW1lOiAwLjM0NCBtcw0KIEV4ZWN1dGlvbiBUaW1l OiAxNjczMC4zMDQgbXMNCg0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAg ICAgICAgICAgIFFVRVJZIFBMQU4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLQ0KIEFnZ3JlZ2F0ZSAgKGNvc3Q9MjA1MTA2Mi43NC4uMjA1MTA2Mi43NSByb3dz PTEgd2lkdGg9OCkgKGFjdHVhbAp0aW1lPTg0MDQuODgwLi44NDA0Ljg4MiByb3dzPTEgbG9vcHM9 MSkNCiAgIC0+ICBIYXNoQWdncmVnYXRlICAoY29zdD0yMDQ4Nzc4LjI3Li4yMDQ5NzkzLjU5IHJv d3M9MTAxNTMyIHdpZHRoPTY3KQooYWN0dWFsIHRpbWU9ODM5MC45NTIuLjg0MDIuNzc3IHJvd3M9 NTU2MzQgbG9vcHM9MSkNCiAgICAgICAgIEdyb3VwIEtleTogdGVzdC5hZF9ncm91cF9pZCwgdGVz dC5jb3VudHJ5X2NvZGUsCnRlc3QuZGV2aWNlX3R5cGVfaWQsIHRlc3QudGFyZ2V0X2lkLCB0ZXN0 LmJsb2NrX2Zvcm1hdF90eXBlX2lkLAp0ZXN0LmNhdGVnb3J5X2dyb3VwX2lkLCBhcnJheV9hZ2co dGVzdC5nZW9faWQpDQogICAgICAgICBCYXRjaGVzOiAxICBNZW1vcnkgVXNhZ2U6IDE5NDcza0IN CiAgICAgICAgIC0+ICBIYXNoQWdncmVnYXRlICAoY29zdD0xNzUwMzY5LjM4Li4yMDIwODU2Ljk3 IHJvd3M9MTAxNTMyMAp3aWR0aD05OSkgKGFjdHVhbCB0aW1lPTQ0NzguMzk0Li43ODc5LjEwMyBy b3dzPTcwNTgzNiBsb29wcz0xKQ0KICAgICAgICAgICAgICAgR3JvdXAgS2V5OiB0ZXN0LmFkX2lk LCB0ZXN0LmFkdmVydGlzZXJfaWQsIHRlc3QuY2FtcGFpZ25faWQsCnRlc3QuY2FtcGFpZ25fdHlw ZV9pZCwgdGVzdC5hZF9ncm91cF9pZCwgdGVzdC50YXJnZXRfaWQsCnRlc3QuZGV2aWNlX3R5cGVf aWQsIHRlc3QuY291bnRyeV9jb2RlLCB0ZXN0LmJsb2NrX2Zvcm1hdF90eXBlX2lkLAp0ZXN0LmNh dGVnb3J5X2dyb3VwX2lkDQogICAgICAgICAgICAgICBQbGFubmVkIFBhcnRpdGlvbnM6IDI1NiAg QmF0Y2hlczogMjU3ICBNZW1vcnkgVXNhZ2U6IDY1NTNrQiAKRGlzayBVc2FnZTogMTEwMjg1NmtC DQogICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gdGVzdCAgKGNvc3Q9MC4wMC4uMjM2OTA4 LjAwIHJvd3M9MTAxNTMyMDAKd2lkdGg9NzUpIChhY3R1YWwgdGltZT0wLjAyMC4uNzg4LjY5OCBy b3dzPTEwMTUzMTk3IGxvb3BzPTEpDQogUGxhbm5pbmcgVGltZTogMC4zMDEgbXMNCiBFeGVjdXRp b24gVGltZTogODUzOC4yMzYgbXMNCg0KDQpDb3JyZW5jdCBhbnN3ZXJzIHByb3ZpZGVkIHdpdGgg bGFyZ2VyIHdvcmtfbWVtICg1NTYzNCkNCg0KV2hhdCBtYWtlIHNpdHVhdGlvIGV2ZW4gbW9yZSBj dXJpb3VzIHRoYXQgZGlzYWJsZSBoYXNoX2FnZyBkb2Vzbid0IG1ha2UKaXNzdWUgZ29uZToNCnNl dCBlbmFibGVfaGFzaGFnZyB0byAwOw0Kc2V0IHdvcmtfbWVtIHRvICc0TUInOw0KLi4uDQogY291 bnQgDQotLS0tLS0tDQogODM3MDANCg0KIEFnZ3JlZ2F0ZSAgKGNvc3Q9MzMwNTU1My4yNC4uMzMw NTU1My4yNSByb3dzPTEgd2lkdGg9OCkgKGFjdHVhbAp0aW1lPTE4MjI3LjE2NC4uMTgyMjcuMTY3 IHJvd3M9MSBsb29wcz0xKQ0KICAgLT4gIFVuaXF1ZSAgKGNvc3Q9MzI4Mzk3Ny42OS4uMzMwNDI4 NC4wOSByb3dzPTEwMTUzMiB3aWR0aD02NykgKGFjdHVhbAp0aW1lPTE3NTk1LjE4OS4uMTgyMjMu OTM1IHJvd3M9ODM3MDAgbG9vcHM9MSkNCiAgICAgICAgIC0+ICBTb3J0ICAoY29zdD0zMjgzOTc3 LjY5Li4zMjg2NTE1Ljk5IHJvd3M9MTAxNTMyMCB3aWR0aD02NykKKGFjdHVhbCB0aW1lPTE3NTk1 LjE4OC4uMTgwNDIuNDU3IHJvd3M9NzA1ODM2IGxvb3BzPTEpDQogICAgICAgICAgICAgICBTb3J0 IEtleTogdDEuYWRfZ3JvdXBfaWQsIHQxLmNvdW50cnlfY29kZSwgdDEuZGV2aWNlX3R5cGVfaWQs CnQxLnRhcmdldF9pZCwgdDEuYmxvY2tfZm9ybWF0X3R5cGVfaWQsIHQxLmNhdGVnb3J5X2dyb3Vw X2lkLCB0MS5nZW9faWRzDQogICAgICAgICAgICAgICBTb3J0IE1ldGhvZDogZXh0ZXJuYWwgbWVy Z2UgIERpc2s6IDEyODY4MGtCDQogICAgICAgICAgICAgICAtPiAgU3VicXVlcnkgU2NhbiBvbiB0 MSAgKGNvc3Q9Mjc3MTk0OC4wNC4uMzA5OTM4OC43NApyb3dzPTEwMTUzMjAgd2lkdGg9NjcpIChh Y3R1YWwgdGltZT0xMTk2NS4zOTQuLjE1NzUwLjc1OSByb3dzPTcwNTgzNgpsb29wcz0xKQ0KICAg ICAgICAgICAgICAgICAgICAgLT4gIEdyb3VwQWdncmVnYXRlICAoY29zdD0yNzcxOTQ4LjA0Li4z MDg5MjM1LjU0CnJvd3M9MTAxNTMyMCB3aWR0aD05OSkgKGFjdHVhbCB0aW1lPTExOTY1LjM5Mi4u MTU2OTUuMTAyIHJvd3M9NzA1ODM2Cmxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAgICAgICAg ICBHcm91cCBLZXk6IHRlc3QuYWRfaWQsIHRlc3QuYWR2ZXJ0aXNlcl9pZCwKdGVzdC5jYW1wYWln bl9pZCwgdGVzdC5jYW1wYWlnbl90eXBlX2lkLCB0ZXN0LmFkX2dyb3VwX2lkLCB0ZXN0LnRhcmdl dF9pZCwKdGVzdC5kZXZpY2VfdHlwZV9pZCwgdGVzdC5jb3VudHJ5X2NvZGUsIHRlc3QuYmxvY2tf Zm9ybWF0X3R5cGVfaWQsCnRlc3QuY2F0ZWdvcnlfZ3JvdXBfaWQNCiAgICAgICAgICAgICAgICAg ICAgICAgICAgIC0+ICBTb3J0ICAoY29zdD0yNzcxOTQ4LjA0Li4yNzk3MzMxLjA0CnJvd3M9MTAx NTMyMDAgd2lkdGg9NzUpIChhY3R1YWwgdGltZT0xMTk2NS4zNzguLjEzMjgzLjE0MyByb3dzPTEw MTUzMTk3Cmxvb3BzPTEpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBTb3J0IEtl eTogdGVzdC5hZF9pZCwgdGVzdC5hZHZlcnRpc2VyX2lkLAp0ZXN0LmNhbXBhaWduX2lkLCB0ZXN0 LmNhbXBhaWduX3R5cGVfaWQsIHRlc3QuYWRfZ3JvdXBfaWQsIHRlc3QudGFyZ2V0X2lkLAp0ZXN0 LmRldmljZV90eXBlX2lkLCB0ZXN0LmNvdW50cnlfY29kZSwgdGVzdC5ibG9ja19mb3JtYXRfdHlw ZV9pZCwKdGVzdC5jYXRlZ29yeV9ncm91cF9pZA0KICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgU29ydCBNZXRob2Q6IGV4dGVybmFsIG1lcmdlICBEaXNrOgo4OTQxODRrQg0KICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgLT4gIFNlcSBTY2FuIG9uIHRlc3QgIChjb3N0PTAu MDAuLjIzNjkwOC4wMApyb3dzPTEwMTUzMjAwIHdpZHRoPTc1KSAoYWN0dWFsIHRpbWU9MC4wMTQu Ljc3MC4wNDAgcm93cz0xMDE1MzE5NyBsb29wcz0xKQ0KIFBsYW5uaW5nIFRpbWU6IDAuMzE1IG1z DQogRXhlY3V0aW9uIFRpbWU6IDE4NTAzLjMwNyBtcw0KDQoNCi0tTWF4aW0gQm9ndWsKCg== --===============2165645804116504051==--