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 1p4qBc-0007ky-UE for pgsql-committers@arkaria.postgresql.org; Mon, 12 Dec 2022 21:18:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p4qBb-0008TA-IZ for pgsql-committers@arkaria.postgresql.org; Mon, 12 Dec 2022 21:18:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p4qBb-0008T0-Bf for pgsql-committers@lists.postgresql.org; Mon, 12 Dec 2022 21:18:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p4qBY-0002tk-UB for pgsql-committers@lists.postgresql.org; Mon, 12 Dec 2022 21:18:06 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p4qBX-0004JB-04 for pgsql-committers@lists.postgresql.org; Mon, 12 Dec 2022 21:18:03 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1p4qBV-003GQG-DN for pgsql-committers@lists.postgresql.org; Mon, 12 Dec 2022 21:18:02 +0000 Content-Type: multipart/mixed; boundary="===============6455518602737407212==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix jsonb subscripting to cope with toasted subscript values. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 12 Dec 2022 21:18:02 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6455518602737407212== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGpzb25iIHN1YnNjcmlwdGluZyB0byBjb3BlIHdpdGggdG9hc3RlZCBzdWJzY3JpcHQgdmFs dWVzLgoKanNvbmJfZ2V0X2VsZW1lbnQoKSB3YXMgaW5jYXV0aW91cyBlbm91Z2ggdG8gdXNlIFZB UkRBVEEoKSBhbmQKVkFSU0laRSgpIGRpcmVjdGx5IG9uIGFuIGFyYml0cmFyeSB0ZXh0IERhdHVt LiAgVGhhdCBvZiBjb3Vyc2UKZmFpbHMgaWYgdGhlIERhdHVtIGlzIHNob3J0LWhlYWRlciwgY29t cHJlc3NlZCwgb3Igb3V0LW9mLWxpbmUuClRoZSB0eXBpY2FsIHJlc3VsdCB3b3VsZCBiZSBmYWls aW5nIHRvIG1hdGNoIGFueSBlbGVtZW50IG9mIGEKanNvbmIgb2JqZWN0LCB0aG91Z2ggbWF0Y2hp bmcgdGhlIHdyb25nIG9uZSBzZWVtcyBwb3NzaWJsZSBhcyB3ZWxsLgoKc2V0UGF0aE9iamVjdCgp IHdhcyBzbGlnaHRseSBicmlnaHRlciwgaW4gdGhhdCBpdCB1c2VkIFZBUkRBVEFfQU5ZCmFuZCBW QVJTSVpFX0FOWV9FWEhEUiwgYnV0IHRoYXQgb25seSBrZXB0IGl0IG91dCBvZiB0cm91YmxlIGZv cgpzaG9ydC1oZWFkZXIgRGF0dW1zLiAgcHVzaF9wYXRoKCkgaGFkIHRoZSBzYW1lIGlzc3VlLiAg VGhpcyBjb3VsZApyZXN1bHQgaW4gZmF1bHR5IHN1YnNjcmlwdGVkIGluc2VydGlvbnMsIHRob3Vn aCBrZXlzIGxvbmcgZW5vdWdoIHRvCmNhdXNlIGEgcHJvYmxlbSBhcmUgbGlrZWx5IHJhcmUgaW4g dGhlIHdpbGQuCgpIYXZpbmcgc2VlbiB0aGVzZSwgSSBsb29rZWQgYXJvdW5kIGZvciB1bnNhZmUg dXNhZ2VzIGluIHRoZSByZXN0Cm9mIHRoZSBhZHQvanNvbiogZmlsZXMuICBUaGVyZSBhcmUgYSBj b3VwbGUgb2YgcGxhY2VzIHdoZXJlIGl0J3Mgbm90CmltbWVkaWF0ZWx5IG9idmlvdXMgdGhhdCB0 aGUgRGF0dW0gY2FuJ3QgYmUgY29tcHJlc3NlZCBvciBvdXQtb2YtbGluZSwKc28gSSBhZGRlZCBw Z19kZXRvYXN0X2RhdHVtX3BhY2tlZCgpIHRvIGNvcGUgaWYgaXQgaXMuICBBbHNvLCByZW1vdmUK c29tZSBvdGhlciB1c2FnZXMgb2YgVkFSREFUQS9WQVJTSVpFIG9uIERhdHVtcyB3ZSBqdXN0IGV4 dHJhY3RlZCBmcm9tCmEgdGV4dCBhcnJheS4gIFRob3NlIGFyZW4ndCBhY3RpdmVseSBicm9rZW4s IGJ1dCB0aGV5IHdpbGwgYmVjb21lIHNvCmlmIHdlIGV2ZXIgc3RhcnQgYWxsb3dpbmcgc2hvcnQt aGVhZGVyIGFycmF5IGVsZW1lbnRzLCB3aGljaCBkb2VzIG5vdApzZWVtIGxpa2UgYSB0ZXJyaWJs eSB1bnJlYXNvbmFibGUgdGhpbmcgdG8gZG8uICBJbiBhbnkgY2FzZSB0aGV5IGFyZQpub3QgZ3Jl YXQgY29kaW5nIGV4YW1wbGVzLCBhbmQgdGhleSBjb3VsZCBhbHNvIGRvIHdpdGggY29tbWVudHMK cG9pbnRpbmcgb3V0IHRoYXQgd2UncmUgYXNzdW1pbmcgd2UgZG9uJ3QgbmVlZCBwZ19kZXRvYXN0 X2RhdHVtX3BhY2tlZC4KClBlciByZXBvcnQgZnJvbSBleGUtZGVhbGVyQHlhbmRleC5ydS4gIFBh dGNoIGJ5IG1lLCBidXQgdGhhbmtzIHRvCkRhdmlkIEpvaG5zdG9uIGZvciBpbml0aWFsIGludmVz dGlnYXRpb24uICBCYWNrLXBhdGNoIHRvIHYxNCB3aGVyZQpqc29uYiBzdWJzY3JpcHRpbmcgd2Fz IGludHJvZHVjZWQuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzIwNTMyMTY3MDYx NTk1M0BtYWlsLnlhbmRleC5ydQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0t LQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2IwZmVkYTc5ZmRmMDI3 MTBhNjAzOWEzMjQyOTk1MjU4NDVhNGE5ZDQKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0t CnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9qc29uYl9naW4uYyAgIHwgIDUgKysrLS0Kc3JjL2JhY2tl bmQvdXRpbHMvYWR0L2pzb25iX29wLmMgICAgfCAxMCArKysrKy0tLS0Kc3JjL2JhY2tlbmQvdXRp bHMvYWR0L2pzb25mdW5jcy5jICAgfCA0MSArKysrKysrKysrKysrKysrKysrKysrKysrKy0tLS0t LS0tLS0tCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvanNvbmIub3V0IHwgMzQgKysrKysrKysr KysrKysrKysrKysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2pzb25iLnNxbCAgICAg IHwgMTggKysrKysrKysrKysrKysrKwo1IGZpbGVzIGNoYW5nZWQsIDkwIGluc2VydGlvbnMoKyks IDE4IGRlbGV0aW9ucygtKQoK --===============6455518602737407212==--