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 1nHLIG-0001DS-UE for pgsql-bugs@arkaria.postgresql.org; Tue, 08 Feb 2022 07:52:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nHLIF-0006fl-NP for pgsql-bugs@arkaria.postgresql.org; Tue, 08 Feb 2022 07:52:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nHAox-0005cH-Q8 for pgsql-bugs@lists.postgresql.org; Mon, 07 Feb 2022 20:41:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nHAor-00061q-8J for pgsql-bugs@lists.postgresql.org; Mon, 07 Feb 2022 20:41:10 +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=SJn29Kugl5xWpljbxjRCupzV3sK/BY4lkf3kLbptjBc=; b=Oy8ks52fPL4fRDgj4dD1l8kCkh xXyheSJNKsdnaVmHI7NCJvsb3PvcpwnbUkLcRIs3LxKpO2WxnNBtnGY+q1SDVwH2CwCRBJLz/YZNu 2PvBceykPn7tcTdl3NiKUR5dNmX5nIj1fzKfyE3VQ35KkmK9hlnn1VbO4DQafv/pYJ1UqTWW7W4Bt PvY1xba1LEEU4AYJnd/+DHSQZTrySEPjNKvEtPxedSl4Kj+7XSmhs3knJk/ywhjIiKTIIyUWcWY3M edFI9xHTTpqILIjRyX3psvbeRFiK+lSangD2XdtawXJH1cFnb0PA4vZ5yIXlhi87rK0Nz/zFb0ikA lo5xgs9A==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nHAoq-0001lp-Hu for pgsql-bugs@lists.postgresql.org; Mon, 07 Feb 2022 20:41:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nHAoo-0008LF-HU for pgsql-bugs@lists.postgresql.org; Mon, 07 Feb 2022 20:41:02 +0000 Content-Type: multipart/mixed; boundary="===============1746759030455905992==" MIME-Version: 1.0 Subject: BUG #17398: Casts from BYTEA to TEXT and FLOAT4/8 to TEXT should not be immutable To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: marcus@cockroachlabs.com Reply-To: marcus@cockroachlabs.com, pgsql-bugs@lists.postgresql.org Date: Mon, 07 Feb 2022 20:40:15 +0000 Message-ID: <17398-8fb0c02a60e2e565@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 --===============1746759030455905992== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzM5OApMb2dnZWQgYnk6ICAgICAgICAgIE1hcmN1cyBHYXJ0bmVyCkVt YWlsIGFkZHJlc3M6ICAgICAgbWFyY3VzQGNvY2tyb2FjaGxhYnMuY29tClBvc3RncmVTUUwgdmVy c2lvbjogMTQuMApPcGVyYXRpbmcgc3lzdGVtOiAgIG1hY09TIE1vbnRlcmV5IDEyLjIKRGVzY3Jp cHRpb246ICAgICAgICAKCkNhc3RzIGZyb20gQllURUEgdG8gVEVYVCBzaG91bGQgbm90IGJlIGlt bXV0YWJsZSBiZWNhdXNlIHRoZSByZXN1bHQgaXMKZGVwZW5kZW50IG9uIHRoZSBieXRlYV9vdXRw dXQgcGFyYW1ldGVyLiBDYXN0cyBmcm9tIEZMT0FUNCBhbmQgRkxPQVQ4IHRvClRFWFQgc2hvdWxk IG5vdCBiZSBpbW11dGFibGUgYmVjYXVzZSB0aGUgcmVzdWx0IGlzIGRlcGVuZGVudCBvbiB0aGUK ZXh0cmFfZmxvYXRfZGlnaXRzIHBhcmFtZXRlci4gSW5jb3JyZWN0IHJlc3VsdHMgYXJlIHBvc3Np YmxlIGJlY2F1c2Ugb2YKdGhlc2UgaW5jb3JyZWN0bHkgbGFiZWxlZCBjYXN0IHZvbGF0aWxpdGll cy4gVGhpcyBidWcgaXMgc2ltaWxhciB0byBCVUcKIzE3MzcxLg0KDQoNCkV4YW1wbGUgMTogQllU RUE6OlRFWFQNCg0KU0VUIGJ5dGVhX291dHB1dCA9IGhleDsNCg0KQ1JFQVRFIFRBQkxFIHQgKGIg QllURUEpOw0KDQpJTlNFUlQgSU5UTyB0IFNFTEVDVCAnYScgRlJPTSBnZW5lcmF0ZV9zZXJpZXMo MSwgMTAwMDApIHMoaSk7DQpJTlNFUlQgSU5UTyB0IFZBTFVFUyAoJ2InKTsNCg0KQ1JFQVRFIElO REVYIGkgT04gdCgoYjo6VEVYVCksIGIpOw0KDQpTRVQgYnl0ZWFfb3V0cHV0ID0gZXNjYXBlOw0K DQotLSBSZXR1cm5zIGZhbHNlLg0KU0VMRUNUIGI6OlRFWFQgPSAnXHg2MicgRlJPTSB0IFdIRVJF IGI6OlRFWFQgPSAnXHg2Mic7DQoNCkFOQUxZWkUgdDsNCg0KLS0gU2FtZSBxdWVyeSBhcyBhYm92 ZSwgbm93IHBlcmZvcm1pbmcgYW4gaW5kZXgtb25seSBzY2FuLCByZXR1cm5zIHRydWUuDQpTRUxF Q1QgYjo6VEVYVCA9ICdceDYyJyBGUk9NIHQgV0hFUkUgYjo6VEVYVCA9ICdceDYyJzsNCg0KRFJP UCBJTkRFWCBpOw0KDQotLSBTYW1lIHF1ZXJ5IGFzIGFib3ZlIHJldHVybnMgemVybyByb3dzLg0K U0VMRUNUIGI6OlRFWFQgPSAnXHg2MicgRlJPTSB0IFdIRVJFIGI6OlRFWFQgPSAnXHg2Mic7DQoN Cg0KRXhhbXBsZSAyOiBGTE9BVDo6VEVYVA0KDQpTRVQgZXh0cmFfZmxvYXRfZGlnaXRzID0gMDsN Cg0KQ1JFQVRFIFRBQkxFIHQgKGYgRkxPQVQpOw0KDQpJTlNFUlQgSU5UTyB0IFNFTEVDVCAxIEZS T00gZ2VuZXJhdGVfc2VyaWVzKDEsIDEwMDAwKSBzKGkpOw0KSU5TRVJUIElOVE8gdCBWQUxVRVMg KDEyMy40NTY3ODkwMTIzNDU2Nzg5KTsNCg0KQ1JFQVRFIElOREVYIGkgT04gdCgoZjo6VEVYVCks IGYpOw0KDQpTRVQgZXh0cmFfZmxvYXRfZGlnaXRzID0gMzsNCg0KLS0gUmV0dXJucyBmYWxzZS4N ClNFTEVDVCBmOjpURVhUID0gJzEyMy40NTY3ODkwMTIzNDYnIEZST00gdCBXSEVSRSBmOjpURVhU ID0KJzEyMy40NTY3ODkwMTIzNDYnOw0KDQpBTkFMWVpFIHQ7DQoNCi0tIFNhbWUgcXVlcnkgYXMg YWJvdmUsIG5vdyBwZXJmb3JtaW5nIGFuIGluZGV4LW9ubHkgc2NhbiwgcmV0dXJucyB0cnVlLg0K U0VMRUNUIGY6OlRFWFQgPSAnMTIzLjQ1Njc4OTAxMjM0NicgRlJPTSB0IFdIRVJFIGY6OlRFWFQg PQonMTIzLjQ1Njc4OTAxMjM0Nic7DQoNCkRST1AgSU5ERVggaTsNCg0KLS0gU2FtZSBxdWVyeSBh cyBhYm92ZSByZXR1cm5zIHplcm8gcm93cy4NClNFTEVDVCBmOjpURVhUID0gJzEyMy40NTY3ODkw MTIzNDYnIEZST00gdCBXSEVSRSBmOjpURVhUID0KJzEyMy40NTY3ODkwMTIzNDYnOwoK --===============1746759030455905992==--