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 1ugmDu-007EwH-IE for pgsql-bugs@arkaria.postgresql.org; Tue, 29 Jul 2025 15:26:39 +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 1ugmDt-002RpB-Hd for pgsql-bugs@arkaria.postgresql.org; Tue, 29 Jul 2025 15:26:37 +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 1ugkoL-001fBV-0c for pgsql-bugs@lists.postgresql.org; Tue, 29 Jul 2025 13:56:09 +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.96) (envelope-from ) id 1ugkoH-001OL8-12 for pgsql-bugs@lists.postgresql.org; Tue, 29 Jul 2025 13:56:08 +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=TPS2zL5Ye6cUC2e0UpV2Q0UhD8BK+fRf8ArTNr9iXDk=; b=O8Q1YyKtDqMnHLTazL/o0KS361 d+E3hoSA6LB3az/jqFr43GsPNcVxcutP6QokAlGPMzHIYG2lwzHQenuDNNXyBUB6329HWqNzs2x1r J5eobvy52pOIjhcZyUjRlHgkRurUtCJVl9NBKWxI+qgooR3ZS4b068xOxF/DI4+Jgfm6FLGq4dE5m geTY03VA+BRLlJtglSLC9D2kOxIXJwqw7sO/iQ0ImsTPB7sxvjb68qbznR5xhLwrTbajqlMYZB2TP R+tzd0yXlnv12Ypd51YohnsY4PAq/FR543lUpJ/3hBI62jNJg9yRXuFntV+YHCsmcg9bWBkR5UyXL geNIfgcQ==; 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 1ugkoE-003vOT-VG for pgsql-bugs@lists.postgresql.org; Tue, 29 Jul 2025 13:56:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1ugkoE-006bR7-24 for pgsql-bugs@lists.postgresql.org; Tue, 29 Jul 2025 13:56:02 +0000 Content-Type: multipart/mixed; boundary="===============4711013798658039695==" MIME-Version: 1.0 Subject: BUG #19001: PostgreSQL 17: CREATE MATERIALIZED VIEW fails with STABLE function using JSONB LATERAL joins To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: cgopal@onezero.com Reply-To: cgopal@onezero.com, pgsql-bugs@lists.postgresql.org Date: Tue, 29 Jul 2025 13:55:07 +0000 Message-ID: <19001-efdb4ac1eaddc5b8@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 --===============4711013798658039695== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTAwMQpMb2dnZWQgYnk6ICAgICAgICAgIENhbGViIEdvcGFsCkVtYWls IGFkZHJlc3M6ICAgICAgY2dvcGFsQG9uZXplcm8uY29tClBvc3RncmVTUUwgdmVyc2lvbjogMTcu NQpPcGVyYXRpbmcgc3lzdGVtOiAgIERlYmlhbiAoRG9ja2VyIC0gcG9zdGdyZXM6bGF0ZXN0KSBv biBXU0wyIC8gV2luZG93CkRlc2NyaXB0aW9uOiAgICAgICAgCgpJbiBQb3N0Z3JlU1FMIDE3LCBJ 4oCZbSBlbmNvdW50ZXJpbmcgYW4gZXJyb3Igd2hlbiBjcmVhdGluZyBhIE1BVEVSSUFMSVpFRApW SUVXIHRoYXQgdXNlcyBhIFNUQUJMRSBmdW5jdGlvbiByZXR1cm5pbmcganNvbmIsIGZvbGxvd2Vk IGJ5IExBVEVSQUwgam9pbnMKdXNpbmcganNvbmJfZWFjaCgpIGFuZCBqc29uYl90b19yZWNvcmQo KS4KClRoZSB2aWV3IGNyZWF0aW9uIGZhaWxzIHdpdGg6CkVSUk9SOiAgcmVsYXRpb24gInRlc3Rf dGFibGUiIGRvZXMgbm90IGV4aXN0CgpIb3dldmVyLCB0aGUgcmVmZXJlbmNlZCB0YWJsZSBkb2Vz IGV4aXN0LCBhbmQgdGhlIGZ1bmN0aW9uIHVzZWQgaW4gdGhlIHZpZXcKY3JlYXRpb24gcnVucyBm aW5lIHN0YW5kYWxvbmUuCgpUaGUgc2FtZSB2aWV3IGRlZmluaXRpb24gd29ya3MgY29ycmVjdGx5 IGluIFBvc3RncmVTUUwgMTMsIGFuZCB0aGUgZnVuY3Rpb24KaGFzIGJlZW4gZXhwbGljaXRseSBt YXJrZWQgU1RBQkxFLiBUaGUgZnVuY3Rpb246Ci0gb25seSBwZXJmb3JtcyBTRUxFQ1QgcXVlcmll cyAocmVhZC1vbmx5KSwKLSBkb2VzIG5vdCB1c2UgRVhFQ1VURSBvciBkeW5hbWljIFNRTCwKLSBo YXMgbm8gc2lkZSBlZmZlY3RzLAotIHJldHVybnMgYSBKU09OQiBvYmplY3QgZm9yIGEgZ2l2ZW4g aW5wdXQgc3RyaW5nLgoKSXQgc2VlbXMgUG9zdGdyZVNRTCAxNyBpcyBwZXJmb3JtaW5nIHN0cmlj dGVyIHBsYW5uaW5nIG9yIHJlbGF0aW9uCnJlc29sdXRpb24sIGV2ZW4gZm9yIGEgU1RBQkxFIGZ1 bmN0aW9uIHdpdGggbm8gdm9sYXRpbGl0eSBjb25jZXJucy4KCkkgaGF2ZSB0cmllZDoKLSBkZWNs YXJpbmcgdGhlIGZ1bmN0aW9uIGFzIFNUQUJMRSAoZXhwbGljaXRseSwgd2l0aCBQQVJBTExFTCBV TlNBRkUpCi0gdXNpbmcgV0lUSCBOTyBEQVRBCi0gbWF0ZXJpYWxpemluZyBhIHNpbXBsaWZpZWQg dmVyc2lvbgotIHJlbW92aW5nIGxhdGVyYWwgam9pbnMgZnJvbSB0aGUgdmlldyBkZWZpbml0aW9u CgpBbGwgb2YgdGhlc2UgY29udGludWUgdG8gZmFpbCBpbiBQRzE3LCB3aGlsZSB0aGV5IHdvcmsg ZmluZSBpbiBQRzEzLgoKVGhlIG9ubHkgc3VjY2Vzc2Z1bCB3b3JrYXJvdW5kIHdhcyB0byBwcmVj b21wdXRlIHRoZSBmdW5jdGlvbiBvdXRwdXQgaW4gYQpyZWFsIHRhYmxlLCB0aGVuIHJlZmVyZW5j ZSB0aGF0IHRhYmxlIGluIHRoZSBtYXRlcmlhbGl6ZWQgdmlldy4KVGhpcyB3b3JrcywgY29uZmly bWluZyB0aGF0IHRoZSBwbGFubmVyIGluIFBHMTcgaGFzIGlzc3VlcyB3aXRoIGVpdGhlcjoKLSBu ZXN0ZWQgTEFURVJBTCBleHByZXNzaW9ucyB1c2luZyBKU09OQiBmdW5jdGlvbnMKLSBmdW5jdGlv biBkZXBlbmRlbmN5IHJlc29sdXRpb24gZHVyaW5nIG1hdGVyaWFsaXplZCB2aWV3IGNyZWF0aW9u CgpJZiBhIGZ1bmN0aW9uIGlzIGRlY2xhcmVkIFNUQUJMRSBhbmQgcGVyZm9ybXMgb25seSByZWFk LW9ubHksIGRldGVybWluaXN0aWMKb3BlcmF0aW9uczoKLSBQb3N0Z3JlU1FMIHNob3VsZCBhbGxv dyBpdCBpbnNpZGUgbWF0ZXJpYWxpemVkIHZpZXdzCi0gdGhlIHBsYW5uZXIgc2hvdWxkIG5vdCB0 aHJvdyBlcnJvcnMgYWJvdXQgbm9uZXhpc3RlbnQgcmVsYXRpb25zIHVubGVzcwp0aGV5J3JlIGFj dHVhbGx5IHVucmVzb2x2ZWQKClBsZWFzZSBjb25maXJtIHdoZXRoZXIgdGhpcyBpczoKLSBhbiBp bnRlbnRpb25hbCBjaGFuZ2UgaW4gUEcxNyBwbGFubmluZyBiZWhhdmlvciwKLSBhIHBsYW5uZXIg YnVnIG9yIHJlZ3Jlc3Npb24sCi0gb3IgaWYgdGhlcmUgYXJlIGFkZGl0aW9uYWwgY29uc3RyYWlu dHMgd2UgbmVlZCB0byBiZSBhd2FyZSBvZiBmb3IgU1RBQkxFCmZ1bmN0aW9ucyB1c2luZyBKU09O QiArIExBVEVSQUwgaW4gbWF0ZXJpYWxpemVkIHZpZXdzLgoKSSdtIGhhcHB5IHRvIHByb3ZpZGUg YSBmdWxsIHJlcHJvIHNjcmlwdCBvciB0ZXN0IGRhdGFiYXNlIGlmIGhlbHBmdWwuCgpLaW5kIHJl Z2FyZHMsCkNhbGViIEdvcGFsCgo= --===============4711013798658039695==--