Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qfK6C-00ALJT-9R for pgsql-bugs@arkaria.postgresql.org; Sun, 10 Sep 2023 13:03:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qfK69-009R8H-4p for pgsql-bugs@arkaria.postgresql.org; Sun, 10 Sep 2023 13:03:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qfK0y-009Mnb-Ft for pgsql-bugs@lists.postgresql.org; Sun, 10 Sep 2023 12:58:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qfK0s-004GPp-L8 for pgsql-bugs@lists.postgresql.org; Sun, 10 Sep 2023 12:58:11 +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=LjJMfKxs7sNJcMmkNT1PykZcAHuZfI4+mklaJQlnXrU=; b=DcEWbO1YNDaF23+xde6dkEvADJ bbGHfnEniS/8ou8J3c/0JC6yicXurt8v+vqYoiYuWc9ddztjBPUuAH00MbrFrduKYgHa60L7YeT3H WRFjlo8/KBZ8aAZWodwFNAqWtKNILVjnDsmbDTd41W4hJzZ56TZAb4ySYDScPh//Z6PUnuX3sf6v0 UiMtQefNqzFg0o6ubURkBaTbZ8lGkN33r7uE6PQcvnO8KRj5q+PR9WU5LzQXW7kIvw4Z7nu198Y5/ 7Y6aKr4ciLwaSVJChHjf1c84OEhYqmIBVAAHTiFeXSzvlI4mPHgMvXwSuuGZ5FBTZIFA4x+m4P2M5 EBaa/YGQ==; 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 1qfK0p-0002jL-UK for pgsql-bugs@lists.postgresql.org; Sun, 10 Sep 2023 12:58:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qfK0o-00CUmc-6B for pgsql-bugs@lists.postgresql.org; Sun, 10 Sep 2023 12:58:02 +0000 Content-Type: multipart/mixed; boundary="===============7713629714895403819==" MIME-Version: 1.0 Subject: BUG #18103: bugs of concurrent merge into when use different join plan To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: luajk@qq.com Reply-To: luajk@qq.com, pgsql-bugs@lists.postgresql.org Date: Sun, 10 Sep 2023 12:57:14 +0000 Message-ID: <18103-c4386baab8e355e3@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 --===============7713629714895403819== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODEwMwpMb2dnZWQgYnk6ICAgICAgICAgIGx1YWprCkVtYWlsIGFkZHJl c3M6ICAgICAgbHVhamtAcXEuY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTZyYzEKT3BlcmF0aW5n IHN5c3RlbTogICBBTlkKRGVzY3JpcHRpb246ICAgICAgICAKClVzZSBDYXNlOg0KDQpkcm9wIHRh YmxlIHQxOw0KZHJvcCB0YWJsZSB0MjsNCg0KY3JlYXRlIHRhYmxlIHQxKGEgaW50IG5vdCBudWxs LCBiIGludCk7DQpjcmVhdGUgdGFibGUgdDIoYSBpbnQgbm90IG51bGwsIGIgaW50KTsNCg0KaW5z ZXJ0IGludG8gdDEgdmFsdWVzKGdlbmVyYXRlX3NlcmllcygxLDMpLCBnZW5lcmF0ZV9zZXJpZXMo MSwzKSk7DQppbnNlcnQgaW50byB0MiB2YWx1ZXMoZ2VuZXJhdGVfc2VyaWVzKDEsMyksIGdlbmVy YXRlX3NlcmllcygxLDMpKTsNCg0KZXhlY3V0ZSBpbiB0d28gY29uY3VycmVudCBzZXNzaW9ucyBh bmQgZG8gYXMgZm9sbG93aW5nOg0KDQpzZXNzaW9uMToNCmJlZ2luOw0Kc2Vzc2lvbjI6DQpiZWdp bjsNCnNldCBlbmFibGVfaGFzaGpvaW4gPSBvZmY7DQpzZXQgZW5hYmxlX21lcmdlam9pbiA9IG9m ZjsNCm1lcmdlIGludG8gdDEgcCB1c2luZyAoc2VsZWN0IGRpc3RpbmN0IGEsYiBmcm9tIHQyKSBx IG9uIHAuYSA9IHEuYSB3aGVuCm1hdGNoZWQgdGhlbiB1cGRhdGUgc2V0IGIgPSBxLmIgd2hlbiBu b3QgbWF0Y2hlZCB0aGVuIGluc2VydCB2YWx1ZXMocS5hLApxLmIpOw0Kc2Vzc2lvbjE6DQpzZXQg ZW5hYmxlX2hhc2hqb2luID0gb2ZmOw0Kc2V0IGVuYWJsZV9tZXJnZWpvaW4gPSBvZmY7DQptZXJn ZSBpbnRvIHQxIHAgdXNpbmcgKHNlbGVjdCBkaXN0aW5jdCBhLGIgZnJvbSB0MikgcSBvbiBwLmEg PSBxLmEgd2hlbgptYXRjaGVkIHRoZW4gdXBkYXRlIHNldCBiID0gcS5iIHdoZW4gbm90IG1hdGNo ZWQgdGhlbiBpbnNlcnQgdmFsdWVzKHEuYSwKcS5iKTsNCnNlc3Npb24yOg0KY29tbWl0Ow0Kc2Vz c2lvbjE6DQpzZWxlY3QgY291bnQoKikgZnJvbSB0MTsgIC0tIHRoZXJlIGFyZSA1IHJvd3M7DQoN Cmhvd2V2ZXI6DQoNCnNlc3Npb24xOg0KYmVnaW47DQpzZXNzaW9uMjoNCmJlZ2luOw0Kc2V0IGVu YWJsZV9uZXN0bG9vcCA9IG9mZjsNCnNldCBlbmFibGVfbWVyZ2Vqb2luID0gb2ZmOw0KbWVyZ2Ug aW50byB0MSBwIHVzaW5nIChzZWxlY3QgZGlzdGluY3QgYSxiIGZyb20gdDIpIHEgb24gcC5hID0g cS5hIHdoZW4KbWF0Y2hlZCB0aGVuIHVwZGF0ZSBzZXQgYiA9IHEuYiB3aGVuIG5vdCBtYXRjaGVk IHRoZW4gaW5zZXJ0IHZhbHVlcyhxLmEsCnEuYik7DQpzZXNzaW9uMToNCnNldCBlbmFibGVfbmVz dGxvb3AgPSBvZmY7DQpzZXQgZW5hYmxlX21lcmdlam9pbiA9IG9mZjsNCm1lcmdlIGludG8gdDEg cCB1c2luZyAoc2VsZWN0IGRpc3RpbmN0IGEsYiBmcm9tIHQyKSBxIG9uIHAuYSA9IHEuYSB3aGVu Cm1hdGNoZWQgdGhlbiB1cGRhdGUgc2V0IGIgPSBxLmIgd2hlbiBub3QgbWF0Y2hlZCB0aGVuIGlu c2VydCB2YWx1ZXMocS5hLApxLmIpOw0Kc2Vzc2lvbjI6DQpjb21taXQ7DQpzZXNzaW9uMToNCnNl bGVjdCBjb3VudCgqKSBmcm9tIHQxOyAgLS0gdGhlcmUgYXJlIDMgcm93czsNCg0KbmVzdCBsb29w IGpvaW4gaXMgdGhlIHNhbWUgYXMgbWVyZ2Ugam9pbiBpbiBzdWNoIHNjZW5lcy4KCg== --===============7713629714895403819==--