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 1mISK7-0003mQ-3V for pgsql-bugs@arkaria.postgresql.org; Tue, 24 Aug 2021 09:02:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mISK5-0002my-68 for pgsql-bugs@arkaria.postgresql.org; Tue, 24 Aug 2021 09:02:21 +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 1mIS5Q-0007Lk-Ht for pgsql-bugs@lists.postgresql.org; Tue, 24 Aug 2021 08:47:12 +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 1mIS5J-0005Cu-Df for pgsql-bugs@lists.postgresql.org; Tue, 24 Aug 2021 08:47: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=raGKe4AfHhTuOn0EkrMsicZYquJU/mfKs9iUKb+u7HA=; b=PQUAktQnP6p3pnA5HS5w2+UPE2 bGHY3yi0JiYoYIbWlvNZUH//1p7Rp1/EAlENxV9eiBoQkj2D5wn/JcbgaH//VvGakjWL3Vt9YFZKR YVnDLkwZxj8IWXbKzo39EpG7atLZ8UEdp8YQd6aAuL52u2rFKExUQGus73fXos0bgT2uIDpn0xsYx J7ic0FAgLyD8XFEJmxacNwfoxYBje+qF7A2QXzUqmTL+4HET6zeEMxHt0xOO9O/DjmSx5hYQ1rRAy 7tGYeE1uXbCJL7bu3Qu0zxGZUXMhq/bljxnlSFiITTSRKYjLoHqs3qATw64IGF0TTIe9PzWII6XL/ 2qDearmQ==; 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 1mIS5H-0004ZQ-SZ for pgsql-bugs@lists.postgresql.org; Tue, 24 Aug 2021 08:47: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 1mIS5G-0002CA-PQ for pgsql-bugs@lists.postgresql.org; Tue, 24 Aug 2021 08:47:02 +0000 Content-Type: multipart/mixed; boundary="===============0257398667853481532==" MIME-Version: 1.0 Subject: BUG #17158: Distinct ROW fails with Postgres 14 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: sait.nisanci@microsoft.com Reply-To: sait.nisanci@microsoft.com, pgsql-bugs@lists.postgresql.org Date: Tue, 24 Aug 2021 08:46:46 +0000 Message-ID: <17158-8a2ba823982537a4@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 --===============0257398667853481532== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzE1OApMb2dnZWQgYnk6ICAgICAgICAgIHNhaXQgdGFsaGEgbmlzYW5j aQpFbWFpbCBhZGRyZXNzOiAgICAgIHNhaXQubmlzYW5jaUBtaWNyb3NvZnQuY29tClBvc3RncmVT UUwgdmVyc2lvbjogMTRiZXRhMwpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMC4wNApEZXNj cmlwdGlvbjogICAgICAgIAoKSGksDQoNCmBgYA0KQ3JlYXRlIG9yIHJlcGxhY2UgZnVuY3Rpb24g dGVzdF9qc29uYigpIHJldHVybnMganNvbmIgYXMNCiQkDQpiZWdpbg0KCXJldHVybiAneyJ0ZXN0 X2pzb24iOiAidGVzdCJ9JzsNCmVuZDsNCiQkIGxhbmd1YWdlIHBscGdzcWw7DQoNCkNSRUFURSBU QUJMRSBsb2NhbA0KKA0KCWRpc3Rfa2V5IGJpZ2ludCBQUklNQVJZIEtFWSwNCgljb2wxIGludFtd LCBjb2wyIGludFtdW10sIGNvbDMgaW50IFtdW11bXSwNCgljb2w0IHZhcmNoYXJbXSwgY29sNSB2 YXJjaGFyW11bXSwgY29sNiB2YXJjaGFyIFtdW11bXSwNCgljb2w3MCBiaXQsIGNvbDcgYml0W10s IGNvbDggYml0W11bXSwgY29sOSBiaXQgW11bXVtdLA0KCWNvbDEwIGJpdCB2YXJ5aW5nKDEwKSwN Cgljb2wxMSBiaXQgdmFyeWluZygxMClbXSwgY29sMTIgYml0IHZhcnlpbmcoMTApW11bXSwgY29s MTMgYml0CnZhcnlpbmcoMTApW11bXVtdLA0KCWNvbDE0IGJ5dGVhLCBjb2wxNSBieXRlYVtdLCBj b2wxNiBieXRlYVtdW10sIGNvbDE3IGJ5dGVhW11bXVtdLA0KCWNvbDE4IGJvb2xlYW4sIGNvbDE5 IGJvb2xlYW5bXSwgY29sMjAgYm9vbGVhbltdW10sIGNvbDIxIGJvb2xlYW5bXVtdW10sDQoJY29s MjIgaW5ldCwgY29sMjMgaW5ldFtdLCBjb2wyNCBpbmV0W11bXSwgY29sMjUgaW5ldFtdW11bXSwN Cgljb2wyNiBtYWNhZGRyLCBjb2wyNyBtYWNhZGRyW10sIGNvbDI4IG1hY2FkZHJbXVtdLCBjb2wy OSBtYWNhZGRyW11bXVtdLA0KCWNvbDMwIG51bWVyaWMsIGNvbDMyIG51bWVyaWNbXSwgY29sMzMg bnVtZXJpY1tdW10sIGNvbDM0IG51bWVyaWNbXVtdW10sDQoJY29sMzUganNvbmIsIGNvbDM2IGpz b25iW10sIGNvbDM3IGpzb25iW11bXSwgY29sMzgganNvbmJbXVtdW10NCik7DQoNCklOU0VSVCBJ TlRPIGxvY2FsIChkaXN0X2tleSxjb2wxLCBjb2wyLCBjb2wzLCBjb2w0LCBjb2w1LCBjb2w2LCBj b2w3MCwgY29sNywKY29sOCwgY29sOSwgY29sMTAsIGNvbDExLCBjb2wxMiwgY29sMTMsIGNvbDE0 LCBjb2wxNSwgY29sMTYsIGNvbDE3LCBjb2wxOCwKY29sMTksIGNvbDIwLCBjb2wyMSwgY29sMjIs IGNvbDIzLCBjb2wyNCwgY29sMjUsIGNvbDI2LCBjb2wyNywgY29sMjgsIGNvbDI5LApjb2wzMCwg Y29sMzIsIGNvbDMzLCBjb2wzNCwgY29sMzUsIGNvbDM2LCBjb2wzNywgY29sMzgpDQpWQUxVRVMg KDEsQVJSQVlbMV0sIEFSUkFZW0FSUkFZWzAsMCwwXV0sIEFSUkFZW0FSUkFZW0FSUkFZWzAsMCww XV1dLApBUlJBWVsnMSddLCBBUlJBWVtBUlJBWVsnMCcsJzAnLCcwJ11dLCBBUlJBWVtBUlJBWVtB UlJBWVsnMCcsJzAnLCcwJ11dXSwKJzEnLCBBUlJBWVtiJzEnXSwgQVJSQVlbQVJSQVlbYicwJyxi JzAnLGInMCddXSwKQVJSQVlbQVJSQVlbQVJSQVlbYicwJyxiJzAnLGInMCddXV0sICcxMTEwMScs QVJSQVlbYicxJ10sCkFSUkFZW0FSUkFZW2InMDEnLGInMDEnLGInMDEnXV0sIEFSUkFZW0FSUkFZ W0FSUkFZW2InMDExJyxiJzExMCcsYicwMDAwJ11dXSwKJ1x4YjRhOGUwNGMwYicsIEFSUkFZWydc eGI0YThlMDRjMGInOjpCWVRFQV0sCkFSUkFZW0FSUkFZWydceGI0YThlMDRjMGInOjpCWVRFQSwg J1x4YjRhOGUwNGMwYic6OkJZVEVBLAonXHhiNGE4ZTA0YzBiJzo6QllURUFdXSwKQVJSQVlbQVJS QVlbQVJSQVlbJ1x4YjRhOGUwNGMwYic6OkJZVEVBLCdceDE4YTIzMmE2NzgnOjpCWVRFQSwnXHgz OGIyNjk3NjMyJzo6QllURUFdXV0sCicxJywgQVJSQVlbVFJVRV0sIEFSUkFZW0FSUkFZWzE6OmJv b2xlYW4sVFJVRSxGQUxTRV1dLApBUlJBWVtBUlJBWVtBUlJBWVsxOjpib29sZWFuLFRSVUUsRkFM U0VdXV0sIElORVQgJzE5Mi4xNjguMS8yNCcsIEFSUkFZW0lORVQKJzE5Mi4xNjguMS4xJ10sIEFS UkFZW0FSUkFZW0lORVQgJzAuMC4wLjAnLCAnMC4wLjAuMC8zMicsICc6OmZmZmY6ZmZmMDoxJywK JzE5Mi4xNjguMS8yNCddXSwgQVJSQVlbQVJSQVlbQVJSQVlbSU5FVCAnMC4wLjAuMCcsICcwLjAu MC4wLzMyJywKJzo6ZmZmZjpmZmYwOjEnLCAnMTkyLjE2OC4xLzI0J11dXSxNQUNBRERSICcwODow MDoyYjowMTowMjowMycsCkFSUkFZW01BQ0FERFIgJzA4OjAwOjJiOjAxOjAyOjAzJ10sIEFSUkFZ W0FSUkFZW01BQ0FERFIgJzA4MDAyYi0wMTAyMDMnLApNQUNBRERSICcwODAwMmItMDEwMjAzJywg JzA4MDAyYjAxMDIwMyddXSwgQVJSQVlbQVJSQVlbQVJSQVlbTUFDQUREUgonMDgwMDJiLTAxMDIw MycsIE1BQ0FERFIgJzA4MDAyYi0wMTAyMDMnLCAnMDgwMDJiMDEwMjAzJ11dXSwgNjkwLApBUlJB WVsxLjFdLCBBUlJBWVtBUlJBWVswLDAuMTExLDAuMTVdXSwgQVJSQVlbQVJSQVlbQVJSQVlbMCww LDBdXV0sCnRlc3RfanNvbmIoKSwgQVJSQVlbdGVzdF9qc29uYigpXSwKQVJSQVlbQVJSQVlbdGVz dF9qc29uYigpLHRlc3RfanNvbmIoKSx0ZXN0X2pzb25iKCksdGVzdF9qc29uYigpXV0sCkFSUkFZ W0FSUkFZW0FSUkFZW3Rlc3RfanNvbmIoKSx0ZXN0X2pzb25iKCksdGVzdF9qc29uYigpLHRlc3Rf anNvbmIoKV1dXSksDQogICAgICAgKDIsQVJSQVlbMSwyLDNdLCBBUlJBWVtBUlJBWVsxLDIsM10s IEFSUkFZWzUsNiw3XV0sCkFSUkFZW0FSUkFZW0FSUkFZWzEsMiwzXV0sIEFSUkFZW0FSUkFZWzUs Niw3XV0sIEFSUkFZW0FSUkFZWzEsMiwzXV0sCkFSUkFZW0FSUkFZWzUsNiw3XV1dLCBBUlJBWVsn MScsJzInLCczJ10sIEFSUkFZW0FSUkFZWycxJywnMicsJzMnXSwKQVJSQVlbJzUnLCc2JywnNydd XSwgQVJSQVlbQVJSQVlbQVJSQVlbJzEnLCcyJywnMyddXSwKQVJSQVlbQVJSQVlbJzUnLCc2Jywn NyddXSwgQVJSQVlbQVJSQVlbJzEnLCcyJywnMyddXSwKQVJSQVlbQVJSQVlbJzUnLCc2JywnNydd XV0sICcwJywgQVJSQVlbYicxJyxiJzAnLGInMCddLApBUlJBWVtBUlJBWVtiJzEnLGInMScsYicw J10sIEFSUkFZW2InMCcsYicwJyxiJzEnXV0sCkFSUkFZW0FSUkFZW0FSUkFZW2InMScsYicxJyxi JzEnXV0sIEFSUkFZW0FSUkFZW2InMScsJzAnLCcwJ11dLApBUlJBWVtBUlJBWVtiJzEnLCcxJywn MSddXSwgQVJSQVlbQVJSQVlbYicwJywnMCcsJzAnXV1dLCAnMDAwMTAnLApBUlJBWVtiJzExJyxi JzEwJyxiJzAxJ10sIEFSUkFZW0FSUkFZW2InMTEnLGInMDEwJyxiJzEwMSddLApBUlJBWVtiJzEw MScsYicwMTExMScsYicxMDAwMDAxJ11dLApBUlJBWVtBUlJBWVtBUlJBWVtiJzEwMDAwJyxiJzEx MTExMScsYicxMTAxMDEwMTAxJ11dLApBUlJBWVtBUlJBWVtiJzExMDEwMTAnLCcwJywnMSddXSwg QVJSQVlbQVJSQVlbYicxJywnMScsJzExMTExMTExJ11dLApBUlJBWVtBUlJBWVtiJzAwMDAwMDAn LCcwJywnMCddXV0sICdceGI0YThlMDRjMGInLApBUlJBWVsnXHhiNGE4ZTA0YzBiJzo6QllURUEs J1x4MThhMjMyYTY3OCc6OkJZVEVBLCdceDM4YjI2OTc2MzInOjpCWVRFQV0sCkFSUkFZW0FSUkFZ WydceGI0YThlMDRjMGInOjpCWVRFQSwnXHgxOGEyMzJhNjc4Jzo6QllURUEsJ1x4MzhiMjY5NzYz Mic6OkJZVEVBXSwKQVJSQVlbJ1x4YjRhOGUwNGMwYic6OkJZVEVBLCdceDE4YTIzMmE2NzgnOjpC WVRFQSwnXHgzOGIyNjk3NjMyJzo6QllURUFdXSwKQVJSQVlbQVJSQVlbQVJSQVlbJ1x4YjRhOGUw NGMwYic6OkJZVEVBLCdceDE4YTIzMmE2NzgnOjpCWVRFQSwnXHgzOGIyNjk3NjMyJzo6QllURUFd XSwKQVJSQVlbQVJSQVlbJ1x4YjRhOGUwNGMwYic6OkJZVEVBLCdceDE4YTIzMmE2NzgnOjpCWVRF QSwnXHgzOGIyNjk3NjMyJzo6QllURUFdXSwKQVJSQVlbQVJSQVlbJ1x4YjRhOGUwNGMwYic6OkJZ VEVBLCdceDE4YTIzMmE2NzgnOjpCWVRFQSwnXHgzOGIyNjk3NjMyJzo6QllURUFdXSwKQVJSQVlb QVJSQVlbJ1x4YjRhOGUwNGMwYic6OkJZVEVBLCdceDE4YTIzMmE2NzgnOjpCWVRFQSwnXHgzOGIy Njk3NjMyJzo6QllURUFdXV0sCid0cnVlJywgQVJSQVlbMTo6Ym9vbGVhbixUUlVFLEZBTFNFXSwg QVJSQVlbQVJSQVlbMTo6Ym9vbGVhbixUUlVFLEZBTFNFXSwKQVJSQVlbMTo6Ym9vbGVhbixUUlVF LEZBTFNFXV0sIEFSUkFZW0FSUkFZW0FSUkFZWzE6OmJvb2xlYW4sVFJVRSxGQUxTRV1dLApBUlJB WVtBUlJBWVsxOjpib29sZWFuLFRSVUUsRkFMU0VdXSwgQVJSQVlbQVJSQVlbMTo6Ym9vbGVhbixU UlVFLEZBTFNFXV0sCkFSUkFZW0FSUkFZWzE6OmJvb2xlYW4sVFJVRSxGQUxTRV1dXSwnMC4wLjAu MC8zMicsIEFSUkFZW0lORVQgJzAuMC4wLjAnLAonMC4wLjAuMC8zMicsICc6OmZmZmY6ZmZmMDox JywgJzE5Mi4xNjguMS8yNCddLCBBUlJBWVtBUlJBWVtJTkVUICcwLjAuMC4wJywKJzAuMC4wLjAv MzInLCAnOjpmZmZmOmZmZjA6MScsICcxOTIuMTY4LjEvMjQnXV0sIEFSUkFZW0FSUkFZW0FSUkFZ W0lORVQKJzAuMC4wLjAnLCAnMC4wLjAuMC8zMicsICc6OmZmZmY6ZmZmMDoxJywgJzE5Mi4xNjgu MS8yNCddXSwgQVJSQVlbQVJSQVlbSU5FVAonMC4wLjAuMCcsICcwLjAuMC4wLzMyJywgJzo6ZmZm ZjpmZmYwOjEnLCAnMTkyLjE2OC4xLzI0J11dLCBBUlJBWVtBUlJBWVtJTkVUCicwLjAuMC4wJywg JzAuMC4wLjAvMzInLCAnOjpmZmZmOmZmZjA6MScsICcxOTIuMTY4LjEvMjQnXV0sIEFSUkFZW0FS UkFZW0lORVQKJzAuMC4wLjAnLCAnMC4wLjAuMC8zMicsICc6OmZmZmY6ZmZmMDoxJywgJzE5Mi4x NjguMS8yNCddXV0sCicwODAwLjJiMDEuMDIwMycsIEFSUkFZW01BQ0FERFIgJzA4MDAyYi0wMTAy MDMnLCBNQUNBRERSICcwODAwMmItMDEwMjAzJywKJzA4MDAyYjAxMDIwMyddLCBBUlJBWVtBUlJB WVtNQUNBRERSICcwODAwMmItMDEwMjAzJywgTUFDQUREUgonMDgwMDJiLTAxMDIwMycsICcwODAw MmIwMTAyMDMnXV0sIEFSUkFZW0FSUkFZW0FSUkFZW01BQ0FERFIKJzA4MDAyYi0wMTAyMDMnLCBN QUNBRERSICcwODAwMmItMDEwMjAzJywgJzA4MDAyYjAxMDIwMyddXSwKQVJSQVlbQVJSQVlbTUFD QUREUiAnMDgwMDJiLTAxMDIwMycsIE1BQ0FERFIgJzA4MDAyYi0wMTAyMDMnLAonMDgwMDJiMDEw MjAzJ11dLCBBUlJBWVtBUlJBWVtNQUNBRERSICcwODAwMmItMDEwMjAzJywgTUFDQUREUgonMDgw MDJiLTAxMDIwMycsICcwODAwMmIwMTAyMDMnXV0sIEFSUkFZW0FSUkFZW01BQ0FERFIgJzA4MDAy Yi0wMTAyMDMnLApNQUNBRERSICcwODAwMmItMDEwMjAzJywgJzA4MDAyYjAxMDIwMyddXV0sIDAu OTksIEFSUkFZWzEuMSwyLjIyLDMuMzNdLApBUlJBWVtBUlJBWVsxLjU1LDIuNjYsMy44OF0sIEFS UkFZWzExLjUsMTAxMDEuNiw3MTExLjFdXSwKQVJSQVlbQVJSQVlbQVJSQVlbMSwyLDNdXSwgQVJS QVlbQVJSQVlbNSw2LDddXSwgQVJSQVlbQVJSQVlbMS4xLDIuMSwzXV0sCkFSUkFZW0FSUkFZWzUu MCw2LjAsNy4wXV1dLHRlc3RfanNvbmIoKSwKQVJSQVlbdGVzdF9qc29uYigpLHRlc3RfanNvbmIo KSx0ZXN0X2pzb25iKCksdGVzdF9qc29uYigpXSwKQVJSQVlbQVJSQVlbdGVzdF9qc29uYigpLHRl c3RfanNvbmIoKSx0ZXN0X2pzb25iKCksdGVzdF9qc29uYigpXSwKQVJSQVlbdGVzdF9qc29uYigp LHRlc3RfanNvbmIoKSx0ZXN0X2pzb25iKCksdGVzdF9qc29uYigpXV0sCkFSUkFZW0FSUkFZW0FS UkFZW3Rlc3RfanNvbmIoKSx0ZXN0X2pzb25iKCksdGVzdF9qc29uYigpLHRlc3RfanNvbmIoKV1d LApBUlJBWVtBUlJBWVt0ZXN0X2pzb25iKCksdGVzdF9qc29uYigpLHRlc3RfanNvbmIoKSx0ZXN0 X2pzb25iKCldXSwKQVJSQVlbQVJSQVlbdGVzdF9qc29uYigpLHRlc3RfanNvbmIoKSx0ZXN0X2pz b25iKCksdGVzdF9qc29uYigpXV0sCkFSUkFZW0FSUkFZW3Rlc3RfanNvbmIoKSx0ZXN0X2pzb25i KCksdGVzdF9qc29uYigpLHRlc3RfanNvbmIoKV1dXSk7DQoNCi0tIFRoaXMgd29ya3MgZmluZSBi ZWZvcmUgcGcxNC4NClNFTEVDVCBESVNUSU5DVCBST1coY29sMSwgY29sMiwgY29sMywgY29sNCwg Y29sNSwgY29sNiwgY29sNzAsIGNvbDcsIGNvbDgsCmNvbDksIGNvbDEwLA0KY29sMTEsIGNvbDEy LCBjb2wxMywgY29sMTQsIGNvbDE1LCBjb2wxNiwgY29sMTcsIGNvbDE4LCBjb2wxOSwgY29sMjAs IGNvbDIxLApjb2wyMiwgY29sMjMsIGNvbDI0LCBjb2wyNSwNCmNvbDI2LCBjb2wyNywgY29sMjgs IGNvbDI5LCBjb2wzMiwgY29sMzMsIGNvbDM0LCBjb2wzNSwgY29sMzYsIGNvbDM3LCBjb2wzOCkK QVMgInJvdyIgRlJPTSBsb2NhbCBXSEVSRSB0cnVlOw0KRVJST1I6ICBjb3VsZCBub3QgaWRlbnRp ZnkgYSBoYXNoIGZ1bmN0aW9uIGZvciB0eXBlIGJpdA0KYGBgDQoNClRoZSBgU0VMRUNUIERJU1RJ TkNUIFJPV2Agd29ya3MgZmluZSBwcmlvciB0byBQb3N0Z3JlcyAxNCwgc28gaXQgc2VlbXMgbGlr ZQp0aGVyZSBtaWdodCBiZSBzb21lIHByb2JsZW0gd2l0aCBQb3N0Z3JlczE0LiBJcyB0aGlzIGV4 cGVjdGVkPw0KDQpCZXN0LA0KVGFsaGEuCgo= --===============0257398667853481532==--