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 1seeOQ-00AB4g-Sf for pgsql-bugs@arkaria.postgresql.org; Thu, 15 Aug 2024 17:36:11 +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 1seeOP-000RHr-9k for pgsql-bugs@arkaria.postgresql.org; Thu, 15 Aug 2024 17:36:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1seFO9-00AzaD-AI for pgsql-bugs@lists.postgresql.org; Wed, 14 Aug 2024 14:54:13 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1seFO2-004pWp-7v for pgsql-bugs@lists.postgresql.org; Wed, 14 Aug 2024 14:54:12 +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=wMQZrzowzchJoC0FMbaXLFagH+kNGRFhipNFJiuxEhY=; b=MueHP40TNowcQYi514dEc4Tp88 bq5+n5Ge3u1B4i8sTsI5KpOFeLtZQTgFKVSYQtaqYLdHJkOwYwFeklh417Y7uYBIHEFozH24j5UgR 9r4obvm7KZHL5D9MyVpW7Wd+eT7607BUBkRfjxwtesSPWrju+XNn8tIw6Kx8GWHrK7z9ioIPiTavL pLhFWluJlhEH2/dTVPLIpvOT0zrjubwrURArXnPQAXhzHpu4QDAuGcEw79ODxjZxzN3scdd4w8SET fLRaHu5e5vz50P9975Nz1MhvVeGuvhdCf/M2WoY3lLmlDid9H+owp5+3JYybuweD2OHnAOIDTvchM qi2IxlVg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1seFO0-00EfvC-N4 for pgsql-bugs@lists.postgresql.org; Wed, 14 Aug 2024 14:54:04 +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 1seFNy-006jmV-3o for pgsql-bugs@lists.postgresql.org; Wed, 14 Aug 2024 14:54:02 +0000 Content-Type: multipart/mixed; boundary="===============2957725362451437295==" MIME-Version: 1.0 Subject: BUG #18583: jsonb_populate_record return values cannot be queried correctly in subselects To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: robert.j.greig@gmail.com Reply-To: robert.j.greig@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 14 Aug 2024 14:53:42 +0000 Message-ID: <18583-b8f0198539f29ccb@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 --===============2957725362451437295== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODU4MwpMb2dnZWQgYnk6ICAgICAgICAgIFJvYmVydCBHcmVpZwpFbWFp bCBhZGRyZXNzOiAgICAgIHJvYmVydC5qLmdyZWlnQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDE2LjQKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzCkRlc2NyaXB0aW9uOiAgICAgICAg CgpJIGhhdmUgY3JlYXRlZCBhIHNtYWxsIGV4YW1wbGUgdGhhdCBpbGx1c3RyYXRlcyB0aGlzIGlz c3VlLCBidXQgYmVmb3JlCmRlc2NyaWJpbmcgdGhhdCBsZXQgbWUgcHJvdmlkZSBhIGxpdHRsZSBt b3JlIGNvbnRleHQgd2hpY2ggd291bGQgbm90IGJlCm9idmlvdXMgZnJvbSB0aGUgZXhhbXBsZS4g VGhlIHJlYWwgdXNlIGNhc2UgaGVyZSBpcyB0aGF0IHdlIGhhdmUgYSBudW1iZXIgb2YKdGFibGVz IGNvbnRhaW5pbmcgc29tZSBjb2x1bW5zIHdpdGggdHlwZSBqc29uYi4gVGhlcmUgYXJlIHZpZXdz IHRoYXQgc2VsZWN0CmZyb20gdGhvc2UgdGFibGVzIGFuZCB1c2UganNvbmJfcG9wdWxhdGVfcmVj b3JkIHRvIHBvcHVsYXRlIGN1c3RvbSB0eXBlcwpmcm9tIHRoZSBKU09OLiBGb3IgZXhhbXBsZToN Cg0KQ1JFQVRFIFRBQkxFIHQxIEFTIChpZCB2YXJjaGFyKDIwKSwgc29tZV9kYXRhIGpzb25iKTsN CkNSRUFURSBWSUVXIHYxIEFTIFNFTEVDVCBpZCwganNvbmJfcG9wdWxhdGUobnVsbDo6c29tZV90 eXBlLCBzb21lZGF0YSkgQVMKZGF0YSBGUk9NIHQxOw0KDQpIb3dldmVyIHRoaXMgd2FzIG5vdCB3 b3JraW5nIGluIHNvbWUgY2lyY3Vtc3RhbmNlcyB3aGVyZSByb3dzIHRoYXQgY29udGFpbmVkCm5v bi1udWxsIHZhbHVlcyBpbiB0aGUgZGF0YSBjb2x1bW4gb2YgdGhlIHZpZXcgd2VyZSBub3QgYmVp bmcgcmV0dXJuZWQgYnkgYQpxdWVyeSBvZiB0aGUgZm9ybSBTRUxFQ1QgKiBGUk9NIHYxIFdIRVJF IGRhdGEgSVMgTk9UIE5VTEwuIEhvd2V2ZXIganVzdApydW5uaW5nIHRoZSBTRUxFQ1Qgc3RhdGVt ZW50IHdpdGhvdXQgYW55IFdIRVJFIGNsYXVzZSB5b3UgY291bGQgc2VlIHRoZSBkYXRhCndhcyBi ZWluZyByZXR1cm5lZC4NCg0KRnVydGhlciB0ZXN0aW5nIHNob3dlZCB0aGF0IHRoaXMgd2FzIGhh cHBlbmluZyB3aXRoIGFueSBzdWJzZWxlY3Qgbm90IGp1c3QKdmlld3MsIGFuZCB0aGF0IHRoZSBp c3N1ZSB3YXMgb2NjdXJyaW5nIHdoZW4gdGhlcmUgd2VyZSBhbnkgbnVsbCBvciBtaXNzaW5nCmVs ZW1lbnRzIGluIHRoZSBKU09OLiBUaGUgdHlwZSB3YXMgc3RpbGwgY29uc3RydWN0ZWQgYXMgZXhw ZWN0ZWQgYnV0IGZvcgpzb21lIHJlYXNvbiB0aGUgcXVlcnkgb24gaXQgd2FzIGZhaWxpbmcuDQoN CkkgYW0gc3VyZSB0aGlzIGlzIGFzIGNsZWFyIGFzIG11ZCBzbyBJIGhhdmUgcHV0IHRvZ2V0aGVy IGEgdmVyeSBzaW1wbGUgdGVzdApjYXNlIHRoYXQgaWxsdXN0cmF0ZXMgdGhlIGlzc3VlLg0KDQpj cmVhdGUgdHlwZSB0ZXN0X3NpbXBsZV90eXBlIGFzICgNCglmMSB2YXJjaGFyKDIwKSwNCglmMiBp bnQNCik7DQoNCnNlbGVjdA0KCSoNCmZyb20gKA0KCXZhbHVlcw0KCQkoMTAsIChqc29uYl9wb3B1 bGF0ZV9yZWNvcmQobnVsbDo6dGVzdF9zaW1wbGVfdHlwZSwgJ3siZjEiOiAiYmFuYW5hIiwKImYy IjogNDR9Jyk6OnRlc3Rfc2ltcGxlX3R5cGUpKSwNCgkJKDExLCAoanNvbmJfcG9wdWxhdGVfcmVj b3JkKG51bGw6OnRlc3Rfc2ltcGxlX3R5cGUsICd7ImYxIjogInBlYXIiLCAiZjIiOgpudWxsfScp Ojp0ZXN0X3NpbXBsZV90eXBlKSksDQoJCSgxMiwgKGpzb25iX3BvcHVsYXRlX3JlY29yZChudWxs Ojp0ZXN0X3NpbXBsZV90eXBlLCAneyJmMSI6CiJzdHJhd2JlcnJ5In0nKTo6dGVzdF9zaW1wbGVf dHlwZSkpLA0KCQkoMTMsIG51bGwpDQopIHgoa2V5LCB2YWwpOw0KDQpzZWxlY3QNCgkqDQpmcm9t ICgNCgl2YWx1ZXMNCgkJKDEwLCAoanNvbmJfcG9wdWxhdGVfcmVjb3JkKG51bGw6OnRlc3Rfc2lt cGxlX3R5cGUsICd7ImYxIjogImJhbmFuYSIsCiJmMiI6IDQ0fScpOjp0ZXN0X3NpbXBsZV90eXBl KSksDQoJCSgxMSwgKGpzb25iX3BvcHVsYXRlX3JlY29yZChudWxsOjp0ZXN0X3NpbXBsZV90eXBl LCAneyJmMSI6ICJwZWFyIiwgImYyIjoKbnVsbH0nKTo6dGVzdF9zaW1wbGVfdHlwZSkpLA0KCQko MTIsIChqc29uYl9wb3B1bGF0ZV9yZWNvcmQobnVsbDo6dGVzdF9zaW1wbGVfdHlwZSwgJ3siZjEi Ogoic3RyYXdiZXJyeSJ9Jyk6OnRlc3Rfc2ltcGxlX3R5cGUpKSwNCgkJKDEzLCBudWxsKQ0KKSB4 KGtleSwgdmFsKQ0Kd2hlcmUgdmFsIGlzIG5vdCBudWxsOw0KDQpJZiB5b3UgcnVuIHRoZSBmaXJz dCBxdWVyeSBhYm92ZSwgeW91IGNhbiBzZWUgdGhhdCB0aGUgdmFsIGNvbHVtbiBpcwpjb3JyZWN0 bHkgcG9wdWxhdGVkIGZvciB0aGUgcm93cyB3aXRoIGtleSAxMCwgMTEgYW5kIDEyLiBIb3dldmVy IGlmIHlvdSBydW4KdGhlIHNlY29uZCBxdWVyeSBvbmx5IG9uZSByb3cgaXMgcmV0dXJuZWQgd2hl cmVhcyB0aGUgZXhwZWN0ZWQgb3V0cHV0IGlzCnRocmVlIHJvd3MgKHdpdGgga2V5cyAxMCwgMTEg YW5kIDEyKS4NCg0KSXQgaXMgbm90IG9idmlvdXMgdG8gbWUgd2h5IGl0IGlzIG5vdCB3b3JraW5n IGJ1dCBJIGJlbGlldmUgdGhpcyBpcyBhIGRlZmVjdAphbmQgSSBjYW4ndCBmaW5kIGEgd29ya2Fy b3VuZC4NCg0KVGhhbmtzLA0KUm9iZXJ0Cgo= --===============2957725362451437295==--