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 1tu5vb-003Xpu-Jj for pgsql-bugs@arkaria.postgresql.org; Mon, 17 Mar 2025 08:34:32 +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 1tu5va-008oQV-Bq for pgsql-bugs@arkaria.postgresql.org; Mon, 17 Mar 2025 08:34:30 +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 1ttoDr-00ESGS-VX for pgsql-bugs@lists.postgresql.org; Sun, 16 Mar 2025 13:40:12 +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.96) (envelope-from ) id 1ttoDl-003BVK-19 for pgsql-bugs@lists.postgresql.org; Sun, 16 Mar 2025 13:40: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=XxRGHxEKeQ1RXHjnb5tlBYm6R4UFOZGwSBgyVTRqVNc=; b=i0Fv50E3Io0BWyrR4i2iE9bfHM E9XZ0vkLkcIOAIjNChPEQBmS16nD9fz9B70epZUVPKnenOiHbT4o/onwEOLofppAAMRJpk+89chSM 0zDRWKsf7POQ1ox7MHjF1vs3Q/ceXT5o+fjwPxIiwW46I8JMQDiTVEOgIppNQ1RvVMY/iZt2oLQ/h 5ip9Mq/ijj5eDyhaYwjHD6500u8MLi3w1/NDObB+n3iqNouMmYvS9OTyDwrNQq0A/oupf8FA6Lm/8 novFt94cQwuuTrfHXM1M+dZcq1YpdJaHnYaIWCLx4yo137/Vf1wsnklJplnpIixJ2eo+E9UwYk6HM LfoPTZsA==; 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 1ttoDl-008FT2-4i for pgsql-bugs@lists.postgresql.org; Sun, 16 Mar 2025 13:40:05 +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 1ttoDj-003nME-D7 for pgsql-bugs@lists.postgresql.org; Sun, 16 Mar 2025 13:40:02 +0000 Content-Type: multipart/mixed; boundary="===============3796510661492282524==" MIME-Version: 1.0 Subject: BUG #18852: Unexpected expression in subquery output To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: tharakan@gmail.com Reply-To: tharakan@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sun, 16 Mar 2025 13:39:16 +0000 Message-ID: <18852-fb75b88160678f78@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 --===============3796510661492282524== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODg1MgpMb2dnZWQgYnk6ICAgICAgICAgIFJvYmlucyBUaGFyYWthbgpF bWFpbCBhZGRyZXNzOiAgICAgIHRoYXJha2FuQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IFVuc3VwcG9ydGVkL1Vua25vd24KT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUKRGVzY3JpcHRp b246ICAgICAgICAKCkhpLA0KDQpUaGUgZm9sbG93aW5nIFNRTCByZXR1cm5zIHRoaXMgZXJyb3I6 DQoNCiQgcHNxbCAtZiByZXByby5zcWwgPi9kZXYvbnVsbA0KcHNxbDpyZXByby5zcWw6MTE6IEVS Uk9SOiAgdW5leHBlY3RlZCBleHByZXNzaW9uIGluIHN1YnF1ZXJ5IG91dHB1dA0KDQokIGNhdCBy ZXByby5zcWwNCkNSRUFURSBTQ0hFTUEgYTsNCkNSRUFURSBTQ0hFTUEgYjsNCkNSRUFURSBFWFRF TlNJT04gcG9zdGdyZXNfZmR3IDsNCkNSRUFURSBTRVJWRVIgZCBGT1JFSUdOIERBVEEgV1JBUFBF UiBwb3N0Z3Jlc19mZHc7DQpDUkVBVEUgRk9SRUlHTiBUQUJMRSBhLmUgKCkgU0VSVkVSIGQ7DQpD UkVBVEUgRk9SRUlHTiBUQUJMRSBhLmYgKGcgdGV4dCkgU0VSVkVSIGQ7DQpDUkVBVEUgRk9SRUlH TiBUQUJMRSBiLmggKCkgU0VSVkVSIGQ7DQpTRUxFQ1QgRlJPTSBhLmYgUklHSFQgSk9JTiBiLmgg T04gRVhJU1RTIChTRUxFQ1QgRlJPTSBhLmUgV0hFUkUgKFNFTEVDVApOVUxMKSA+IGcpIExJTUlU IDk7DQoNCi0gVGhlIGlzc3VlIHN1cmZhY2VkIGFmdGVyIGNvbW1pdCA4MjRkYmVhM2U0MWVmYTNi MzUwOTQxNjNjODM0OTg4ZGVhN2ViMTM5ClsxXQ0KVGVzdGluZyBmb3Igc3RhcnQgY3Jhc2hpbmcN CkNoZWNraW5nICg2ODJjNWJlMjVjMn4wKSAtIDY4MmM1YmUyNWMgLSBmYWlsDQpDaGVja2luZyAo NjgyYzViZTI1YzJ+MTApIC0gMmI3M2E4Y2QzMyAtIGZhaWwNCkNoZWNraW5nICg2ODJjNWJlMjVj Mn4zMCkgLSAzNjkxZWRmYWI5IC0gZmFpbA0KLg0KLg0KQ2hlY2tpbmcgKDY4MmM1YmUyNWMyfjM0 NzApIC0gMjc4ZWIxM2M0OCAtIHBhc3MNCkNoZWNraW5nICg2ODJjNWJlMjVjMn4zNDUwKSAtIDdk YjAxZmJjZWYgLSBmYWlsDQpDaGVja2luZyAoNjgyYzViZTI1YzJ+MzQ2MCkgLSA3MTliMzQyZDM2 IC0gZmFpbA0KQ2hlY2tpbmcgKDY4MmM1YmUyNWMyfjM0NjUpIC0gYzJhNDY1YjJjOSAtIGZhaWwN CkNoZWNraW5nICg2ODJjNWJlMjVjMn4zNDY3KSAtIDc2MzY3MjViOTIgLSBmYWlsDQpDaGVja2lu ZyAoNjgyYzViZTI1YzJ+MzQ2OCkgLSBiZmM2NzdjM2JjIC0gZmFpbA0KQ2hlY2tpbmcgKDY4MmM1 YmUyNWMyfjM0NjkpIC0gODI0ZGJlYTNlNCAtIGZhaWwNClN1cmZhY2luZyBDb21taXQgaXMgODI0 ZGJlYTNlNDFlZmEzYjM1MDk0MTYzYzgzNDk4OGRlYTdlYjEzOQ0KDQotDQpyb2JpbnMNCg0KUmVm ZXJlbmNlOg0KMS4KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvZ2l0d2ViLz9wPXBvc3RncmVz cWwuZ2l0O2E9Y29tbWl0ZGlmZjtoPTgyNGRiZWEzZTQxZWZhM2IzNTA5NDE2M2M4MzQ5ODhkZWE3 ZWIxMzkKCg== --===============3796510661492282524==--