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 1lluPQ-0000GH-Dm for pgsql-bugs@arkaria.postgresql.org; Wed, 26 May 2021 14:21:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lluPO-0000PI-82 for pgsql-bugs@arkaria.postgresql.org; Wed, 26 May 2021 14:21:18 +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 1lluPN-0000P1-UQ for pgsql-bugs@lists.postgresql.org; Wed, 26 May 2021 14:21:18 +0000 Received: from mail-il1-x12f.google.com ([2607:f8b0:4864:20::12f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lluPH-0008I0-0H for pgsql-bugs@lists.postgresql.org; Wed, 26 May 2021 14:21:16 +0000 Received: by mail-il1-x12f.google.com with SMTP id h11so1018869ili.9 for ; Wed, 26 May 2021 07:21:10 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=LXb1qOlBtEyg14PmlPd+WEQdfEkcOtujWQYPsrgC4RU=; b=TCs5Uoh3QspVjMtsOBtjwgJa8I1h/XnRjBc7xQy0PS87pVqVLvpr7vZBtGnhoMIg5d Qo0NvDbjfChRRtDGlxJKz6i4lv0i1z04sD76l/HvqMu1TuaXbNyV1nGPQilOGns1a+jJ RiXqc2c/714O4XgdXnqnww3qKa7TjuMN16HLyHajAa6SrBx48qBsx28a/fNKZN7E1ALG OQB6P9ObBzB9dTCe/8hiG4yk89duvy83DyghdOYss89GCpbGoUmuAdRmU03m568QXihZ Wp+tXUq91aHzvLoxSI+QuPlwvK8n3yR1Xlh/KZaUcKxHklwlkoAINugxQzOr9eMpqTuM TGQQ== 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:references :mime-version:content-disposition:in-reply-to:user-agent; bh=LXb1qOlBtEyg14PmlPd+WEQdfEkcOtujWQYPsrgC4RU=; b=YMk7LRGvZtTi2OcPs4fbW47zf95UzHCFm9t4oxVCKAIRtveIusBu2rWOuwgejtSNKd 0KV37togdph8jhpkEZWAqEGkUI90ZZsix/9u0NoUXAAy0OnSaM2wi36WQk8oTrxUc3D8 QrGb/hrLKgv1w7M2Ippvi1+jhLQ2CsdHyyqAgkRVy60c0EuXE+aR1WlVML9vQYJ5xDZc Oq7+MM9IaxTAUSkuL41/Nuln5g6rzEpM5g5CXoyCqXALRfT6tWpDSNSnxyINeRwfVRHA pAColuadgJrlCWqCMuck6d205URlRgwSwMXk2Es/ztTWEwPliu2U4HXkr7lbNo6vba24 MeIQ== X-Gm-Message-State: AOAM533FWBPcbBeiRZtzEhpqvKDJWwsXJiTcjoOH8QlGsqM0JI8Qk1q1 1UMOJbt+XPFFhKW/M4fkFBDFDA== X-Google-Smtp-Source: ABdhPJxVPZpo/QhQZOmrH/qmzPtv41iJLzhg4MeJIz98ungUFfR7dURU1dA0HERv0auJ7JxWNeec4w== X-Received: by 2002:a05:6e02:130f:: with SMTP id g15mr19506894ilr.73.1622038870205; Wed, 26 May 2021 07:21:10 -0700 (PDT) Received: from pryzbyj.telsasoft (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id v2sm14609083ioh.14.2021.05.26.07.21.09 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 26 May 2021 07:21:09 -0700 (PDT) Received: by pryzbyj.telsasoft (Postfix, from userid 1000) id 470AC800A39; Wed, 26 May 2021 09:21:08 -0500 (CDT) Date: Wed, 26 May 2021 09:21:08 -0500 From: Justin Pryzby To: Dmitry Dolgov <9erthalion6@gmail.com> Cc: "Poot, Bas (B.J.)" , pgsql-bugs@lists.postgresql.org, Tomas Vondra Subject: Re: XX000: unknown type of jsonb container. Message-ID: <20210526142108.GJ3676@telsasoft.com> References: <534fca83789c4a378c7de379e9067d4f@politie.nl> <20210407181105.lmi7hgifwzs3eeee@localhost> <20210413161500.kufk4iyrmcmhhbrc@localhost> <20210423151505.lxx5ti7ivcza3xqw@localhost> <20210526135049.afseg47jmnqirqge@localhost> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20210526135049.afseg47jmnqirqge@localhost> 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 Wed, May 26, 2021 at 03:50:49PM +0200, Dmitry Dolgov wrote: > Almost forgot about this one. It seems that the issue still could be > reproduced on the latest master branch, so probably worth an open item. If I understand correctly, this should be an "Older bug affecting stable branches", rather than an "Open Issues" for v14. https://www.postgresql.org/message-id/20210413161500.kufk4iyrmcmhhbrc%40localhost >* It seems that technically the regression was introduced in > ea190ed14b, but not directly, via using gather paths in more > situations. +Tomas, since you mentioned his commit. -- Justin