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 1ogMPx-0007y4-6N for pgsql-bugs@arkaria.postgresql.org; Thu, 06 Oct 2022 08:39:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ogMPw-0004Uu-3L for pgsql-bugs@arkaria.postgresql.org; Thu, 06 Oct 2022 08:39:44 +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 <52194501011@stu.ecnu.edu.cn>) id 1ogLJP-0007ay-H2 for pgsql-bugs@lists.postgresql.org; Thu, 06 Oct 2022 07:28:55 +0000 Received: from smtpbgbr1.qq.com ([54.207.19.206]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from <52194501011@stu.ecnu.edu.cn>) id 1ogLJF-0001Zm-EX for pgsql-bugs@lists.postgresql.org; Thu, 06 Oct 2022 07:28:52 +0000 X-QQ-GoodBg: 2 X-BAN-DOWNLOAD: 1 X-BAN-SHARE: 1 X-QQ-SSF: 0040000000B000F0 X-QQ-FEAT: CR3LFp2JE4m+cA6As1WTJNfJauytDwfk1uI65FIOMQXzRuRzxPF0rp1IbrfuU wHzOpXdWMHxDXb1x7CKksiJCwWHTl78NdXiwi/j6lrhwQ182WBJWefmF/XdAPGwBLwdmnC/ w1QZGhEvUSlqS9poAKik735T4v2uHWH6uNLlxu2g9JZHuDwkg6XS/tlLVxAqEIJ+u5YmAgy 7feOMWw++9tiSTqEOWYeIp7PfLaH77n8Zv0f1UpQAfHUc4iTjkATNIxGeULhw1tV5MPaSa1 siH9vhHI2GfiI9/bH07FV+nCjLK7yKfAk5NfkwcHkY2rc5QIF/xcMpbfcrKSm3POKdRzirr xkijdU+qiIKW3beEZv1qWQMnFFMbRJhua7G4KZVIjKFcKsUYYDgtJX0SaIrhnsZF3dBgomP X-QQ-BUSINESS-ORIGIN: 2 X-Originating-IP: 180.160.245.78 X-QQ-STYLE: X-QQ-mid: logic545t1665041308t9707231 From: "=?utf-8?B?5p2O5Y+v5by6?=" <52194501011@stu.ecnu.edu.cn> To: "=?utf-8?B?UGV0ZXIgR2VvZ2hlZ2Fu?=" Cc: "=?utf-8?B?dGds?=" , "=?utf-8?B?cGdzcWwtYnVncw==?=" Subject: Re:Re: Fwd: BUG #17017: Two versions of the same row of records are returned in one query Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_633E839C_1B3D2930_353908DE" Content-Transfer-Encoding: 8Bit Date: Thu, 6 Oct 2022 15:28:28 +0800 X-Priority: 3 Message-ID: X-QQ-MIME: TCMime 1.0 by Tencent X-Mailer: QQMail 2.x X-QQ-Mailer: QQMail 2.x References: <17017-c37dbbadb77cfde9@postgresql.org> <3229567.1621354699@sss.pgh.pa.us> In-Reply-To: X-QQ-ReplyHash: 921148611 X-QQ-SENDSIZE: 520 Received: from qq.com (unknown [127.0.0.1]) by smtp.qq.com (ESMTP) with SMTP id ; Thu, 06 Oct 2022 15:28:29 +0800 (CST) Feedback-ID: logic:stu.ecnu.edu.cn:qybglogicsvr:qybglogicsvr5 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. ------=_NextPart_633E839C_1B3D2930_353908DE Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SGkgUGV0ZXIsJm5ic3A7DQoNCg0KVGhhbmsgeW91IGZvciB5b3VyIGtpbmQgcmVzcG9uc2Uu Jm5ic3A7IElmIHBvc3NpYmxlLCBJIHdhbnQgdG8gZGlzY3VzcyBtb3JlIGFib3V0IG15IGNv bmZ1c2lvbiBvbiB0aGlzIHByb2JsZW0uJm5ic3A7DQoNCg0KWW91IGhhdmUgbWVudGlvbmVk IHRoYXQgImEgcHJlZGljYXRlIG9uIHRoZSBQSyBpcyBub3Qgc3BlY2lhbCBpbiBQb3N0Z3Jl cyIuIERvZXMgaXQgbWVhbiB0aGF0IFBHIHRha2VzIFBLIGFzIGEgY29tbW9uIGNvbHVtbiBp bnN0ZWFkIG9mIHRoZSBpZGVudGlmaWVyIG9mIHJvd3MgaWYgc2VsZWN0aW5nIHJvd3MgYnkg YSBwcmVkaWNhdGUgb24gdGhlIFBLPyBJZiBpdCBpcyBzbywgaW4gYSByZWxhdGlvbmFsIGRh dGFiYXNlLCBQRyBtYXkgYnJlYWsgdGhlIHVuaXF1ZSBjb25zdHJhaW50cyBvbiBQSy4mbmJz cDsmbmJzcDsNCg0KDQpGb3IgZXhhbXBsZSwgaW4gbXkgbWVudGlvbmVkIGJ1ZyBjYXNlLCB0 aGUgcXVlcnkgb24gUEcgcmV0dXJucyB0d28gcm93cyB3aGljaCBoYXZlIHRoZSBzYW1lIFBL LiBGcm9tIG15IHBvaW50IG9mIHZpZXcsIHN1Y2ggYSBiZWhhdmlvciB2aW9sYXRlcyB0aGUg cHJpbWFyeSBrZXkgdW5pcXVlIGNvbnN0cmFpbnQuJm5ic3A7DQoNCg0KTG9vayBmb3J3YXJk IHRvIHRoZSByZXNwb25zZS4NCg0KDQpUaGFuayB5b3UuDQoNCiZuYnNwOw0KJm5ic3A7DQot LS0tLS0tLS0tLS0tLS0tLS0mbmJzcDtPcmlnaW5hbCZuYnNwOy0tLS0tLS0tLS0tLS0tLS0t LQ0KRnJvbTogIlBldGVyJm5ic3A7R2VvZ2hlZ2FuIjsgDQpEYXRlOiAyMDIx5bm0NeaciDIw 5pelKOaYn+acn+Wbmykg5LiK5Y2IOTo1Ng0KVG86ICI1MjE5NDUwMTAxMUBzdHUuZWNudS5l ZHUuY24iPDUyMTk0NTAxMDExQHN0dS5lY251LmVkdS5jbj47IA0KQ2M6ICJ0Z2wiOyAicGdz cWwtYnVncyI7IA0KU3ViamVjdDogUmU6IEZ3ZDogQlVHICMxNzAxNzogVHdvIHZlcnNpb25z IG9mIHRoZSBzYW1lIHJvdyBvZiByZWNvcmRzIGFyZSByZXR1cm5lZCBpbiBvbmUgcXVlcnkN Cg0KJm5ic3A7DQpPbiBXZWQsIE1heSAxOSwgMjAyMSBhdCAxMjoyNyBBTSDmnY7lj6/lvLog PDUyMTk0NTAxMDExQHN0dS5lY251LmVkdS5jbiZndDsgd3JvdGU6DQomZ3Q7IFRoZXJlIGlz IG5vIG5lZWQgdG8gcmV0dXJuIHRoZSBvbGQgdmVyc2lvbiB3cml0dGVuIGJ5IGNvbW1pdHRl ZCB0cmFuc2FjdGlvbnMuIFRoZSBxdWVyeSByZXN1bHQgZm8gU2Vzc2lvbiBCIGlzIHZlcnkg Y29uZnVzaW5nIQ0KDQpGV0lXIEkgdGhpbmsgdGhhdCBpdCdzIGEgbWF0dGVyIG9mIGhvdyB0 aGUgc3RhbmRhcmQgaXMgaW50ZXJwcmV0ZWQuDQpZb3UgZXhwZWN0IHNvbWV0aGluZyB0aGF0 IEt5bGUgS2luZ3NidXJ5IGNhbGxlZCAiQWR5YSByZXBlYXRhYmxlDQpyZWFkIi4gVGhpcyBp bnRlcnByZXRhdGlvbiBvZiBSUiBhbGxvd3MgYW4gYXBwbGljYXRpb24gd2hpY2ggb25seQ0K YWNjZXNzZXMgcmVjb3JkcyBieSBwcmltYXJ5IGtleSB0byBnZXQgc2VyaWFsaXphYmxlIGV4 ZWN1dGlvbi4NCkVzc2VudGlhbGx5LCB0aGUgcHJpbWFyeSBrZXkgaXMgc3BlY2lhbCBpbiBh IHN5c3RlbSB0aGF0IHVzZXMNCnRyYWRpdGlvbmFsIHR3by1waGFzZSBsb2NraW5nIChvciBz b21ldGhpbmcgY2xvc2VyIHRvIGl0IHRoYW4gdGhlDQpQb3N0Z3JlcyBtb2RlbCkuIEJ1dCBh IHByZWRpY2F0ZSBvbiB0aGUgUEsgaXMgbm90IHNwZWNpYWwgaW4gUG9zdGdyZXMuDQoNCi0t DQpQZXRlciBHZW9naGVnYW4= ------=_NextPart_633E839C_1B3D2930_353908DE Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGRpdiBzdHlsZT0iZm9udC1mYW1pbHk6VmVyZGFuYTtmb250LXNpemU6MTRweDtjb2xvcjoj MDAwOyI+PGRpdj48ZGl2PkhpIFBldGVyLCZuYnNwOzwvZGl2PjxkaXY+PGJyPjwvZGl2Pjxk aXY+VGhhbmsgeW91IGZvciB5b3VyIGtpbmQgcmVzcG9uc2UuJm5ic3A7IElmIHBvc3NpYmxl LCBJIHdhbnQgdG8gZGlzY3VzcyBtb3JlIGFib3V0IG15IGNvbmZ1c2lvbiBvbiB0aGlzIHBy b2JsZW0uJm5ic3A7PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5Zb3UgaGF2ZSBtZW50aW9u ZWQgdGhhdCAiYSBwcmVkaWNhdGUgb24gdGhlIFBLIGlzIG5vdCBzcGVjaWFsIGluIFBvc3Rn cmVzIi4gRG9lcyBpdCBtZWFuIHRoYXQgUEcgdGFrZXMgUEsgYXMgYSBjb21tb24gY29sdW1u IGluc3RlYWQgb2YgdGhlIGlkZW50aWZpZXIgb2Ygcm93cyBpZiBzZWxlY3Rpbmcgcm93cyBi eSBhIHByZWRpY2F0ZSBvbiB0aGUgUEs/IElmIGl0IGlzIHNvLCBpbiBhIHJlbGF0aW9uYWwg ZGF0YWJhc2UsIFBHIG1heSBicmVhayB0aGUgdW5pcXVlIGNvbnN0cmFpbnRzIG9uIFBLLiZu YnNwOyZuYnNwOzwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+Rm9yIGV4YW1wbGUsIGluIG15 IG1lbnRpb25lZCBidWcgY2FzZSwgdGhlIHF1ZXJ5IG9uIFBHIHJldHVybnMgdHdvIHJvd3Mg d2hpY2ggaGF2ZSB0aGUgc2FtZSBQSy4gRnJvbSBteSBwb2ludCBvZiB2aWV3LCBzdWNoIGEg YmVoYXZpb3IgdmlvbGF0ZXMgdGhlIHByaW1hcnkga2V5IHVuaXF1ZSBjb25zdHJhaW50LiZu YnNwOzwvZGl2PjxkaXY+PGJyPjwvZGl2PjxkaXY+TG9vayBmb3J3YXJkIHRvIHRoZSByZXNw b25zZS48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PlRoYW5rIHlvdS48L2Rpdj48L2Rpdj48 ZGl2IHN0eWxlPSJmb250OlZlcmRhbmEgbm9ybWFsIDE0cHg7Y29sb3I6IzAwMDtwYWRkaW5n OjhweCAwcHg7Ij48ZGl2PiZuYnNwOzwvZGl2PjxkaXY+Jm5ic3A7PC9kaXY+PGRpdiBzdHls ZT0iRk9OVC1TSVpFOiAxMnB4O0ZPTlQtRkFNSUxZOiBBcmlhbCBOYXJyb3c7cGFkZGluZzoy cHggMCAycHggMDsiPi0tLS0tLS0tLS0tLS0tLS0tLSZuYnNwO09yaWdpbmFsJm5ic3A7LS0t LS0tLS0tLS0tLS0tLS0tPC9kaXY+PGRpdiBzdHlsZT0iRk9OVC1TSVpFOiAxMnB4O2JhY2tn cm91bmQ6I2VmZWZlZjtwYWRkaW5nOjhweDsiPjxkaXY+PGI+RnJvbTo8L2I+ICJQZXRlciZu YnNwO0dlb2doZWdhbiI8cGdAYm93dC5pZT47IDwvZGl2PjxkaXY+PGI+RGF0ZTo8L2I+IDIw MjHlubQ15pyIMjDml6Uo5pif5pyf5ZubKSDkuIrljYg5OjU2PC9kaXY+PGRpdj48Yj5Ubzo8 L2I+ICI1MjE5NDUwMTAxMUBzdHUuZWNudS5lZHUuY24iPDUyMTk0NTAxMDExQHN0dS5lY251 LmVkdS5jbj47IDwvZGl2PjxkaXY+PGIgPkNjOjwvYj4gInRnbCI8dGdsQHNzcy5wZ2gucGEu dXM+OyAicGdzcWwtYnVncyI8cGdzcWwtYnVnc0BsaXN0cy5wb3N0Z3Jlc3FsLm9yZz47IDwv ZGl2PjxkaXY+PGI+U3ViamVjdDo8L2I+IFJlOiBGd2Q6IEJVRyAjMTcwMTc6IFR3byB2ZXJz aW9ucyBvZiB0aGUgc2FtZSByb3cgb2YgcmVjb3JkcyBhcmUgcmV0dXJuZWQgaW4gb25lIHF1 ZXJ5PC9kaXY+PC9kaXY+PGRpdj4mbmJzcDs8L2Rpdj5PbiBXZWQsIE1heSAxOSwgMjAyMSBh dCAxMjoyNyBBTSDmnY7lj6/lvLogJmx0OzxhIGhyZWY9Im1haWx0bzo1MjE5NDUwMTAxMUBz dHUuZWNudS5lZHUuY24iIHRhcmdldD0iX2JsYW5rIj41MjE5NDUwMTAxMUA8d2JyPnN0dS5l Y251LmVkdTx3YnI+LmNuPC9hPiZndDsgd3JvdGU6PGJyPiZndDsgVGhlcmUgaXMgbm8gbmVl ZCB0byByZXR1cm4gdGhlIG9sZCB2ZXJzaW9uIHdyaXR0ZW4gYnkgY29tbWl0dGVkIHRyYW5z YWN0aW9ucy4gVGhlIHF1ZXJ5IHJlc3VsdCBmbyBTZXNzaW9uIEIgaXMgdmVyeSBjb25mdXNp bmchPGJyPjxicj5GV0lXIEkgdGhpbmsgdGhhdCBpdCdzIGEgbWF0dGVyIG9mIGhvdyB0aGUg c3RhbmRhcmQgaXMgaW50ZXJwcmV0ZWQuPGJyPllvdSBleHBlY3Qgc29tZXRoaW5nIHRoYXQg S3lsZSBLaW5nc2J1cnkgY2FsbGVkICJBZHlhIHJlcGVhdGFibGU8YnI+cmVhZCIuIFRoaXMg aW50ZXJwcmV0YXRpb24gb2YgUlIgYWxsb3dzIGFuIGFwcGxpY2F0aW9uIHdoaWNoIG9ubHk8 YnI+YWNjZXNzZXMgcmVjb3JkcyBieSBwcmltYXJ5IGtleSB0byBnZXQgc2VyaWFsaXphYmxl IGV4ZWN1dGlvbi48YnI+RXNzZW50aWFsbHksIHRoZSBwcmltYXJ5IGtleSBpcyBzcGVjaWFs IGluIGEgc3lzdGVtIHRoYXQgdXNlczxicj50cmFkaXRpb25hbCB0d28tcGhhc2UgbG9ja2lu ZyAob3Igc29tZXRoaW5nIGNsb3NlciB0byBpdCB0aGFuIHRoZTxicj5Qb3N0Z3JlcyBtb2Rl bCkuIEJ1dCBhIHByZWRpY2F0ZSBvbiB0aGUgUEsgaXMgbm90IHNwZWNpYWwgaW4gUG9zdGdy ZXMuPGJyPjxicj4tLTxicj5QZXRlciBHZW9naGVnYW48YnI+ICA8IS0tPCFbZW5kaWZdLS0+ PHN0eWxlPjwvc3R5bGU+PC9kaXY+PC9kaXY+ ------=_NextPart_633E839C_1B3D2930_353908DE--