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 1qQ9Yh-00D4L6-EL for pgsql-bugs@arkaria.postgresql.org; Sun, 30 Jul 2023 16:46:19 +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 1qQ9Ye-009v5A-10 for pgsql-bugs@arkaria.postgresql.org; Sun, 30 Jul 2023 16:46:16 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQ97S-009rYB-4h for pgsql-bugs@lists.postgresql.org; Sun, 30 Jul 2023 16:18:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qQ97N-002Pla-07 for pgsql-bugs@lists.postgresql.org; Sun, 30 Jul 2023 16:18:08 +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=PmV+9jQeB8qNh0ywiXE4xL0J7SwXZHSSFRHhriYJgeU=; b=upuCyjs+1HFHH8Bt8tPA30HYQx /cCDBkwx7tDnRAotdfxejnsqBLlpzuW/mTXH6owtE5RpUEkUGD9qy30rh537i5qLdzskF+fPabhIN BsmNueuGw/Et1WfJM0qMUdVbdH75Tmb7VkkMqmXOy25z/Gs3Y+PmgDeXi3zP3WuQz5UgQ37KY5H3V G7M5J3KksQyhD6rtR8i2+f5RP9sD+A/9dIbo0RYE3dWMvA0OPg+y/rVn/P8dsiAPX6+A1LWwE39pb iRguJFnUl9kW5rCtJKWW8zHAoEgq3Tp4nz+3Zv55UUvAwMyDRg3QWU6avyTfg1CoamFfUs0mJ0I9e ChzaXE8Q==; 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 1qQ97M-0005L1-Ey for pgsql-bugs@lists.postgresql.org; Sun, 30 Jul 2023 16:18:04 +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 1qQ97K-003cwu-Nt for pgsql-bugs@lists.postgresql.org; Sun, 30 Jul 2023 16:18:02 +0000 Content-Type: multipart/mixed; boundary="===============7174115066078351919==" MIME-Version: 1.0 Subject: BUG #18043: Merge fails to insert when source and target are same table and table is empty (contains no rows) To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: clark.pearson@mail.com Reply-To: clark.pearson@mail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 30 Jul 2023 16:17:50 +0000 Message-ID: <18043-d89bc5e22cb0f2e4@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 --===============7174115066078351919== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODA0MwpMb2dnZWQgYnk6ICAgICAgICAgIENsYXJrIFBlYXJzb24KRW1h aWwgYWRkcmVzczogICAgICBjbGFyay5wZWFyc29uQG1haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTUuMgpPcGVyYXRpbmcgc3lzdGVtOiAgIFdpbmRvd3MKRGVzY3JpcHRpb246ICAgICAgICAK CkkgaGF2ZSBjaGVja2VkIHRoZSByZWxlYXNlIG5vdGVzIGZvciA1LjMsIEZBUSAmIFRPIERPLCBh bmQgY2FuIGZpbmQgbm8KbWVudGlvbiBvZiB0aGlzIGFzIGEga25vd24gYnVnLCBvciBhcyB3b3Jr IGluIHByb2dyZXNzLiAgSSBhbSBjdXJyZW50bHkgb24KMTUuMi4NCg0KVGhpcyB0ZXN0IGNhc2Ug ZGVtb25zdHJhdGVzIGZhaWx1cmUgdG8gaW5zZXJ0IGEgcm93IGludG8gYW4gZW1wdHkgdGFibGUg d2hlbgpzb3VyY2UvdGFyZ2V0IGFyZSB0aGUgc2FtZSB0YWJsZSAoSSBoYXZlIG5vdCBleHBsb3Jl ZCB3aGV0aGVyIGl0IGFwcGxpZXMgaW4KYSB3aWRlciBjb250ZXh0LCBvbmx5IHdoZW4gc291cmNl L3RhcmdldCBhcmUgdGhlIHNhbWUgdGFibGUpOg0KDQpwb3N0Z3Jlcz0+IGNyZWF0ZSB0YWJsZSB0 IChpZCBpbnRlZ2VyLCB2YWwgaW50ZWdlcik7DQpDUkVBVEUgVEFCTEUNCg0KLS0gVGFibGUgaXMg ZW1wdHksIG1lcmdlIGlkPTEgcm93IDo6IGRvZXMgbm90IGluc2VydA0KcG9zdGdyZXM9PiBtZXJn ZSBpbnRvIHQgbiB1c2luZyB0IG8gb24oIG4uaWQgPSAxICkgd2hlbiBtYXRjaGVkIHRoZW4gdXBk YXRlCnNldCB2YWwgPSBvLnZhbCsxIHdoZW4gbm90IG1hdGNoZWQgdGhlbiBpbnNlcnQoaWQsdmFs KSB2YWx1ZXMoMSwxKTsNCk1FUkdFIDANCg0KLS0gVGFibGUgaXMgc3RpbGwgZW1wdHksIGNoYW5n ZSBqb2luIGNvbmRpdGlvbiBhbGlhcyB0byAnbycgKG9sZCkgcmF0aGVyCnRoYW4gJ24nIChuZXcp IDo6IHN0aWxsIGRvZXMgbm90IGluc2VydA0KcG9zdGdyZXM9PiBtZXJnZSBpbnRvIHQgbiB1c2lu ZyB0IG8gb24oIG8uaWQgPSAxICkgd2hlbiBtYXRjaGVkIHRoZW4gdXBkYXRlCnNldCB2YWwgPSBv LnZhbCsxIHdoZW4gbm90IG1hdGNoZWQgdGhlbiBpbnNlcnQoaWQsdmFsKSB2YWx1ZXMoMSwxKTsN Ck1FUkdFIDANCg0KLS0gSW5zZXJ0IGEgcm93LCBpZD0xDQpwb3N0Z3Jlcz0+IGluc2VydCBpbnRv IHQgdmFsdWVzKDEsMSk7DQpJTlNFUlQgMCAxDQoNCi0tIFJlcnVuIG9yaWdpbmFsIG1lcmdlIHN0 YXRlbWVudCwgaWQ9MSByb3cgaXMgZm91bmQgYW5kIG1lcmdlLXVwZGF0ZWQKKHQudmFsIGNvbHVt biBpcyBzZXQgdXAgYnkgMSB0byAyKQ0KcG9zdGdyZXM9PiBtZXJnZSBpbnRvIHQgbiB1c2luZyB0 IG8gb24oIG4uaWQgPSAxICkgd2hlbiBtYXRjaGVkIHRoZW4gdXBkYXRlCnNldCB2YWwgPSBvLnZh bCsxIHdoZW4gbm90IG1hdGNoZWQgdGhlbiBpbnNlcnQoaWQsdmFsKSB2YWx1ZXMoMSwxKTsNCk1F UkdFIDENCg0KLS0gTm93IHJ1biBtZXJnZSBvbiByb3cgaWQ9MiAobmV3IHJvdyksIG1lcmdlIGNv cnJlY3RseSBpbnNlcnRzIGEgcm93DQpwb3N0Z3Jlcz0+IG1lcmdlIGludG8gdCBuIHVzaW5nIHQg byBvbiggbi5pZCA9IDIgKSB3aGVuIG1hdGNoZWQgdGhlbiB1cGRhdGUKc2V0IHZhbCA9IG8udmFs KzEgd2hlbiBub3QgbWF0Y2hlZCB0aGVuIGluc2VydChpZCx2YWwpIHZhbHVlcygyLDEpOw0KTUVS R0UgMQoK --===============7174115066078351919==--