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 1mOs9z-0005XI-Rf for pgsql-hackers@arkaria.postgresql.org; Sat, 11 Sep 2021 01:50:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mOs9y-0001Nm-Pg for pgsql-hackers@arkaria.postgresql.org; Sat, 11 Sep 2021 01:50:26 +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 1mOs9y-0001Ne-Dq for pgsql-hackers@lists.postgresql.org; Sat, 11 Sep 2021 01:50:26 +0000 Received: from mail-qk1-x72f.google.com ([2607:f8b0:4864:20::72f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mOs9v-0005Yo-TB for pgsql-hackers@lists.postgresql.org; Sat, 11 Sep 2021 01:50:25 +0000 Received: by mail-qk1-x72f.google.com with SMTP id a10so4127838qka.12 for ; Fri, 10 Sep 2021 18:50:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=systemguards-com-ec.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:content-transfer-encoding:in-reply-to :user-agent; bh=OvTrxy2pTNqT+SqqPcNE9sUt7VUTNYOmrto+X1apCyY=; b=gGJfMZfKkCQ1Dyn2B0Gt5ZOpbNSlSPD/vvvOSZhXx7r/Bznr45aWx4EwMtjxdA+oPW PsUAJX0yYcdbreHAUsmQGAc/cWaTWLktCuTAD2dv6O9RTKwM+Bvy41fErzB2tHe//lKN OfH+UN3BL5W+zDqqqYZ7sTUpyPss3gBCH3Dr4Yxw/1B8Nfz/KrttJf8WU6V3RN3QEbb6 jBhzAlxQvLJju9k9zbwMvURTGxoKm8paKobKzpEQmjdNU9I3kRwzuRkj9DOdLZMDRZG6 r+NOLYpP134ddpcWMtMErnUbMjjWvXfvmRTPj0JzdOV6ScxS4Ykr5Jd3G/CNRAGPu5aa ISRw== 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:content-transfer-encoding :in-reply-to:user-agent; bh=OvTrxy2pTNqT+SqqPcNE9sUt7VUTNYOmrto+X1apCyY=; b=mDOdIH938UVlG1bg4/JkeheF271aL4lrIOGx1QFeLxizOV08JvmNKQcnv8HQt4JSYw XUAuEZSiKWYtLk3G5ERb8l9EV3/sYLs+tzWEFqrlUVBTQs23J2UozdgfOJNYsZD6uxM2 LBfZ3sJeT1Wkn5wafTmsunXMpC6euVSvf0NJJJNcc+ET/RE8QEkA/ntL4EVNwIweE513 liZ4kGlE4glEloOp+o1S6jzlCDV0guz8gQdGj/Uh0WSH99aVc5SrSkAspUD2g2TZmvPN h/rSrL7AZj05bP+EreKp5uB0+v+PaggFsouWIHo5TCt4+KKASqet5MX7JnJuPsW+t6Wn J5qQ== X-Gm-Message-State: AOAM530J1WxMTiekkBRmuzqF7iHYBhC0XuUYCyKVtAmXuRoMI4wdK2Kn 7jJzlLGo8BLembr0z+v0x+cbnA== X-Google-Smtp-Source: ABdhPJzwNWEMhHgWjAAUG1zMM71bV1hpUqn2Ufh+6pAW51lwJ1BJvTHHqe33e5Dr61x+g/sr67tfBA== X-Received: by 2002:a37:a60f:: with SMTP id p15mr358393qke.377.1631325021688; Fri, 10 Sep 2021 18:50:21 -0700 (PDT) Received: from ahch-to ([201.183.0.184]) by smtp.gmail.com with ESMTPSA id o19sm253418qtv.85.2021.09.10.18.50.20 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 10 Sep 2021 18:50:21 -0700 (PDT) Date: Fri, 10 Sep 2021 20:50:17 -0500 From: Jaime Casanova To: Paul A Jungwirth Cc: PostgreSQL Hackers Subject: Re: SQL:2011 application time Message-ID: <20210911015017.GA8837@ahch-to> References: <20210904195556.GA10553@ahch-to> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Sep 06, 2021 at 12:52:37PM -0700, Paul A Jungwirth wrote: > On Sat, Sep 4, 2021 at 12:56 PM Jaime Casanova > wrote: > > > > patch 01: does apply but doesn't compile, attached the compile errors. > > patch 04: does not apply clean. > > Thanks for taking a look! I've rebased & made it compile again. v7 attached. > patch 01: does apply but gives a compile warning (which is fixed by patch 02) """ parse_utilcmd.c: In function ‘generateClonedIndexStmt’: parse_utilcmd.c:1730:2: warning: ISO C90 forbids mixed declarations and code [-Wdeclaration-after-statement] Period *p = makeNode(Period); ^~~~~~ """ patch 03: produces these compile errors. analyze.c: In function ‘transformForPortionOfBound’: analyze.c:1171:3: warning: ISO C90 forbids mixed declarations and code [-Wdeclaration-after-statement] A_Const *n2 = makeNode(A_Const); ^~~~~~~ analyze.c:1172:10: error: ‘union ValUnion’ has no member named ‘type’ n2->val.type = T_Null; ^ analyze.c:1172:18: error: ‘T_Null’ undeclared (first use in this function) n2->val.type = T_Null; ^~~~~~ analyze.c:1172:18: note: each undeclared identifier is reported only once for each function it appears in -- Jaime Casanova Director de Servicios Profesionales SystemGuards - Consultores de PostgreSQL