Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e59qX-0001uK-2H for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Oct 2017 12:22:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e59qW-0004Sj-JO for pgsql-hackers@arkaria.postgresql.org; Thu, 19 Oct 2017 12:22:44 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e59ox-0001Bu-R4 for pgsql-hackers@postgresql.org; Thu, 19 Oct 2017 12:21:07 +0000 Received: from smtprelay0044.b.hostedemail.com ([64.98.42.44] helo=smtprelay.b.hostedemail.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e59on-0008Pi-2L for pgsql-hackers@postgresql.org; Thu, 19 Oct 2017 12:21:06 +0000 Received: from filter.hostedemail.com (10.5.19.248.rfc1918.com [10.5.19.248]) by smtprelay01.b.hostedemail.com (Postfix) with ESMTP id 972552D2A16; Thu, 19 Oct 2017 12:20:55 +0000 (UTC) X-Session-Marker: 616C76686572726540616C76682E6E6F2D69702E6F7267 X-Spam-Summary: 50,0,0,,d41d8cd98f00b204,alvherre@alvh.no-ip.org,:::::::,RULES_HIT:41:152:355:379:599:967:968:973:988:989:1260:1277:1311:1312:1313:1314:1345:1359:1437:1515:1516:1518:1519:1534:1541:1593:1594:1595:1596:1711:1730:1747:1777:1792:2393:2525:2560:2563:2682:2685:2692:2827:2859:2903:2933:2937:2939:2942:2945:2947:2951:2954:3022:3138:3139:3140:3141:3142:3353:3865:3866:3867:3868:3870:3871:3872:3873:3874:3934:3936:3938:3941:3944:3947:3950:3953:3956:3959:4250:4605:5007:6119:6261:9025:9121:10004:10400:10848:11232:11658:11783:11914:12663:12740:12895:13069:13311:13357:13894:13895:14764:21080:21434:21451:21627:30012:30030:30034:30054:30056:30062:30070,0,RBL:none,CacheIP:none,Bayesian:0.5,0.5,0.5,Netcheck:none,DomainCache:0,MSF:not bulk,SPF:,MSBL:0,DNSBL:none,Custom_rules:0:0:0,LFtime:5,LUA_SUMMARY:none X-HE-Tag: sea13_5f470e2f1f313 X-Filterd-Recvd-Size: 2375 Received: from alvin.alvh.no-ip.org (unknown [212.163.6.20]) (Authenticated sender: alvherre@alvh.no-ip.org) by omf14.b.hostedemail.com (Postfix) with ESMTPA; Thu, 19 Oct 2017 12:20:54 +0000 (UTC) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id BD711F57; Thu, 19 Oct 2017 14:20:52 +0200 (CEST) Date: Thu, 19 Oct 2017 14:20:52 +0200 From: Alvaro Herrera To: Nikolay Shaplov Cc: Michael Paquier , PostgreSQL mailing lists , Andres Freund Subject: Re: [PATCH] Tests for reloptions Message-ID: <20171019122052.f3cychhfktrfwqdk@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <1933219.021c0Pr2Ov@x200m> User-Agent: NeoMutt/20170306-137-4415bd-dirty (1.8.0) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Nikolay Shaplov wrote: > В письме от 3 октября 2017 11:48:43 пользователь Michael Paquier написал: > I've been thinking a lot, and rereading the patch. When I reread it I've been > thinking that I would like to add more tests to it now... ;-) > > If the only purpose of tests is to get better coverage, then I would agree > with you. But I've been thinking that tests also should check that everything > behaves as expected (or as written in documentation). > > I would say that options names is a of part of SQL dialect that postgres uses, > kind of part of the syntax. It is good to be sure that they still supported. > So I would add a test for every option heap supports. Yeah, it would perhaps be good idea to ensure we don't break things that are documented to work. If the tests don't take too long, I'm not opposed to testing every single option. As you say, code coverage is important but it's not the only goal. I'm hesitant to hardcode things like the number of bits in bloom, as you had in the original. If I understand correctly, that number could change with compile options (different blocksize?), so I removed that part. I also fixed a few spelling errors. And pushed. Let's see what the buildfarm says about this. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers