Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rcspd-002fgL-7H for pgsql-bugs@arkaria.postgresql.org; Wed, 21 Feb 2024 20:04:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rcspa-006Gj7-OE for pgsql-bugs@arkaria.postgresql.org; Wed, 21 Feb 2024 20:04:39 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rcs2l-005yGL-8z for pgsql-bugs@lists.postgresql.org; Wed, 21 Feb 2024 19:14:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rcs2f-000JLj-EF for pgsql-bugs@lists.postgresql.org; Wed, 21 Feb 2024 19:14:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=ZqnU/Im1nVqV9tz/BQhO+od275jBlK65aZiyU2QqeTI=; b=25ZMQGPSq7r6ophXivBnbgI1Fx BkcDolLcRK/7C85+/l/he4RMLvdAiBOjaerQWLBv5uCg2jdt8BndzHzllCeMra1S4uHS79y17bGuy IOd8mfAqOOJ/H6bj3rwM+zpOGWOY7uUbs6lMfSHX4KK0suA+vKw5EoqmB80RTh0s4NMHs2E06VFVF HCsV8ldNmptyCuaInHr55wudkxzg0giw2xSuhxyGw9T4NvjMQAG/WYh6HeUusTyd3yuczw3Y2l+yf 8tMTUNwirFoGlvZGxJBVY+rTLlRTLJJlLIRgcYs9zU9WdiENBArRr1zB9lsF9K6d443MnBQidRlko GIbqLf3g==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rcs2f-000cod-EL for pgsql-bugs@lists.postgresql.org; Wed, 21 Feb 2024 19:14:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rcs2b-001aKg-W1 for pgsql-bugs@lists.postgresql.org; Wed, 21 Feb 2024 19:14:02 +0000 Content-Type: multipart/mixed; boundary="===============3196006287231658672==" MIME-Version: 1.0 Subject: BUG #18356: Casting values from jsonb_each_text does not respect WHERE filter with sub select To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ewherrmann@gmail.com Reply-To: ewherrmann@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 21 Feb 2024 19:13:24 +0000 Message-ID: <18356-a811d014209fd19c@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3196006287231658672== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODM1NgpMb2dnZWQgYnk6ICAgICAgICAgIEVkIEhlcnJtYW5uCkVtYWls IGFkZHJlc3M6ICAgICAgZXdoZXJybWFubkBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx Ni4wCk9wZXJhdGluZyBzeXN0ZW06ICAgTGludXgsIE1hY09TCkRlc2NyaXB0aW9uOiAgICAgICAg CgotIFByaW9yIHRvIHYxNiwgdGhpcyBzdGF0ZW1lbnQgd291bGQgd29yayBmb3IgY2FzdGluZyB2 YWx1ZXMgb2YgYSBrL3YganNvbmIKcGFpciB0byBhbiBpbnRlZ2VyOg0KICAgICAgICAgICAgICAg ICAgICBTRUxFQ1QgaWQsIG15dGRhdGEua2V5LCBteXRkYXRhLnZhbHVlOjppbnRlZ2VyDQogICAg ICAgICAgICAgICAgICAgIEZST00gbXlfdGFibGUgYXMgbXl0LA0KICAgICAgICAgICAgICAgICAg ICAgICAganNvbmJfZWFjaF90ZXh0KG15dC5kYXRhKSBhcyBteXRkYXRhDQogICAgICAgICAgICAg ICAgICAgIFdIRVJFIG15dGRhdGEua2V5IElOICggU0VMRUNUIGtleSBmcm9tIHdlZWtfa2V5X3Rh YmxlCikNCg0KLSBXaGVyZSB3ZWVrX2tleV90YWJsZSBzdG9yZXMga2V5cyBzdWNoIGFzICJ3ZWVr MDEiLCAid2VlazAyIiwgYW5kCiJ3ZWVrMDMiLg0KLSBBbmQgd2hlcmUgdGhlIGpzb25iIGhhcyBz b21lIGtleXMgd2l0aCBhbHBoYW51bWVyaWMgdmFsdWVzIGFuZCBzb21lIGtleXMKd2l0aCBudW1l cmljIHZhbHVlcywgc3VjaCBhczogeyAia2V5X2ZpZ3VyZSI6ICJWb2x1bWUiLCAid2VlazAxIjog IjAiLAoid2VlazAyIjogIjAiLCAid2VlazAzIjogIjAifQ0KDQpIb3dldmVyIGFzIG9mIHYxNiwg dGhpcyBzYW1lIHN0YXRlbWVudCBjYXVzZXMgdGhlIGVycm9yOiAnaW52YWxpZCBpbnB1dApzeW50 YXggZm9yIHR5cGUgZG91YmxlIHByZWNpc2lvbjogIlZvbHVtZSInLiANCg0KSWYgdGhlIGtleXMg YXJlIHNwZWNpZmllZCBkaXJlY3RseSwgaXQgd2lsbCBzdGlsbCB3b3JrIGFzIG5vcm1hbCwgYnV0 IHRob3dzCnRoZSBjYXN0aW5nIGVycm9yIHdoZW4gdGhlIGtleXMgYXJlIGJlaW5nIHNlbGVjdGVk IGZyb20gYW5vdGhlciB0YWJsZS4NCg0KV29ya3M6DQogICAgICAgICAgICAgICAgICAgIFNFTEVD VCBpZCwgbXl0ZGF0YS5rZXksIG15dGRhdGEudmFsdWU6OmludGVnZXINCiAgICAgICAgICAgICAg ICAgICAgRlJPTSBteV90YWJsZSBhcyBteXQsDQogICAgICAgICAgICAgICAgICAgICAgICBqc29u Yl9lYWNoX3RleHQobXl0LmRhdGEpIGFzIG15dGRhdGENCiAgICAgICAgICAgICAgICAgICAgV0hF UkUgbXl0ZGF0YS5rZXkgSU4gKCAid2VlazAxIiwgIndlZWswMiIsICJ3ZWVrMDMiICkNCkNhc3Rp bmcgRXJyb3I6DQogICAgICAgICAgICAgICAgICAgIFNFTEVDVCBpZCwgbXl0ZGF0YS5rZXksIG15 dGRhdGEudmFsdWU6OmludGVnZXINCiAgICAgICAgICAgICAgICAgICAgRlJPTSBteV90YWJsZSBh cyBteXQsDQogICAgICAgICAgICAgICAgICAgICAgICBqc29uYl9lYWNoX3RleHQobXl0LmRhdGEp IGFzIG15dGRhdGENCiAgICAgICAgICAgICAgICAgICAgV0hFUkUgbXl0ZGF0YS5rZXkgSU4gKCBT RUxFQ1Qga2V5IGZyb20gd2Vla19rZXlfdGFibGUgKQoK --===============3196006287231658672==--