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 1lvgfa-0003gH-RX for pgsql-bugs@arkaria.postgresql.org; Tue, 22 Jun 2021 13:42:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lvgfZ-0005OK-Om for pgsql-bugs@arkaria.postgresql.org; Tue, 22 Jun 2021 13:42:25 +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 1lvgfZ-0005OC-FN for pgsql-bugs@lists.postgresql.org; Tue, 22 Jun 2021 13:42:25 +0000 Received: from mail-qt1-x82b.google.com ([2607:f8b0:4864:20::82b]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lvgfX-0004M5-Cr for pgsql-bugs@lists.postgresql.org; Tue, 22 Jun 2021 13:42:24 +0000 Received: by mail-qt1-x82b.google.com with SMTP id d9so6597493qtx.8 for ; Tue, 22 Jun 2021 06:42:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:mime-version:content-disposition :content-transfer-encoding:in-reply-to; bh=ilB6R3G5/9dAJu7VdhPgIgU4uJRJMMZE1z+ZaNoXVds=; b=cqfReXjWjS3t2YBUupy8Nc4drMdlVT/7DU2+D1lZq4KAmbqy02vckmcVjnD56w86KP oVYVxew5Kudfpp2syBeKPvRd13fNP5Bq9WFO/bUcEmt7c0DJYdD3Hdmmp5pnmW+EdDAJ GrF72/tocTOyzuHCnz6OOgLY13QqCI/yPym9rvUC4iq9+42NNMuedSkwmIBswDUVMmqo kB6J3hPnD5u5n7P2U10H1lUs29fEpEWe/WHXP+wqiI+Qfqhx7ZRSfQYMZGV7urQfKLf2 nX7lcBLzTk1J+1u6BnKbF1aKVBI0VxLqVmHoiOCgVsCjGpUHZ2p8gvIv7Fy5wJE8IVBH LJLA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:mime-version :content-disposition:content-transfer-encoding:in-reply-to; bh=ilB6R3G5/9dAJu7VdhPgIgU4uJRJMMZE1z+ZaNoXVds=; b=CYFNCrTut2CJ1UFRi+SK/PIYa057b8q+PHtH8iVfjsQLrTiF6CFmWnSPHrbczBhoUk NiOjJaVVw6E8pYG3R1BOOz/Q2b8bXhoiNVrDXFCsneCOqXUNCKS/B5qxRhWsR2KMwB7g +yO7Jo19aKySHxLQrdNJ2AX92KoIX4+Bzwgb1Va49cKEMQhqa0mflgLxTUjq/TeLy6m6 ExL1Xcr2ZuSrnp9HStZ2pOvQJkMhXNuwbqRp17EDeZ+ngGbc8VOpa1PPjvkL3ve7X7Iv qTHqDyyu3MdaUAlfEe61Cb5LOxpLe4kgXqluU3Tm4abQBCHIVtv3Ik7SfkHhWeDLNado ly6g== X-Gm-Message-State: AOAM533Zc0wBLuytbxRZYBEizvb5ed3YUqPbeMikeA5LVUBYlqW/m+BU 26yV2q5uUqxhDtv+ex2mGqqNtA== X-Google-Smtp-Source: ABdhPJzNJxc0TJuhdhG5TJqLT+YJ0116htydDeOwShlIDBxF+kKH5ip2TwKaXp7sYxYheAbzQH054Q== X-Received: by 2002:ac8:568d:: with SMTP id h13mr3456035qta.123.1624369342034; Tue, 22 Jun 2021 06:42:22 -0700 (PDT) Received: from perhan.alvh.no-ip.org ([190.95.19.95]) by smtp.gmail.com with ESMTPSA id f13sm1684588qtx.3.2021.06.22.06.42.20 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 22 Jun 2021 06:42:20 -0700 (PDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id E37C92A0A6E; Tue, 22 Jun 2021 09:42:18 -0400 (-04) Date: Tue, 22 Jun 2021 09:42:18 -0400 From: Alvaro Herrera To: Neil Chen Cc: exclusion@gmail.com, pgsql-bugs@lists.postgresql.org, Alexander Korotkov , Paul A Jungwirth Subject: Re: BUG #17066: Cache lookup failed when null (unknown) is passed as anycompatiblemultirange Message-ID: <202106221342.lab2x5tvhcbs@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2021-Jun-22, Neil Chen wrote: > Greetings, > > I tried to investigate the bug, but the complicated logic here completely > messed up my mind... > > Anyway, this patch can fix it and make the regress test happy. But I think > it's better to get the author's advice - I copied this email to Alvaro, > hope it doesn't offend him... Without looking too deeply, the patch seems sensible to me. However, I'm CC'ing Alexander and Paul :-) -- Álvaro Herrera Valdivia, Chile