Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hoGaI-0005HZ-Lr for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Jul 2019 00:17:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hoGaH-0000FK-Gk for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Jul 2019 00:17:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hoGaH-0000FC-3x for pgsql-hackers@lists.postgresql.org; Fri, 19 Jul 2019 00:17:13 +0000 Received: from mail-pl1-x642.google.com ([2607:f8b0:4864:20::642]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hoGaE-00040O-7g for pgsql-hackers@lists.postgresql.org; Fri, 19 Jul 2019 00:17:12 +0000 Received: by mail-pl1-x642.google.com with SMTP id y8so14696777plr.12 for ; Thu, 18 Jul 2019 17:17:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:cc:date:in-reply-to:references :mime-version:content-transfer-encoding; bh=y/lh16QTQ0zlq4SODDt1Jh3BVgn7Y0b03l1D+/+I0W8=; b=zWudRXphtqvA2cn98cfJRf8bep9WBU2dVfUH6X4KBeXEZqi+qoEJQhHc4FLajEeEhj fBoLJW8n8ThyaDFHfv8SF3K3kp0mE5HDT/MB4ke14gcfMKL5Sik7DRda+v6QNYGw0zVw Mg3XOUZTBTSgjDn3hskPMt8xofxTwkuP5C9JCSfZj+3le0+yD2hpyb48yNwVZpr7Nl8I TDv74Lt5PVh4aFKDMiAGeI4jYCOhmtDGWCyCxJiGqBNS8s6o9e7Rtc8Koyt9gDPeYxla k2wlSOE60YlFS/PuOTLnhn0ZNcmz/jfFAfCt+BCk+GQMnIxmRmPrBXp7TkEgcDf53R1T JbFA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:cc:date:in-reply-to :references:mime-version:content-transfer-encoding; bh=y/lh16QTQ0zlq4SODDt1Jh3BVgn7Y0b03l1D+/+I0W8=; b=nG7xbcBVzMsVwx2wOTThpdvYBdesLdaTVNvbwFbXdx4EdEX4f2XRW8aw81cAx0qhiz Rxf/AlElDBHQLPKucIPl5sZn0FtKPcx+nUYHT+TMNvoh69vNoM9t85JBch+5Q35W/H6s S3Uxx5Rv2UTV23ekm2OBCnT9Il4XzIDv/GDfychqOHiyP2rUfK1ZF6/SVBo4kSd4JKoz 8t9xnvXOzvqU+lYJCy2Qz188kVxsiV6o3ijXC6DU/mxVDYZ0ZjSdJ4p6Sut5qDBQLBx3 0oD6N/qmIlKnlWUctmj5KfwrQkUaFjxBuiTBfyqTl+CI2chDbchrswuIb6g3zQOf65xg tX/w== X-Gm-Message-State: APjAAAUjZuNwg8Gjcrf75rauF5TJmDDwpySEq7b6yj9OBHtL2Jf8pZf+ IPcZdAelCqJ9/+CVx5mL75E= X-Google-Smtp-Source: APXvYqxi2z0Ge2L0w9vBuh+strYuKthReSXahJ/Xr+i9HPfP9eGDv8km/ojJ6e2t46ECwt1kE4Id6w== X-Received: by 2002:a17:902:ea:: with SMTP id a97mr52807717pla.182.1563495427175; Thu, 18 Jul 2019 17:17:07 -0700 (PDT) Received: from jdavis ([2600:1010:b009:3d3c:6928:26cf:9e29:4c86]) by smtp.gmail.com with ESMTPSA id g9sm21838640pgs.78.2019.07.18.17.17.05 (version=TLS1_2 cipher=ECDHE-RSA-CHACHA20-POLY1305 bits=256/256); Thu, 18 Jul 2019 17:17:06 -0700 (PDT) Message-ID: <263c516302e7afbd982b14f37629bc2601e15281.camel@j-davis.com> Subject: Re: Bad canonicalization for dateranges with 'infinity' bounds From: Jeff Davis To: Tom Lane Cc: Thomas Munro , Laurenz Albe , PostgreSQL Hackers Date: Thu, 18 Jul 2019 17:17:03 -0700 In-Reply-To: <16949.1563485795@sss.pgh.pa.us> References: <77f24ea19ab802bc9bc60ddbb8977ee2d646aec1.camel@cybertec.at> <539fbfe416eb3d7ebf72268eb839163a68aed9ef.camel@cybertec.at> <16949.1563485795@sss.pgh.pa.us> Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.28.5-0ubuntu0.18.04.1 Mime-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, 2019-07-18 at 17:36 -0400, Tom Lane wrote: > The commit message claims this was back-patched, but I see no back- > patch? Sorry, I noticed an issue after pushing: we were passing a datum directly to DATE_NOT_FINITE, when we should have called DatumGetDateADT() first. I ran through the tests again and now pushed to all branches. > (The commit message doesn't seem to have made it to the pgsql- > committers > list either, but that's probably an independent issue.) I was curious about that as well. Regards, Jeff Davis