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 1ljGcr-0008HH-RZ for pgsql-bugs@arkaria.postgresql.org; Wed, 19 May 2021 07:28:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ljGcq-0004wa-Qm for pgsql-bugs@arkaria.postgresql.org; Wed, 19 May 2021 07:28:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) 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 1ljENf-0005KM-KC for pgsql-bugs@lists.postgresql.org; Wed, 19 May 2021 05:04:27 +0000 Received: from smtpbgau1.qq.com ([54.206.16.166]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from <52194501011@stu.ecnu.edu.cn>) id 1ljENZ-0003ZL-5x for pgsql-bugs@lists.postgresql.org; Wed, 19 May 2021 05:04:25 +0000 X-QQ-GoodBg: 2 X-QQ-SSF: 00400000000000F0 X-QQ-FEAT: Uv7+hkXTRUOmeRU7w+zGXjT7HsvLCZ0eJIGiep3l2xIVgWkkDGp6YTh3Zz5cL rlXdpiyhEhjaf8HjcXFMoSXB+4nFtEvSJY6R3SUHkMLjLWd5nP7IIOnAu6Dx1QsBzGibymw mvVksZ/1s5mIqujXHqVnwgQ25cXrkq0geeEj06G3OIbqJwmHh1/ZZ3/v4JsaHHaNlQKoh5O 7hf1FiU061Fus2vNipn98QboMMWdnj6N8FX4/g82mcWktG3qjQlQNweEVURApAAkbiPgr8K J9Ooj4d0RMUDi4RghcIKhjxGwaCPBbeKXGo+hwHjgTQC0MKyAp5PHF74eDsu+9EtR2dAJuz OodjR66SfMVsoxNtwMVhyvBeVx2Tr8t+jfpHJk7 X-QQ-BUSINESS-ORIGIN: 2 X-Originating-IP: 219.228.116.38 X-QQ-STYLE: X-QQ-mid: logic620t1621400647t3482358 From: "=?utf-8?B?5p2O5Y+v5by6?=" <52194501011@stu.ecnu.edu.cn> To: "=?utf-8?B?dGds?=" Cc: "=?utf-8?B?cGdzcWwtYnVncw==?=" Subject: 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_60A49C47_13C20298_0C16662E" Content-Transfer-Encoding: 8Bit Date: Wed, 19 May 2021 13:04:07 +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: 3950767940 X-QQ-SENDSIZE: 520 Received: from qq.com (unknown [127.0.0.1]) by smtp.qq.com (ESMTP) with SMTP id ; Wed, 19 May 2021 13:04:08 +0800 (CST) Feedback-ID: logic:stu.ecnu.edu.cn:qybgforeign:qybgforeign1 X-QQ-Bgrelay: 1 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_60A49C47_13C20298_0C16662E Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 SGkgVG9tLA0KSSB0aGluayB0aGUgcmVwZWF0YWJsZSByZWFkIHRyYW5zYWN0aW9uIHNob3Vs ZCBnaXZlIHByaW9yaXR5IHRvIHNlZSB0aGUgbmV3IHZlcnNpb24gd3JpdHRlbiZuYnNwO2J5 IGl0c2VsZiwgZS5nLiwgdGhlIGluc2VydGlvbiBvZiB0aGUgYWJvdmUgZXhhbXBsZS4gVGhl cmUgaXMgbm8gbmVlZCB0byByZXR1cm4gdGhlIG9sZCB2ZXJzaW9uIHdyaXR0ZW4gYnkgY29t bWl0dGVkIHRyYW5zYWN0aW9ucy4gVGhlIHF1ZXJ5IHJlc3VsdCBmbyBTZXNzaW9uIEIgaXMg dmVyeSBjb25mdXNpbmchDQoNCg0KLS0tLS0tLS0tLS0tLS0tLS0tJm5ic3A7T3JpZ2luYWwm bmJzcDstLS0tLS0tLS0tLS0tLS0tLS0NCkZyb206ICZuYnNwOyLliJjmspvmupAiPGxweS5o ZW51QGdtYWlsLmNvbSZndDs7DQpEYXRlOiAmbmJzcDtXZWQsIE1heSAxOSwgMjAyMSAwOTow NSBBTQ0KVG86ICZuYnNwOyI1MjE5NDUwMTAxMSI8NTIxOTQ1MDEwMTFAc3R1LmVjbnUuZWR1 LmNuJmd0OzsgDQoNClN1YmplY3Q6ICZuYnNwO0Z3ZDogQlVHICMxNzAxNzogVHdvIHZlcnNp b25zIG9mIHRoZSBzYW1lIHJvdyBvZiByZWNvcmRzIGFyZSByZXR1cm5lZCBpbiBvbmUgcXVl cnkNCg0KJm5ic3A7DQoNCg0KDQotLS0tLS0tLS0tIEZvcndhcmRlZCBtZXNzYWdlIC0tLS0t LS0tLQ0K5Y+R5Lu25Lq677yaIFRvbSBMYW5lIDx0Z2xAc3NzLnBnaC5wYS51cyZndDsNCkRh dGU6IDIwMjHlubQ15pyIMTnml6XlkajkuIkgMDA6MTgNClN1YmplY3Q6IFJlOiBCVUcgIzE3 MDE3OiBUd28gdmVyc2lvbnMgb2YgdGhlIHNhbWUgcm93IG9mIHJlY29yZHMgYXJlIHJldHVy bmVkIGluIG9uZSBxdWVyeQ0KVG86ICA8bHB5LmhlbnVAZ21haWwuY29tJmd0Ow0KQ2M6ICA8 cGdzcWwtYnVnc0BsaXN0cy5wb3N0Z3Jlc3FsLm9yZyZndDsNCg0KDQoNClBHIEJ1ZyByZXBv cnRpbmcgZm9ybSA8bm9yZXBseUBwb3N0Z3Jlc3FsLm9yZyZndDsgd3JpdGVzOg0KICZndDsg U2NoZW1hIGFuZCBJbml0aWFsIGRhdGE6IA0KICZndDsgQ3JlYXRlIFRhYmxlIHQoYSBpbnQg cHJpbWFyeSBrZXksIGIgaW50KTsNCiAmZ3Q7IEluc2VydCBpbnRvIHQgdmFsdWVzKDEsMik7 DQogJmd0OyBJbnNlcnQgaW50byB0IHZhbHVlcygyLDMpOw0KIA0KICZndDsgW1RpbWUwLCBT ZXNzb25BXQ0KICZndDsmZ3Q7IEJlZ2luOw0KICZndDsmZ3Q7IHNldCB0cmFuc2FjdGlvbiBp c29sYXRpb24gbGV2ZWwgcmVwZWF0YWJsZSByZWFkOw0KICZndDsmZ3Q7IFNlbGVjdCAqIGZy b20gdCB3aGVyZSBhPTE7DQogDQogJmd0OyBbVGltZTEsIFNlc3NvbkJdDQogJmd0OyZndDsg QmVnaW47DQogJmd0OyZndDsgc2V0IHRyYW5zYWN0aW9uIGlzb2xhdGlvbiBsZXZlbCByZWFk IGNvbW1pdHRlZDsNCiAmZ3Q7Jmd0OyBEZWxldGUgZnJvbSB0IHdoZXJlIGE9MjsNCiAmZ3Q7 Jmd0OyBDb21taXQ7DQogDQogJmd0OyBbVGltZTIsIFNlc3NvbkFdDQogJmd0OyZndDsgSW5z ZXJ0IGludG8gdCB2YWx1ZXMoMiw0KTsNCiAmZ3Q7Jmd0OyBTZWxlY3QgKiBmcm9tIHQgd2hl cmUgYT0yOw0KIA0KICZndDsgSGVyZSwgd2UgZXhwZWN0IFBvc3RncmVTUUwgU2VydmVyIHRv IHJldHVybiBhIHJvdzoNCiAmZ3Q7IDIgMw0KIA0KICZndDsgSG93ZXZlciwgaXQgcmV0dXJu cyB0d28gcm93czoNCiAmZ3Q7IDIgNA0KICZndDsgMiAzDQogDQogSW4gcmVwZWF0YWJsZSBy ZWFkIG1vZGUsIHRoaXMgZG9lc24ndCBzdXJwcmlzZSBtZS4mbmJzcDsgU2Vzc2lvbiBBDQog c3VyZWx5IG11c3QgcmV0dXJuIHRoZSAoMiwzKSByb3csIHNpbmNlIGl0IGlzbid0IHN1cHBv c2VkIHRvDQogInNlZSIgdGhlIHJlc3VsdHMgb2YgU2Vzc2lvbiBCJ3MgY29tbWl0IHlldC4m bmJzcDsgQW5kIGl0IHdvdWxkIGJlDQogbWlnaHR5IHN1cnByaXNpbmcgZm9yIGl0IG5vdCB0 byBzZWUgaXRzIG93biBpbnNlcnRpb24sIHNvIHlvdQ0KIGdldCAoMiw0KSBhcyB3ZWxsLg0K IA0KIEluIHNlcmlhbGl6YWJsZSBtb2RlLCBJJ2QgZXhwZWN0IHRoaXMgc2l0dWF0aW9uIHRv IHRocm93IGENCiBzZXJpYWxpemF0aW9uIGVycm9yLCBhbmQgaXQgZG9lcyAoYnV0IHlvdSBt dXN0IHJ1biBCT1RIDQogdHJhbnNhY3Rpb25zIGluIHNlcmlhbGl6YWJsZSBtb2RlOyB0aGVy ZSBhcmUgbm90IGd1YXJhbnRlZXMNCiB3aXRoIGEgbWl4IG9mIHNlcmlhbGl6YWJsZSBhbmQg bm9uLXNlcmlhbGl6YWJsZSB0cmFuc2FjdGlvbnMpLg0KIA0KIFNvIEkgdGhpbmsgdGhlIGFu c3dlciBpcyAiaWYgeW91IGNhcmUgYWJvdXQgdGhpcywgdXNlDQogc2VyaWFsaXphYmxlIG1v ZGUiLiZuYnNwOyBSZXBlYXRhYmxlIHJlYWQgbW9kZSBtZWV0cyB0aGUNCiByZXF1aXJlbWVu dHMgb2YgdGhlIFNRTCBzcGVjLCBidXQgaXQgZG9lc24ndCBndWFyYW50ZWUNCiBubyBhbm9t YWxpZXMuDQogDQogJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsg Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgcmVnYXJkcywgdG9t IGxhbmU= ------=_NextPart_60A49C47_13C20298_0C16662E Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGRpdj48cHJlIGNsYXNzPSJub3RlIiBzdHlsZT0ibWFyZ2luLWxlZnQ6IDhweDsgZm9udC1z aXplOiAxMnB4OyI+PGZvbnQgX19lZGl0b3J3YXJwX189IjEiIHN0eWxlPSJkaXNwbGF5OiBp bmxpbmU7IGZvbnQtc2l6ZTogMTRweDsgZm9udC1mYW1pbHk6ICZxdW90O2x1Y2lkYSBHcmFu ZGUmcXVvdDssIFZlcmRhbmEsICZxdW90O01pY3Jvc29mdCBZYUhlaSZxdW90OzsgY29sb3I6 IHJnYigwLCAwLCAwKTsgYmFja2dyb3VuZC1jb2xvcjogcmdiYSgwLCAwLCAwLCAwKTsgZm9u dC13ZWlnaHQ6IDQwMDsgZm9udC1zdHlsZTogbm9ybWFsOyI+SGkgVG9tLDwvZm9udD48L3By ZT48L2Rpdj48ZGl2PkkgdGhpbmsgdGhlIHJlcGVhdGFibGUgcmVhZCB0cmFuc2FjdGlvbiBz aG91bGQgZ2l2ZSBwcmlvcml0eSB0byBzZWUgdGhlIG5ldyB2ZXJzaW9uIHdyaXR0ZW4mbmJz cDtieSBpdHNlbGYsIGUuZy4sIHRoZSBpbnNlcnRpb24gb2YgdGhlIGFib3ZlIGV4YW1wbGUu IFRoZXJlIGlzIG5vIG5lZWQgdG8gcmV0dXJuIHRoZSBvbGQgdmVyc2lvbiB3cml0dGVuIGJ5 IGNvbW1pdHRlZCB0cmFuc2FjdGlvbnMuIFRoZSBxdWVyeSByZXN1bHQgZm8gU2Vzc2lvbiBC IGlzIHZlcnkgY29uZnVzaW5nITwvZGl2PjxkaXY+PGluY2x1ZGV0YWlsPjxkaXY+PHNwYW4g c3R5bGU9ImZvbnQtZmFtaWx5OiAmcXVvdDtBcmlhbCBOYXJyb3cmcXVvdDs7IGZvbnQtc2l6 ZTogMTJweDsiPjxicj48L3NwYW4+PC9kaXY+PGRpdj48c3BhbiBzdHlsZT0iZm9udC1mYW1p bHk6ICZxdW90O0FyaWFsIE5hcnJvdyZxdW90OzsgZm9udC1zaXplOiAxMnB4OyI+LS0tLS0t LS0tLS0tLS0tLS0tJm5ic3A7T3JpZ2luYWwmbmJzcDstLS0tLS0tLS0tLS0tLS0tLS08L3Nw YW4+PC9kaXY+PGRpdiBzdHlsZT0iZm9udDpWZXJkYW5hIG5vcm1hbCAxNHB4O2NvbG9yOiMw MDA7Ij48ZGl2IHN0eWxlPSJGT05ULVNJWkU6IDEycHg7YmFja2dyb3VuZDojZWZlZmVmO3Bh ZGRpbmc6OHB4OyI+PGRpdiBpZD0ibWVudV9zZW5kZXIiPjxiPkZyb206IDwvYj4mbmJzcDsi 5YiY5rKb5rqQIiZsdDtscHkuaGVudUBnbWFpbC5jb20mZ3Q7OzwvZGl2PjxkaXY+PGI+RGF0 ZTogPC9iPiZuYnNwO1dlZCwgTWF5IDE5LCAyMDIxIDA5OjA1IEFNPC9kaXY+PGRpdj48Yj5U bzogPC9iPiZuYnNwOyI1MjE5NDUwMTAxMSImbHQ7NTIxOTQ1MDEwMTFAc3R1LmVjbnUuZWR1 LmNuJmd0OzsgPHdicj48L2Rpdj48ZGl2PjwvZGl2PjxkaXY+PGI+U3ViamVjdDogPC9iPiZu YnNwO0Z3ZDogQlVHICMxNzAxNzogVHdvIHZlcnNpb25zIG9mIHRoZSBzYW1lIHJvdyBvZiBy ZWNvcmRzIGFyZSByZXR1cm5lZCBpbiBvbmUgcXVlcnk8L2Rpdj48L2Rpdj48ZGl2PiZuYnNw OzwvZGl2PjxkaXYgc3R5bGU9InBvc2l0aW9uOnJlbGF0aXZlOyI+PGRpdiBpZD0idG1wY29u dGVudF9yZXMiPjwvZGl2PjxkaXYgZGlyPSJhdXRvIj48ZGl2Pjxicj48YnI+PGRpdiBjbGFz cz0iZ21haWxfcXVvdGUiPjxkaXYgZGlyPSJsdHIiIGNsYXNzPSJnbWFpbF9hdHRyIj4tLS0t LS0tLS0tIEZvcndhcmRlZCBtZXNzYWdlIC0tLS0tLS0tLTxicj7lj5Hku7bkurrvvJogPHN0 cm9uZyBjbGFzcz0iZ21haWxfc2VuZGVybmFtZSIgZGlyPSJhdXRvIj5Ub20gTGFuZTwvc3Ry b25nPiA8c3BhbiBkaXI9ImF1dG8iPiZsdDs8YSBocmVmPSJtYWlsdG86dGdsQHNzcy5wZ2gu cGEudXMiPnRnbEBzc3MucGdoLnBhLnVzPC9hPiZndDs8L3NwYW4+PGJyPkRhdGU6IDIwMjHl ubQ15pyIMTnml6XlkajkuIkgMDA6MTg8YnI+U3ViamVjdDogUmU6IEJVRyAjMTcwMTc6IFR3 byB2ZXJzaW9ucyBvZiB0aGUgc2FtZSByb3cgb2YgcmVjb3JkcyBhcmUgcmV0dXJuZWQgaW4g b25lIHF1ZXJ5PGJyPlRvOiAgJmx0OzxhIGhyZWY9Im1haWx0bzpscHkuaGVudUBnbWFpbC5j b20iPmxweS5oZW51QGdtYWlsLmNvbTwvYT4mZ3Q7PGJyPkNjOiAgJmx0OzxhIGhyZWY9Im1h aWx0bzpwZ3NxbC1idWdzQGxpc3RzLnBvc3RncmVzcWwub3JnIj5wZ3NxbC1idWdzQGxpc3Rz LnBvc3RncmVzcWwub3JnPC9hPiZndDs8YnI+PC9kaXY+PGJyPjxicj5QRyBCdWcgcmVwb3J0 aW5nIGZvcm0gJmx0OzxhIGhyZWY9Im1haWx0bzpub3JlcGx5QHBvc3RncmVzcWwub3JnIiB0 YXJnZXQ9Il9ibGFuayIgcmVsPSJub3JlZmVycmVyIj5ub3JlcGx5QHBvc3RncmVzcWwub3Jn PC9hPiZndDsgd3JpdGVzOjxicj4NCiZndDsgU2NoZW1hIGFuZCBJbml0aWFsIGRhdGE6IDxi cj4NCiZndDsgQ3JlYXRlIFRhYmxlIHQoYSBpbnQgcHJpbWFyeSBrZXksIGIgaW50KTs8YnI+ DQomZ3Q7IEluc2VydCBpbnRvIHQgdmFsdWVzKDEsMik7PGJyPg0KJmd0OyBJbnNlcnQgaW50 byB0IHZhbHVlcygyLDMpOzxicj4NCjxicj4NCiZndDsgW1RpbWUwLCBTZXNzb25BXTxicj4N CiZndDsmZ3Q7IEJlZ2luOzxicj4NCiZndDsmZ3Q7IHNldCB0cmFuc2FjdGlvbiBpc29sYXRp b24gbGV2ZWwgcmVwZWF0YWJsZSByZWFkOzxicj4NCiZndDsmZ3Q7IFNlbGVjdCAqIGZyb20g dCB3aGVyZSBhPTE7PGJyPg0KPGJyPg0KJmd0OyBbVGltZTEsIFNlc3NvbkJdPGJyPg0KJmd0 OyZndDsgQmVnaW47PGJyPg0KJmd0OyZndDsgc2V0IHRyYW5zYWN0aW9uIGlzb2xhdGlvbiBs ZXZlbCByZWFkIGNvbW1pdHRlZDs8YnI+DQomZ3Q7Jmd0OyBEZWxldGUgZnJvbSB0IHdoZXJl IGE9Mjs8YnI+DQomZ3Q7Jmd0OyBDb21taXQ7PGJyPg0KPGJyPg0KJmd0OyBbVGltZTIsIFNl c3NvbkFdPGJyPg0KJmd0OyZndDsgSW5zZXJ0IGludG8gdCB2YWx1ZXMoMiw0KTs8YnI+DQom Z3Q7Jmd0OyBTZWxlY3QgKiBmcm9tIHQgd2hlcmUgYT0yOzxicj4NCjxicj4NCiZndDsgSGVy ZSwgd2UgZXhwZWN0IFBvc3RncmVTUUwgU2VydmVyIHRvIHJldHVybiBhIHJvdzo8YnI+DQom Z3Q7IDIgMzxicj4NCjxicj4NCiZndDsgSG93ZXZlciwgaXQgcmV0dXJucyB0d28gcm93czo8 YnI+DQomZ3Q7IDIgNDxicj4NCiZndDsgMiAzPGJyPg0KPGJyPg0KSW4gcmVwZWF0YWJsZSBy ZWFkIG1vZGUsIHRoaXMgZG9lc24ndCBzdXJwcmlzZSBtZS4mbmJzcDsgU2Vzc2lvbiBBPGJy Pg0Kc3VyZWx5IG11c3QgcmV0dXJuIHRoZSAoMiwzKSByb3csIHNpbmNlIGl0IGlzbid0IHN1 cHBvc2VkIHRvPGJyPg0KInNlZSIgdGhlIHJlc3VsdHMgb2YgU2Vzc2lvbiBCJ3MgY29tbWl0 IHlldC4mbmJzcDsgQW5kIGl0IHdvdWxkIGJlPGJyPg0KbWlnaHR5IHN1cnByaXNpbmcgZm9y IGl0IG5vdCB0byBzZWUgaXRzIG93biBpbnNlcnRpb24sIHNvIHlvdTxicj4NCmdldCAoMiw0 KSBhcyB3ZWxsLjxicj4NCjxicj4NCkluIHNlcmlhbGl6YWJsZSBtb2RlLCBJJ2QgZXhwZWN0 IHRoaXMgc2l0dWF0aW9uIHRvIHRocm93IGE8YnI+DQpzZXJpYWxpemF0aW9uIGVycm9yLCBh bmQgaXQgZG9lcyAoYnV0IHlvdSBtdXN0IHJ1biBCT1RIPGJyPg0KdHJhbnNhY3Rpb25zIGlu IHNlcmlhbGl6YWJsZSBtb2RlOyB0aGVyZSBhcmUgbm90IGd1YXJhbnRlZXM8YnI+DQp3aXRo IGEgbWl4IG9mIHNlcmlhbGl6YWJsZSBhbmQgbm9uLXNlcmlhbGl6YWJsZSB0cmFuc2FjdGlv bnMpLjxicj4NCjxicj4NClNvIEkgdGhpbmsgdGhlIGFuc3dlciBpcyAiaWYgeW91IGNhcmUg YWJvdXQgdGhpcywgdXNlPGJyPg0Kc2VyaWFsaXphYmxlIG1vZGUiLiZuYnNwOyBSZXBlYXRh YmxlIHJlYWQgbW9kZSBtZWV0cyB0aGU8YnI+DQpyZXF1aXJlbWVudHMgb2YgdGhlIFNRTCBz cGVjLCBidXQgaXQgZG9lc24ndCBndWFyYW50ZWU8YnI+DQpubyBhbm9tYWxpZXMuPGJyPg0K PGJyPg0KJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7 ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgcmVnYXJkcywgdG9tIGxhbmU8 YnI+DQo8L2Rpdj48L2Rpdj48L2Rpdj4NCg0KPC9kaXY+PC9kaXY+PCEtLTwhW2VuZGlmXS0t PjwvaW5jbHVkZXRhaWw+PC9kaXY+ ------=_NextPart_60A49C47_13C20298_0C16662E--