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 1uSEcs-0056Gg-D6 for pgsql-bugs@arkaria.postgresql.org; Thu, 19 Jun 2025 12:44:18 +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 1uSEcp-00BEsd-Lo for pgsql-bugs@arkaria.postgresql.org; Thu, 19 Jun 2025 12:44:16 +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 1uSEHO-00B8fq-GJ for pgsql-bugs@lists.postgresql.org; Thu, 19 Jun 2025 12:22:07 +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 1uSEHN-002swU-12 for pgsql-bugs@lists.postgresql.org; Thu, 19 Jun 2025 12:22:06 +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=DPZFp+0qHtcXGqx7CvdISM7X/hW3B1V1M7ih9bVflCI=; b=RK5nxxUIXflUxpP6Bkztr6wn4O NEINOBdPMBpHeINqZKu365OC0CwFdYSKRY85CxYug2tJ3/XLunoP4EtgxzSct+tfBO9NaEW3zwC3p CUHkI1a2NTnj7Bfk/6JVPuf8bZVawGqLuYYIDR/3lxU0rfd5j+/a+iL3PM13c/9lehy3hoU2thW0m NoV5aejBLstJkYpso8fEENOjcIrkcN2Q1p8DlPPXfH9bIHAGKABqO26aDQdp6EMqMNJP3DGfEZeoP DCZpZDqeThPYwX6enH4/2eZY3oREf03zE7dVmobjgMB+Xd4RE9meL0jkaLTPUnmY6lja9gAo7O2qf 8t+IBGXA==; 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 1uSEHM-008E58-Lk for pgsql-bugs@lists.postgresql.org; Thu, 19 Jun 2025 12:22: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 1uSEHL-0008Ds-0V for pgsql-bugs@lists.postgresql.org; Thu, 19 Jun 2025 12:22:03 +0000 Content-Type: multipart/mixed; boundary="===============2750928643052027456==" MIME-Version: 1.0 Subject: BUG #18962: Type Conversion incorrect when performing UNION of queries. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: sundar@mudupalli.com Reply-To: sundar@mudupalli.com, pgsql-bugs@lists.postgresql.org Date: Thu, 19 Jun 2025 12:21:15 +0000 Message-ID: <18962-71e1ca655df5139f@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 --===============2750928643052027456== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODk2MgpMb2dnZWQgYnk6ICAgICAgICAgIFN1bmRhciBNdWR1cGFsbGkK RW1haWwgYWRkcmVzczogICAgICBzdW5kYXJAbXVkdXBhbGxpLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDE3LjUKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgSSBiZWxpZXZlICh1c2luZyBhIENs b3VkIFNRTCBpbnN0YW5jZSBpbiBHQwpEZXNjcmlwdGlvbjogICAgICAgIAoKVGFrZSB0aGUgZm9s bG93aW5nIHRhYmxlIGRlZmluaXRpb25zOgpgYGAKY3JlYXRlIHRhYmxlIHB1YmxpYy50ZXN0X3Rh YmxlXzEgYXMKU0VMRUNUCiAgICdBQSc6OmNoYXJhY3RlcigyKSBBUyB0ZXh0X3R5cGUKVU5JT04g QUxMClNFTEVDVAogICAnQkInOjpjaGFyYWN0ZXIoMikgQVMgdGV4dF90eXBlClVOSU9OIEFMTApT RUxFQ1QKICAgJ0NDJzo6VEVYVCBBUyB0ZXh0X3R5cGUKOwpjcmVhdGUgdGFibGUgcHVibGljLnRl c3RfdGFibGVfMiAoCiAgICAgICAgY2hhcl9maXhlZCBjaGFyYWN0ZXIsCiAgICAgICAgY2hhcl9m aXhlZF9sZW4gY2hhcmFjdGVyKDUpLAogICAgICAgIGNoYXJfdmFyIGNoYXJhY3RlciB2YXJ5aW5n KDUpLAogICAgICAgIHRleHRfY29sdW1uIHRleHQgKTsKYGBgCkJhc2VkIG9uIHRoZSBbdHlwZSBj b252ZXJzaW9uIHJ1bGVzIGZvcgpVbmlvbl0oaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9j cy9jdXJyZW50L3R5cGVjb252LXVuaW9uLWNhc2UuaHRtbCksCnRoZSBjb2x1bW4gYHRleHRfdHlw ZWAgaW4gYHRlc3RfdGFibGVfMWAgc2hvdWxkIHJlc29sdmUgdG8gdGhlIHBvc3RncmVzIGRhdGEK dHlwZSBgVEVYVGAuIEhvd2V2ZXIgcnVubmluZyB0aGUgZm9sbG93aW5nIHF1ZXJ5IHByb2R1Y2Vz IHRoZSBmb2xsb3dpbmc6CmBgYApzZWxlY3QgdGFibGVfbmFtZSwgY29sdW1uX25hbWUsIGRhdGFf dHlwZSwgY2hhcmFjdGVyX21heGltdW1fbGVuZ3RoIGZyb20KaW5mb3JtYXRpb25fc2NoZW1hLmNv bHVtbnMgd2hlcmUgdGFibGVfbmFtZSBsaWtlICd0ZXN0X3RhYmxlXyUnIG9yZGVyIGJ5CnRhYmxl X25hbWU7CiAgdGFibGVfbmFtZSAgfCAgY29sdW1uX25hbWUgICB8ICAgICBkYXRhX3R5cGUgICAg IHwKY2hhcmFjdGVyX21heGltdW1fbGVuZ3RoCi0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0t LS0rLS0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogdGVzdF90 YWJsZV8xIHwgdGV4dF90eXBlICAgICAgfCBjaGFyYWN0ZXIgICAgICAgICB8CiB0ZXN0X3RhYmxl XzIgfCBjaGFyX2ZpeGVkICAgICB8IGNoYXJhY3RlciAgICAgICAgIHwKMQogdGVzdF90YWJsZV8y IHwgY2hhcl9maXhlZF9sZW4gfCBjaGFyYWN0ZXIgICAgICAgICB8CjUKIHRlc3RfdGFibGVfMiB8 IGNoYXJfdmFyICAgICAgIHwgY2hhcmFjdGVyIHZhcnlpbmcgfAo1CiB0ZXN0X3RhYmxlXzIgfCB0 ZXh0X2NvbHVtbiAgICB8IHRleHQgICAgICAgICAgICAgIHwKKDUgcm93cykKYGBgClRoZSBkYXRh IHR5cGUgZm9yIHRleHQgc2F5cyBgY2hhcmFjdGVyYCAoZml4ZWQgbGVuZ3RoIGNoYXJhY3RlciBz dHJpbmcpIG9mCnVuZGV0ZXJtaW5lZCBsZW5ndGgsIHdoZW4gaXQgc2hvdWxkIHJlYWxseSBiZSBv ZiB0eXBlIGB0ZXh0YCBhcyB0aGUgY29sdW1uCmB0ZXh0X2NvbHVtbmAgaW4gYHRlc3RfdGFibGVf MmAuCgo= --===============2750928643052027456==--