Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gHOdH-00039j-E0 for pgsql-bugs@arkaria.postgresql.org; Tue, 30 Oct 2018 07:40:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gHOdF-0006HS-GG for pgsql-bugs@arkaria.postgresql.org; Tue, 30 Oct 2018 07:40:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1gHOdF-0006HD-A3 for pgsql-bugs@lists.postgresql.org; Tue, 30 Oct 2018 07:40:09 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gHOd9-0005zM-2N for pgsql-bugs@lists.postgresql.org; Tue, 30 Oct 2018 07:40:08 +0000 Content-Type: multipart/mixed; boundary="===============2284966347415172708==" MIME-Version: 1.0 Subject: BUG #15471: psql 11 array concatenation in CASE takes on values from the CASE expression when using enum_range To: pgsql-bugs@lists.postgresql.org From: =?utf-8?q?PG_Bug_reporting_form?= Cc: pg@mattyw.net Reply-To: pg@mattyw.net, pgsql-bugs@lists.postgresql.org Date: Tue, 30 Oct 2018 07:39:52 +0000 Message-ID: <15471-1117f49271989bad@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============2284966347415172708== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTQ3MQpMb2dnZWQgYnk6ICAgICAgICAgIE1hdHQgV2lsbGlhbXMKRW1h aWwgYWRkcmVzczogICAgICBwZ0BtYXR0eXcubmV0ClBvc3RncmVTUUwgdmVyc2lvbjogMTEuMApP cGVyYXRpbmcgc3lzdGVtOiAgIENvbmZpcm1lZCBvbiBNYWNPcyBhbmQgQWxwaW5lIExpbnV4CkRl c2NyaXB0aW9uOiAgICAgICAgCgpCZWxvdyBpcyBhbiBleGFtcGxlIC5zcWwgZmlsZSB0aGF0IHJl cGxpY2F0ZXMgdGhlIHByb2JsZW0uIFB1dCBzaW1wbHksIHdoZW4Kd2UgYXJyYXkgY29uY2F0IHdp dGggZW51bV9yYW5nZSBpbiB0aGUgcmVzdWx0IG9mIGEgQ0FTRSBzdGF0ZW1lbnQgdGhlCmNvbmNh dGVuYXRpb24gdGFrZXMgdGhlIGV4cHJlc3Npb24gZnJvbSB0aGUgQ0FTRSBzdGF0ZW1lbnQsIG5v dCB0aGUgZW51bQpyYW5nZS4NCg0KaWYgeW91IHJ1biB0aGUgYmVsb3cgLnNxbCBmaWxlIGFnYWlu c3QgcG9zdGdyZXMgMTAgYW5kIDExIHlvdSdsbCBzZWUgZXgxIGFuZApleDIgcmV0dXJuIHRoZSBz YW1lIGFycmF5LiBIb3dldmVyIGV4Myw0LDUgYWxsIHNob3cgYXJyYXlzIGNvbmNhdGVuYXRlZCB3 aXRoCnRoZSB2YWx1ZSBpbiB0aGUgQ0FTRSBjb25kaXRpb24gKFRSVUUsICd0cnVlJyBhbmQgMSku IFRoZXkgYWxsIHJldHVybiB0aGUKZXhwZWN0ZWQgYXJyYXkgdW5kZXIgcG9zdGdyZXMgOS42IGFu ZCAxMC4gVGhlIGNoYW5nZSBvbmx5IGFwcGVhcnMgaW4KcG9zdGdyZXMgMTEuDQoJDQpUaGUgbGFz dCBleGFtcGxlIChleDYpIHNob3dzIHRoZSBDQVNFIHJld3JpdHRlbiB0byByZW1vdmUgdGhlIGV4 cHJlc3Npb24sCmV4NiB3b3JrcyB0aGUgc2FtZSB1bmRlciBwb3N0Z3JlcyAxMCBhbmQgMTEuDQoN ClRoZXNlIHJlc3VsdHMgZm9yIGV4IDMsIDQgYW5kIDUgd2VyZSBzdXJwcmlzaW5nLCBJIGNvdWxk bid0IGZpbmQgYW55dGhpbmcgaW4KdGhlIGRvY3MgdGhhdCBhbGx1ZGVzIHRvIHRoaXMgY2hhbmdl LCBhbmQgSSd2ZSBiZWVuIHVuYWJsZSB0byBmaW5kIGFueQpvbmxpbmUgZGlzY3Vzc2lvbiByZWdh cmRpbmcgdGhpcy4NCg0KLS0tIFN0YXJ0IG9mIHNxbCBmaWxlIC0tLQ0KU0VMRUNUIHZlcnNpb24o KTsNCg0KRFJPUCBUWVBFIElGIEVYSVNUUyBteWVudW07DQoNCkNSRUFURSBUWVBFIG15ZW51bSBB UyBFTlVNICgnZScsICdmJywgJ2cnKTsNCg0KU0VMRUNUIGVudW1fcmFuZ2UoTlVMTDo6bXllbnVt KTsNCg0KU0VMRUNUIEFSUkFZWydhJywgJ2InLCAnYycsICdkJ10gfHwgZW51bV9yYW5nZShOVUxM OjpteWVudW0pOjp0ZXh0W10gYXMKZXgxOw0KDQpTRUxFQ1QNCglDQVNFIFRSVUUNCgkJV0hFTiBU UlVFIFRIRU4gQVJSQVlbJ2EnLCAnYicsICdjJywgJ2QnXSB8fCBBUlJBWVsnZScsICdmJywgJ2cn XQ0KCQlXSEVOIEZBTFNFIFRIRU4gQVJSQVlbJ2EnLCAnYicsICdjJywgJ2QnXQ0KRU5EIGFzIGV4 MjsNCg0KLS0gQWxsIG9mIHRoZSBhYm92ZSB3b3JrcyBhcyBleHBlY3RlZA0KDQpTRUxFQ1QNCglD QVNFIFRSVUUNCgkJV0hFTiBUUlVFIFRIRU4gQVJSQVlbJ2EnLCAnYicsICdjJywgJ2QnXSB8fApl bnVtX3JhbmdlKE5VTEw6Om15ZW51bSk6OnRleHRbXQ0KCQlXSEVOIEZBTFNFIFRIRU4gQVJSQVlb J2EnLCAnYicsICdjJywgJ2QnXQ0KRU5EIGFzIGV4MzsNCg0KLS0gSW4gdGhlIGFib3ZlIGNhc2Ug c3RhdGVtZW50IHdlJ2QgZXhwZWN0ZWQgdGhlIG91dHB1dDoge2EsYixjLGQsZSxmLGd9DQotLSBI b3dldmVyIHVuZGVyIHBvc3RyZXMgMTEgd2UgZ2V0IHRoZSBmb2xsb3dpbmcgb3V0cHV0OiB7YSxi LGMsZCx0LHQsdH0NCg0KDQpTRUxFQ1QNCglDQVNFICd0cnVlJw0KCQlXSEVOICd0cnVlJyBUSEVO IEFSUkFZWydhJywgJ2InLCAnYycsICdkJ10gfHwKZW51bV9yYW5nZShOVUxMOjpteWVudW0pOjp0 ZXh0W10NCgkJV0hFTiAnZmFsc2UnIFRIRU4gQVJSQVlbJ2EnLCAnYicsICdjJywgJ2QnXQ0KRU5E IGFzIGV4NDsNCg0KLS0gUG9zdGdyZXMgMTA6IHthLGIsYyxkLGUsZixnfQ0KLS0gUG9zdGdyZXMg MTE6IHthLGIsYyxkLHRydWUsdHJ1ZSx0cnVlfQ0KDQoNClNFTEVDVA0KCUNBU0UgMQ0KCQlXSEVO IDEgVEhFTiBBUlJBWVsnYScsICdiJywgJ2MnLCAnZCddIHx8CmVudW1fcmFuZ2UoTlVMTDo6bXll bnVtKTo6dGV4dFtdDQoJCVdIRU4gMiBUSEVOIEFSUkFZWydhJywgJ2InLCAnYycsICdkJ10NCkVO RCBhcyBleDU7DQoNCi0tIFBvc3RncmVzIDEwOiB7YSxiLGMsZCxlLGYsZ30NCi0tIFBvc3RncmVz IDExOiB7YSxiLGMsZCwxLDEsMX0NCg0KU0VMRUNUDQoJQ0FTRQ0KCQlXSEVOIFRSVUUgVEhFTiBB UlJBWVsnYScsICdiJywgJ2MnLCAnZCddIHx8CmVudW1fcmFuZ2UoTlVMTDo6bXllbnVtKTo6dGV4 dFtdDQoJCUVMU0UgQVJSQVlbJ2EnLCAnYicsICdjJywgJ2QnXQ0KRU5EIGFzIGV4NjsNCg0KLS0g SW4gdGhpcyBmb3JtIHdlIGdldCB0aGUgc2FtZSBhbnN3ZXIgZm9yIGJvdGggcG9zdGdyZXMgMTAg YW5kIDExOgp7YSxiLGMsZCxlLGYsZ30KCg== --===============2284966347415172708==--