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 1q3Igj-0003TZ-Om for pgsql-bugs@arkaria.postgresql.org; Sun, 28 May 2023 15:52:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q3Igh-0005aY-It for pgsql-bugs@arkaria.postgresql.org; Sun, 28 May 2023 15:52:07 +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 ) id 1q3FUK-0006G6-On for pgsql-bugs@lists.postgresql.org; Sun, 28 May 2023 12:27:08 +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 1q3FUH-002KwY-B6 for pgsql-bugs@lists.postgresql.org; Sun, 28 May 2023 12:27:07 +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=I0+kZCACGRTPUoKyfT+2xjzAO0rD00LAzhJE4EsWU0k=; b=iNu8nyU8RKJ6bOIyXj8YExipmn uboiHL+F+fHP1UpgBLmGHLWF13JHv1q5aXQhCDYzoLqKQHuM6abwOZyjq0tzyoHxH1QBMBALpvG0L LF+/+CU3fPBdFJhzBz10OFLNfq5uLm5pAHDsO19AXPgoPlN1jY1TZ1m8TMTfqUdb7jMAXI6b3vcbP YZ3GJfkS2c9G4gdUxf3IDq5vJVxRhNZr8viZYfiLVomgU/ufyGdMKkGg+JDl+x63hhIwWjUxrW2vq NJ49fI6hyTfSWcDJwI7eqgKa1WXcmGyE4KQ0FRHZTs0L8Uuu3dEWoWv3PK9jbU8iUVf5QqcKALd9m sY4k7AIA==; 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 1q3FUG-0008Os-7y for pgsql-bugs@lists.postgresql.org; Sun, 28 May 2023 12:27: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 1q3FUE-007K4Y-S6 for pgsql-bugs@lists.postgresql.org; Sun, 28 May 2023 12:27:02 +0000 Content-Type: multipart/mixed; boundary="===============0857754003410460294==" MIME-Version: 1.0 Subject: BUG #17949: Adding an index introduces serialisation anomalies. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: artem.anisimov.255@gmail.com Reply-To: artem.anisimov.255@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 28 May 2023 12:26:31 +0000 Message-ID: <17949-a0f17035294a55e2@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 --===============0857754003410460294== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzk0OQpMb2dnZWQgYnk6ICAgICAgICAgIEFydGVtIEFuaXNpbW92CkVt YWlsIGFkZHJlc3M6ICAgICAgYXJ0ZW0uYW5pc2ltb3YuMjU1QGdtYWlsLmNvbQpQb3N0Z3JlU1FM IHZlcnNpb246IDE1LjMKT3BlcmF0aW5nIHN5c3RlbTogICBmZWRvcmEgMzgKRGVzY3JpcHRpb246 ICAgICAgICAKCkhlbGxvIGRlYXIgcGcgYXV0aG9ycywNCg0KSSBoYXZlIGNvbWUgYWNyb3NzIGEg YmVoYXZpb3VyIGluIHBnIHRoYXQgY29udHJhZGljdHMKaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5v cmcvZG9jcy8xNS90cmFuc2FjdGlvbi1pc28uaHRtbCNYQUNULVNFUklBTElaQUJMRS4NCg0KSSd2 ZSBtaW5pbWlzZWQgbXkgdGVzdGNhc2UgdG8gYSBzY2VuYXJpbyB0aGF0IGVzc2VudGlhbGx5IGR1 cGxpY2F0ZXMgYQpzY2VuYXJpbyB0aGF0IHlvdSBkZXNjcmliZSBpbiB0aGUgZm9sbG93aW5nIHBh cmFncmFwaDoNCj4gSW4gcGFydGljdWxhciwgaXQgaXMgcG9zc2libGUgdG8gc2VlIHVuaXF1ZSBj b25zdHJhaW50IHZpb2xhdGlvbnMNCj4gY2F1c2VkIGJ5IGNvbmZsaWN0cyB3aXRoIG92ZXJsYXBw aW5nIFNlcmlhbGl6YWJsZSB0cmFuc2FjdGlvbnMNCj4gZXZlbiBhZnRlciBleHBsaWNpdGx5IGNo ZWNraW5nIHRoYXQgdGhlIGtleSBpc24ndCBwcmVzZW50DQo+IGJlZm9yZSBhdHRlbXB0aW5nIHRv IGluc2VydCBpdC4NCj4gVGhpcyBjYW4gYmUgYXZvaWRlZCBieSBtYWtpbmcgc3VyZSB0aGF0IGFs bCBTZXJpYWxpemFibGUgdHJhbnNhY3Rpb25zCnRoYXQNCj4gaW5zZXJ0IHBvdGVudGlhbGx5IGNv bmZsaWN0aW5nIGtleXMgZXhwbGljaXRseSBjaGVjayBpZiB0aGV5IGNhbiBkbyBzbwpmaXJzdC4N Cg0KQXQgdGhlIGVuZCBvZiB0aGUgcmVwb3J0IHRoZXJlIGlzIGEgQyByZXByb2R1Y2VyIHRoYXQg aGlnaGxpZ2h0cyB0aGUKcHJvYmxlbS4gTGV0IG1lIGdpdmUgYSBoaWdoLWxldmVsIG92ZXJ2aWV3 IG9mIHRoZSBzY2VuYXJpbyBmaXJzdC4NCg0KSSBoYXZlIE4gdGhyZWFkcyBlYWNoIHRyeWluZyB0 byAiYWNxdWlyZSBhbiBleGNsdXNpdmUgbG9jayIgdGhpcyB3YXk6DQogIEJFR0lOIFRSQU5TQUNU SU9OIElTT0xBVElPTiBMRVZFTCBTRVJJQUxJWkFCTEU7DQogIFNFTEVDVCAqIEZST00gbG9ja3Mg V0hFUkUgcGF0aCA9ICQxOw0KICBxdWl0IGlmIHRoZXJlIGFscmVhZHkgaXMgYSBsb2NrDQogIElO U0VSVCBJTlRPIGxvY2tzKHBhdGgsIC4uLikgVkFMVUVTKCQxLCAuLi4pOw0KICBDT01NSVQ7DQoN Ck9uY2UgYWxsIHRocmVhZHMgaGF2ZSBhdHRlbXB0ZWQgdG8gYWNxdWlyZSBhIGxvY2ssIEkgY291 bnQgaG93IG1hbnkgb2YgdGhlbQpzdWNjZWVkZWQgdG8gSU5TRVJUIElOVE8uIE5vcm1hbGx5LCB0 aGVyZSBpcyBvbmx5IG9uZSB0aHJlYWQgdGhhdCBzdWNjZWVkcywKd2hpY2ggaXMgd2hhdCBJIGV4 cGVjdC4gSG93ZXZlciwgaWYgSSBhZGQgYSBIQVNIIG9yIGEgQlRSRUUgaW5kZXggb24gInBhdGgi LAppdCBiZWNvbWVzIHBvc3NpYmxlIGZvciBtdWx0aXBsZSB0aHJlYWRzIHRvIGRvIGEgc3VjY2Vz c2Z1bCBJTlNFUlQgSU5UTywKd2hpY2ggdmlvbGF0ZXMgdGhlIHNlcmlhbGlzYWJpbGl0eS4NCg0K VGhlIHByb2JsZW0gY2FuIGJlIHJlcHJvZHVjZWQgd2l0aCB0aGUgZGVmYXVsdCBwb3N0Z3Jlc3Fs LmNvbmYsIGJ1dCBpdCB0YWtlcwpzb21lIHRpbWUuIElmIEkgaW5jcmVhc2UgInNoYXJlZF9idWZm ZXJzIiB0byAxMDI0TUIsIHRoZSBpc3N1ZSBhcHBlYXJzCmFsbW9zdCBpbW1lZGlhdGVseSAoZmV3 ZXIgY2hhbmNlcyB0byBwcm9tb3RlIHByZWRpY2F0ZSBsb2NrcyB0byBsb2NrcyBvbiB0aGUKd2hv bGUgdGFibGU/KS4NCg0KSSd2ZSBzZWVuIHRoaXMgYmVoYXZpb3VyIHdpdGggcGcgMTMsIDE1IGFu ZCAxNiAoNTAzYjA1NSkuDQoNCk5vdyBsZXQgdXMgc2VlIHRoZSByZXByb2R1Y2VyLiBJdCBoYXMg dHdvIHByaW1hcnkgY29tcG9uZW50czoNCjEuIHRlc3Rfb25jZSgpIHNwYXducyAzMiB0aHJlYWRz IHRoYXQgdHJ5IHRvIGFjcXVpcmUgYSBsb2NrLCB3YWl0cyBmb3IgdGhlbSwKYW5kIGNvdW50cyB0 aGUgbnVtYmVyIG9mICJhY3F1aXJlZCBleGNsdXNpdmUgbG9ja3MiLA0KMi4gdHJ5X2FjcXVpcmVf bG9jaygpIGV4ZWN1dGVzIGEgdHJhbnNhY3Rpb24gZGVzY3JpYmVkIGFib3ZlLg0KDQpUbyBidWls ZCB0aGUgcmVwcm9kdWNlcjoNCiQgIGdjYyAtc3RkPWM5OSAtbyB0ZXN0IHRlc3QuYyAtcHRocmVh ZCBgcGtnLWNvbmZpZyBsaWJwcSAtLWNmbGFncyAtLWxpYnNgDQoNClRvIHJ1biB0aGUgcmVwcm9k dWNlcjoNCiQgLi90ZXN0DQpvcg0KJCBEQl9DT05OU1RSPSJkYm5hbWU9YWJjIGhvc3Q9ZGVmIHVz ZXI9Z2hpIiAuL3Rlc3QNCg0KVGhlIHJlcHJvZHVjZXI6DQoNCiNkZWZpbmUgX0dOVV9TT1VSQ0UN Cg0KI2luY2x1ZGUgPHN0ZGlvLmg+DQojaW5jbHVkZSA8c3RkbGliLmg+DQojaW5jbHVkZSA8cHRo cmVhZC5oPg0KI2luY2x1ZGUgPGFzc2VydC5oPg0KDQojaW5jbHVkZSA8bGlicHEtZmUuaD4NCg0K DQovLyBDb21tZW50IHRoaXMgdG8gbWFrZSBzZXJpYWxpc2F0aW9uIGFub21hbGllcyBnbyBhd2F5 Lg0KI2RlZmluZSBXSVRIX0lOREVYDQoNCg0KLy8gSSBoYXZlIHNlZW4gdGhlIHByb2JsZW0gd2l0 aCBhcyBmZXcgYXMgMyB0aHJlYWRzLiAzMiB0aHJlYWRzIG1ha2UNCi8vIHRoZSBpc3N1ZSBhcHBl YXIgbXVjaCBzb29uZXIuDQojZGVmaW5lIE5SX1RIUkVBRFMgKDMyKQ0KI2RlZmluZSBOUl9SVU5T ICgxMDI0ICogMTAyNCkNCg0Kc3RhdGljIFBHY29ubiAqY29ubnNbTlJfVEhSRUFEU107DQoNCnN0 YXRpYyB2b2lkKiB0cnlfYWNxdWlyZV9sb2NrKHZvaWQgKmFyZykNCnsNCiAgICAgICAgUEdjb25u ICpjID0gYXJnOw0KICAgICAgICBQR3Jlc3VsdCAqcmVzOw0KICAgICAgICBpbnQgbnR1cGxlczsN Cg0KICAgICAgICByZXMgPSBQUWV4ZWMoYywgIkJFR0lOIFRSQU5TQUNUSU9OIElTT0xBVElPTiBM RVZFTCBTRVJJQUxJWkFCTEUiKTsNCiAgICAgICAgYXNzZXJ0KFBRcmVzdWx0U3RhdHVzKHJlcykg PT0gUEdSRVNfQ09NTUFORF9PSyk7DQogICAgICAgIFBRY2xlYXIocmVzKTsNCg0KICAgICAgICBy ZXMgPSBQUWV4ZWMoYywgIlNFTEVDVCAqIEZST00gbG9ja3MgV0hFUkUgcGF0aCA9ICd4eXonIik7 DQogICAgICAgIGFzc2VydChQUXJlc3VsdFN0YXR1cyhyZXMpID09IFBHUkVTX1RVUExFU19PSyk7 DQogICAgICAgIG50dXBsZXMgPSBQUW50dXBsZXMocmVzKTsNCiAgICAgICAgUFFjbGVhcihyZXMp Ow0KDQogICAgICAgIGlmIChudHVwbGVzID4gMCkgew0KICAgICAgICAgICAgICAgIC8vIHNvbWVv bmUgZWxzZSBhbHJlYWR5IGhhcyBhIGxvY2sNCiAgICAgICAgICAgICAgICByZXMgPSBQUWV4ZWMo YywgIkNPTU1JVCIpOw0KICAgICAgICAgICAgICAgIGFzc2VydChQUXJlc3VsdFN0YXR1cyhyZXMp ID09IFBHUkVTX0NPTU1BTkRfT0spOw0KICAgICAgICAgICAgICAgIFBRY2xlYXIocmVzKTsNCiAg ICAgICAgICAgICAgICByZXR1cm4gTlVMTDsNCiAgICAgICAgfQ0KDQogICAgICAgIHJlcyA9IFBR ZXhlYyhjLCAiSU5TRVJUIElOVE8gbG9ja3MocGF0aCkgVkFMVUVTKCd4eXonKSIpOw0KICAgICAg ICBQUWNsZWFyKHJlcyk7DQoNCiAgICAgICAgcmVzID0gUFFleGVjKGMsICJDT01NSVQiKTsNCiAg ICAgICAgUFFjbGVhcihyZXMpOw0KDQogICAgICAgIHJldHVybiBOVUxMOw0KfQ0KDQpzdGF0aWMg dm9pZCB0ZXN0X29uY2Uodm9pZCkNCnsNCiAgICAgICAgUEdjb25uICpjID0gY29ubnNbMF07DQog ICAgICAgIFBHcmVzdWx0ICpyZXM7DQogICAgICAgIGludCBudHVwbGVzOw0KDQogICAgICAgIHB0 aHJlYWRfdCB0aHJzW05SX1RIUkVBRFNdOw0KICAgICAgICBmb3IgKGludCBpID0gMDsgaSA8IE5S X1RIUkVBRFM7ICsraSkNCiAgICAgICAgICAgICAgICBwdGhyZWFkX2NyZWF0ZSgmdGhyc1tpXSwg TlVMTCwgJnRyeV9hY3F1aXJlX2xvY2ssCmNvbm5zW2ldKTsNCiAgICAgICAgZm9yIChpbnQgaSA9 IDA7IGkgPCBOUl9USFJFQURTOyArK2kpDQogICAgICAgICAgICAgICAgcHRocmVhZF9qb2luKHRo cnNbaV0sIE5VTEwpOw0KDQogICAgICAgIHJlcyA9IFBRZXhlYyhjLCAiU0VMRUNUICogRlJPTSBs b2NrcyBXSEVSRSBwYXRoID0gJ3h5eiciKTsNCiAgICAgICAgYXNzZXJ0KFBRcmVzdWx0U3RhdHVz KHJlcykgPT0gUEdSRVNfVFVQTEVTX09LKTsNCiAgICAgICAgbnR1cGxlcyA9IFBRbnR1cGxlcyhy ZXMpOw0KICAgICAgICBQUWNsZWFyKHJlcyk7DQoNCiAgICAgICAgaWYgKG50dXBsZXMgIT0gMSkN CiAgICAgICAgICAgICAgICBwcmludGYoIm50dXBsZXMgPSAlZFxuIiwgbnR1cGxlcyk7DQogICAg ICAgIGFzc2VydChudHVwbGVzID09IDEpOw0KDQogICAgICAgIHJlcyA9IFBRZXhlYyhjLCAiVFJV TkNBVEUgVEFCTEUgbG9ja3MiKTsNCiAgICAgICAgYXNzZXJ0KFBRcmVzdWx0U3RhdHVzKHJlcykg PT0gUEdSRVNfQ09NTUFORF9PSyk7DQogICAgICAgIFBRY2xlYXIocmVzKTsNCn0NCg0Kc3RhdGlj IHZvaWQgcHJlcGFyZV9kYih2b2lkKQ0Kew0KICAgICAgICBQR2Nvbm4gKmMgPSBjb25uc1swXTsN CiAgICAgICAgUEdyZXN1bHQgKnJlczsNCg0KICAgICAgICByZXMgPSBQUWV4ZWMoYywgIkRST1Ag VEFCTEUgbG9ja3MiKTsNCiAgICAgICAgUFFjbGVhcihyZXMpOw0KDQogICAgICAgIHJlcyA9IFBR ZXhlYyhjLCAiQ1JFQVRFIFRBQkxFIGxvY2tzIChwYXRoIFRFWFQgTk9UIE5VTEwpIik7DQogICAg ICAgIGFzc2VydChQUXJlc3VsdFN0YXR1cyhyZXMpID09IFBHUkVTX0NPTU1BTkRfT0spOw0KICAg ICAgICBQUWNsZWFyKHJlcyk7DQoNCiNpZmRlZiBXSVRIX0lOREVYDQogICAgICAgIHJlcyA9IFBR ZXhlYyhjLCAiQ1JFQVRFIElOREVYIE9OIGxvY2tzIFVTSU5HIEhBU0gocGF0aCkiKTsNCiAgICAg ICAgYXNzZXJ0KFBRcmVzdWx0U3RhdHVzKHJlcykgPT0gUEdSRVNfQ09NTUFORF9PSyk7DQogICAg ICAgIFBRY2xlYXIocmVzKTsNCiNlbmRpZg0KfQ0KDQppbnQgbWFpbih2b2lkKQ0Kew0KICAgICAg ICBjb25zdCBjaGFyICpjb25uc3RyID0gZ2V0ZW52KCJEQl9DT05OU1RSIik7DQogICAgICAgIGlm IChjb25uc3RyID09IE5VTEwpDQogICAgICAgICAgICAgICAgY29ubnN0ciA9ICJkYm5hbWU9cG9z dGdyZXMiOw0KDQogICAgICAgIGZvciAoaW50IGkgPSAwOyBpIDwgTlJfVEhSRUFEUzsgKytpKSB7 DQogICAgICAgICAgICAgICAgY29ubnNbaV0gPSBQUWNvbm5lY3RkYihjb25uc3RyKTsNCiAgICAg ICAgICAgICAgICBhc3NlcnQoUFFzdGF0dXMoY29ubnNbaV0pID09IENPTk5FQ1RJT05fT0spOw0K ICAgICAgICB9DQogICAgICAgIHByZXBhcmVfZGIoKTsNCg0KICAgICAgICBmb3IgKGludCBpID0g MDsgaSA8IE5SX1JVTlM7ICsraSkNCiAgICAgICAgICAgICAgICB0ZXN0X29uY2UoKTsNCg0KICAg ICAgICBmb3IgKGludCBpID0gMDsgaSA8IE5SX1RIUkVBRFM7ICsraSkNCiAgICAgICAgICAgICAg ICBQUWZpbmlzaChjb25uc1tpXSk7DQoNCiAgICAgICAgcmV0dXJuIDA7DQp9Cgo= --===============0857754003410460294==--