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 1n4OWG-0008Au-6x for pgsql-hackers@arkaria.postgresql.org; Mon, 03 Jan 2022 14:41:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n4OWF-0000xR-32 for pgsql-hackers@arkaria.postgresql.org; Mon, 03 Jan 2022 14:41:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n4OWE-0000xH-M1 for pgsql-hackers@lists.postgresql.org; Mon, 03 Jan 2022 14:41:02 +0000 Received: from mail-io1-xd33.google.com ([2607:f8b0:4864:20::d33]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1n4OWC-0003Y3-4Y for pgsql-hackers@postgresql.org; Mon, 03 Jan 2022 14:41:02 +0000 Received: by mail-io1-xd33.google.com with SMTP id q5so40547846ioj.7 for ; Mon, 03 Jan 2022 06:40:59 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20210112.gappssmtp.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=5WdQMTB1/09+bSUFei+H1Use8+GOaRaysXWMeoow85Y=; b=rHRb5cCW7djrxNeksY0Y4vJT1ZA3PAxULW2OZl5mFTdXdGtvuVZzh4s9K20Pv9tUyf I4CQzAxh/mHU3bcKR25dtPXo8P9YSuVCs5YxZHUR730lJe56wff2zHIO0qZ3cWYMNvTT fo69xO9q4QiiRB6z/LEUE78/OQNumym7R/Tu6yTpsK+hdomWR7ciPuJ51W02UWgDGE3Q pSxqGarWatBv4xQ9dfmQF30V/AaPuoy/rkTwcZBVPFM8kY33dXhRaoP2AbOATtkK46BX J6EZ8xCQpXKSGHKMwlSpjuITjrxt3c7QSlV/N3FhxbLN0ml1+PmxPOicx7L3emcmnO+I +/EA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=5WdQMTB1/09+bSUFei+H1Use8+GOaRaysXWMeoow85Y=; b=SQTFmcKGHyx3Jg/vzzhm8Xu1s6WIv4Cx2jYBthGDZbX6olApUQkIuoVoEbBTxh7w4/ C7UEUF9P4VumEJQsHnXQEcQCA83q6x0xg3X3xuU6dERp9QboZtxqb8HZWpd6QaougOAL MwBHbEdIPzFggrEfuBC+OM2PB7rq17xRSovnNkC3QsuiCQ9B4bI3jkf6RyjBHp4L72cU FOeuyL2FWSY0lGCfGHFV+tg+4odqBXUZOgR8r54EMm8IVdsQ3Qob0D5xSCmufA/b/b6k +Fd5hP9QWnfCue4XwPKeH4KATxqVR1YYshNm3iJX3xmNqRL8xMEK412qQcqM/c4hZ/4a zbJg== X-Gm-Message-State: AOAM532JnxzdFeYRIrg51gac6LolqJy3AMOQG7cq5c819b9F9VaBnJHj iz/604EQW3ZsN3dfWrGl+yPlGQ== X-Google-Smtp-Source: ABdhPJw9K0qjXtMZ2WOhgco2m2cFc5FRZoaEVP8e3fa8GwIqVsndZpWrm+PuZP3LniIQDFjCZlr+1Q== X-Received: by 2002:a05:6638:1688:: with SMTP id f8mr19180625jat.113.1641220858408; Mon, 03 Jan 2022 06:40:58 -0800 (PST) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id u14sm20968948ill.70.2022.01.03.06.40.57 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 03 Jan 2022 06:40:58 -0800 (PST) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 1F7CE804818; Mon, 3 Jan 2022 08:40:57 -0600 (CST) Date: Mon, 3 Jan 2022 08:40:57 -0600 From: Justin Pryzby To: Alvaro Herrera Cc: Tomas Vondra , Amit Kapila , Peter Eisentraut , "houzj.fnst@fujitsu.com" , Rahila Syed , Peter Smith , pgsql-hackers@postgresql.org Subject: Re: Column Filtering in Logical Replication Message-ID: <20220103144056.GB24477@telsasoft.com> References: <20211231163227.GV24477@telsasoft.com> <202201031431.akwhcx6xrusu@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <202201031431.akwhcx6xrusu@alvherre.pgsql> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Jan 03, 2022 at 11:31:39AM -0300, Alvaro Herrera wrote: > > Did the DatumGetBool issue expose a deficiency in testing ? > > I think the !am_partition path was never being hit. > > Hmm, the TAP test creates a subscription that contains both types of > tables. I tried adding an assert for each case, and they were both hit > on running the test. Yes, I know both paths are hit now that it uses GetBool. What I'm wondering is why tests didn't fail when one path wasn't hit - when it said am_partition=DatumGetChar(); if (!am_partition){} I suppose it's because the am_partition=true case correctly handles nonpartitions. Maybe the !am_partition case should be removed, and add a comment that pg_partition_tree(pg_partition_root(%u))) also handles non-partitions. Or maybe that's inefficient... -- Justin