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 1mrYqN-000174-Dm for pgsql-hackers@arkaria.postgresql.org; Mon, 29 Nov 2021 05:04:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mrYqM-0006OI-CB for pgsql-hackers@arkaria.postgresql.org; Mon, 29 Nov 2021 05:04:46 +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 1mrYqM-0006O9-0c for pgsql-hackers@lists.postgresql.org; Mon, 29 Nov 2021 05:04:46 +0000 Received: from mail-ua1-x930.google.com ([2607:f8b0:4864:20::930]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mrYqJ-0008C8-Gd for pgsql-hackers@lists.postgresql.org; Mon, 29 Nov 2021 05:04:45 +0000 Received: by mail-ua1-x930.google.com with SMTP id az37so31444067uab.13 for ; Sun, 28 Nov 2021 21:04:43 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:from:date:message-id:subject:to; bh=7nMH6WLD/9tJe6RQTQXxaEyvReWMfrnTgWZ0fRRV6DI=; b=YKSnZIPm4NI4fuhJSk5o2XUN+UfGZGUmELC+W6lqZsGamsJknWSra49F/tUsvQCtsR XdX1OLDvMTuGrds1r10noNZxVP2I39l6lmMK9c5f6UaLlTJb2eevjzajnQo5/V//yW/r ibehuHF1v85mDRm5WG83b7RaLJa6lU0t8JZ8NI3iimJT1Jp/ektBejDW5j2aIKUPdGeN Svo1Rkwd15Qzq32lyXuodAFdyJ5X+etAS9YPOTcI40+HQDnns8wSbAZnJdiq6PZYCFPR VE2ba7IEyVt6jyckYZFb04kZyUx7jvEVKpEDQnHVfhdWByjUalm3uNEM3CLXE5xdKpWk P6WA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=7nMH6WLD/9tJe6RQTQXxaEyvReWMfrnTgWZ0fRRV6DI=; b=cQDU1MQZwphB/OboX/e8HAClLgD02A/4qY+l3rPKcsB6OQwSG1CE7+K+CJ6Kgm9XMs RB8reUNRIlOvn9YWQv4WIGTCoYMOu+DR9Z8NjACnjROMzR9p9fTn642vacMk2i/NT4vd Npfu+KFEAa/skMINewvRsyfPmVg8XbA5UDDXxjUnqho0UjOtH/VMtETWzajFueg2KbdR 1yh8dVkhW117Dfpu21dVmuwdO8KmwebaR8+NvUIgBp0foLPdy9+GiArjxXPCZVhVoDvk GXOJTfUoQTFh9aBt9RE/qeurf1fTRnF3f91VeVvtKhexWw2itMhzuWak+BN4JDLP7MQZ 7/Ig== X-Gm-Message-State: AOAM530oAplaKr6q5DTuZq12G3+CgiuwejC7J00/c/xm3Ez3k3TRh1ro OOCsai9krN1PXl/ixpsDkmfm2+IPu9bky0CX9r7nxPoWa18= X-Google-Smtp-Source: ABdhPJzQ9vyWACd7nCtBHXdUb6j5lMm1c/A/rM4yja3AS0A3N6JpJOPagcBv62DvBfERxVcL7nyUbjpm6qBJPKk3iTY= X-Received: by 2002:a9f:2d8c:: with SMTP id v12mr46977706uaj.25.1638162282077; Sun, 28 Nov 2021 21:04:42 -0800 (PST) MIME-Version: 1.0 From: Amul Sul Date: Mon, 29 Nov 2021 10:34:06 +0530 Message-ID: Subject: tweak to a few index tests to hits ambuildempty() routine. To: PostgreSQL Hackers Content-Type: multipart/mixed; boundary="000000000000e8796a05d1e660da" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e8796a05d1e660da Content-Type: text/plain; charset="UTF-8" Hi, Attached patch is doing small changes to brin, gin & gist index tests to use an unlogged table without changing the original intention of those tests and that is able to hit ambuildempty() routing which is otherwise not reachable by the current tests. -- Regards, Amul Sul EDB: http://www.enterprisedb.com --000000000000e8796a05d1e660da Content-Type: application/octet-stream; name="v1_index_test_for_ambuildempty.patch" Content-Disposition: attachment; filename="v1_index_test_for_ambuildempty.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_kwk7gale0 ZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvYnJpbi5vdXQgYi9zcmMvdGVz dC9yZWdyZXNzL2V4cGVjdGVkL2JyaW4ub3V0CmluZGV4IGU1M2Q2ZTQ4ODU2Li5hZTRjNDI0ZTc5 ZiAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9icmluLm91dAorKysgYi9z cmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2JyaW4ub3V0CkBAIC00ODQsNyArNDg0LDcgQEAgRVJS T1I6ICBibG9jayBudW1iZXIgb3V0IG9mIHJhbmdlOiAtMQogU0VMRUNUIGJyaW5fc3VtbWFyaXpl X3JhbmdlKCdicmluX3N1bW1hcml6ZV9pZHgnLCA0Mjk0OTY3Mjk2KTsKIEVSUk9SOiAgYmxvY2sg bnVtYmVyIG91dCBvZiByYW5nZTogNDI5NDk2NzI5NgogLS0gdGVzdCB2YWx1ZSBtZXJnaW5nIGlu IGFkZF92YWx1ZQotQ1JFQVRFIFRBQkxFIGJyaW50ZXN0XzIgKG4gbnVtcmFuZ2UpOworQ1JFQVRF IFVOTE9HR0VEIFRBQkxFIGJyaW50ZXN0XzIgKG4gbnVtcmFuZ2UpOwogQ1JFQVRFIElOREVYIGJy aW5pZHhfMiBPTiBicmludGVzdF8yIFVTSU5HIGJyaW4gKG4pOwogSU5TRVJUIElOVE8gYnJpbnRl c3RfMiBWQUxVRVMgKCdlbXB0eScpOwogSU5TRVJUIElOVE8gYnJpbnRlc3RfMiBWQUxVRVMgKG51 bXJhbmdlKDAsIDJeMTAwMDo6bnVtZXJpYykpOwpkaWZmIC0tZ2l0IGEvc3JjL3Rlc3QvcmVncmVz cy9leHBlY3RlZC9naW4ub3V0IGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9naW4ub3V0Cmlu ZGV4IDY0MDJlODljN2ZmLi4xYTBjM2M2MTY3ZiAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVz cy9leHBlY3RlZC9naW4ub3V0CisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZ2luLm91 dApAQCAtNzQsNyArNzQsNyBAQCBzZWxlY3QgY291bnQoKikgPiAwIGFzIG9rIGZyb20gZ2luX3Rl c3RfdGJsIHdoZXJlIGkgQD4gYXJyYXlbMV07CiAKIHJlc2V0IGdpbl9mdXp6eV9zZWFyY2hfbGlt aXQ7CiAtLSBUZXN0IG9wdGltaXphdGlvbiBvZiBlbXB0eSBxdWVyaWVzCi1jcmVhdGUgdGVtcCB0 YWJsZSB0X2dpbl90ZXN0X3RibChpIGludDRbXSwgaiBpbnQ0W10pOworY3JlYXRlIHVubG9nZ2Vk IHRhYmxlIHRfZ2luX3Rlc3RfdGJsKGkgaW50NFtdLCBqIGludDRbXSk7CiBjcmVhdGUgaW5kZXgg b24gdF9naW5fdGVzdF90YmwgdXNpbmcgZ2luIChpLCBqKTsKIGluc2VydCBpbnRvIHRfZ2luX3Rl c3RfdGJsCiB2YWx1ZXMKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZ2lz dC5vdXQgYi9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2dpc3Qub3V0CmluZGV4IDkwZWRiNDA2 MWQ0Li5jMWFmODdmN2YzMiAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9n aXN0Lm91dAorKysgYi9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2dpc3Qub3V0CkBAIC0zNiw3 ICszNiw3IEBAIHJlaW5kZXggaW5kZXggZ2lzdF9wb2ludGlkeDsKIC0tCiAtLSBUZXN0IEluZGV4 LW9ubHkgcGxhbnMgb24gR2lTVCBpbmRleGVzCiAtLQotY3JlYXRlIHRhYmxlIGdpc3RfdGJsIChi IGJveCwgcCBwb2ludCwgYyBjaXJjbGUpOworY3JlYXRlIHVubG9nZ2VkIHRhYmxlIGdpc3RfdGJs IChiIGJveCwgcCBwb2ludCwgYyBjaXJjbGUpOwogaW5zZXJ0IGludG8gZ2lzdF90YmwKIHNlbGVj dCBib3gocG9pbnQoMC4wNSppLCAwLjA1KmkpLCBwb2ludCgwLjA1KmksIDAuMDUqaSkpLAogICAg ICAgIHBvaW50KDAuMDUqaSwgMC4wNSppKSwKZGlmZiAtLWdpdCBhL3NyYy90ZXN0L3JlZ3Jlc3Mv c3FsL2JyaW4uc3FsIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvYnJpbi5zcWwKaW5kZXggM2JkODY2 ZDk0N2EuLjMzYTMwZmNmNzc3IDEwMDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC9icmlu LnNxbAorKysgYi9zcmMvdGVzdC9yZWdyZXNzL3NxbC9icmluLnNxbApAQCAtNDQ5LDcgKzQ0OSw3 IEBAIFNFTEVDVCBicmluX3N1bW1hcml6ZV9yYW5nZSgnYnJpbl9zdW1tYXJpemVfaWR4JywgLTEp OwogU0VMRUNUIGJyaW5fc3VtbWFyaXplX3JhbmdlKCdicmluX3N1bW1hcml6ZV9pZHgnLCA0Mjk0 OTY3Mjk2KTsKIAogLS0gdGVzdCB2YWx1ZSBtZXJnaW5nIGluIGFkZF92YWx1ZQotQ1JFQVRFIFRB QkxFIGJyaW50ZXN0XzIgKG4gbnVtcmFuZ2UpOworQ1JFQVRFIFVOTE9HR0VEIFRBQkxFIGJyaW50 ZXN0XzIgKG4gbnVtcmFuZ2UpOwogQ1JFQVRFIElOREVYIGJyaW5pZHhfMiBPTiBicmludGVzdF8y IFVTSU5HIGJyaW4gKG4pOwogSU5TRVJUIElOVE8gYnJpbnRlc3RfMiBWQUxVRVMgKCdlbXB0eScp OwogSU5TRVJUIElOVE8gYnJpbnRlc3RfMiBWQUxVRVMgKG51bXJhbmdlKDAsIDJeMTAwMDo6bnVt ZXJpYykpOwpkaWZmIC0tZ2l0IGEvc3JjL3Rlc3QvcmVncmVzcy9zcWwvZ2luLnNxbCBiL3NyYy90 ZXN0L3JlZ3Jlc3Mvc3FsL2dpbi5zcWwKaW5kZXggNTE5NGFmY2MxZjUuLjc0Njg4MDkzN2JiIDEw MDY0NAotLS0gYS9zcmMvdGVzdC9yZWdyZXNzL3NxbC9naW4uc3FsCisrKyBiL3NyYy90ZXN0L3Jl Z3Jlc3Mvc3FsL2dpbi5zcWwKQEAgLTUyLDcgKzUyLDcgQEAgc2VsZWN0IGNvdW50KCopID4gMCBh cyBvayBmcm9tIGdpbl90ZXN0X3RibCB3aGVyZSBpIEA+IGFycmF5WzFdOwogcmVzZXQgZ2luX2Z1 enp5X3NlYXJjaF9saW1pdDsKIAogLS0gVGVzdCBvcHRpbWl6YXRpb24gb2YgZW1wdHkgcXVlcmll cwotY3JlYXRlIHRlbXAgdGFibGUgdF9naW5fdGVzdF90YmwoaSBpbnQ0W10sIGogaW50NFtdKTsK K2NyZWF0ZSB1bmxvZ2dlZCB0YWJsZSB0X2dpbl90ZXN0X3RibChpIGludDRbXSwgaiBpbnQ0W10p OwogY3JlYXRlIGluZGV4IG9uIHRfZ2luX3Rlc3RfdGJsIHVzaW5nIGdpbiAoaSwgaik7CiBpbnNl cnQgaW50byB0X2dpbl90ZXN0X3RibAogdmFsdWVzCmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdy ZXNzL3NxbC9naXN0LnNxbCBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2dpc3Quc3FsCmluZGV4IGI5 ZDM5OGVhOTQxLi4zODQ5YjY0OWEyYyAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9zcWwv Z2lzdC5zcWwKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvZ2lzdC5zcWwKQEAgLTQxLDcgKzQx LDcgQEAgcmVpbmRleCBpbmRleCBnaXN0X3BvaW50aWR4OwogLS0gVGVzdCBJbmRleC1vbmx5IHBs YW5zIG9uIEdpU1QgaW5kZXhlcwogLS0KIAotY3JlYXRlIHRhYmxlIGdpc3RfdGJsIChiIGJveCwg cCBwb2ludCwgYyBjaXJjbGUpOworY3JlYXRlIHVubG9nZ2VkIHRhYmxlIGdpc3RfdGJsIChiIGJv eCwgcCBwb2ludCwgYyBjaXJjbGUpOwogCiBpbnNlcnQgaW50byBnaXN0X3RibAogc2VsZWN0IGJv eChwb2ludCgwLjA1KmksIDAuMDUqaSksIHBvaW50KDAuMDUqaSwgMC4wNSppKSksCg== --000000000000e8796a05d1e660da--