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 1sjMOj-0001jW-3R for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Aug 2024 17:23:57 +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 1sjMOh-008FyN-3d for pgsql-bugs@arkaria.postgresql.org; Wed, 28 Aug 2024 17:23:55 +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 1sjLN1-007Rpi-Sz for pgsql-bugs@lists.postgresql.org; Wed, 28 Aug 2024 16:18:08 +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.94.2) (envelope-from ) id 1sjLMz-001ryH-Rq for pgsql-bugs@lists.postgresql.org; Wed, 28 Aug 2024 16:18:07 +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=tgSb9r5IPihCCt7GUiQLlkqOA8mByA7tim2SosvJn5k=; b=5BQbRuTvdSPuLHBT0wmenaqO6k 2ez0zZD2q26ZRPgveh6wItM1GlkEPR/SIQUPDcd+DU0a67hzihLLgfHShaYpRAqSg8LitPCI4vlH4 kqfznm5CboxbC/cqt/yIpwgB4w8R7a35tKC6K2RH521sQJ7QOkI4k4zRpGrez6Dyg4ycDde04cG/V G1uCnKH3WyCK4gHLYcVSoU5mWHL0gnwoIX2enJCp9qecH+kqmWqqIcW0xjWpE1kJCkM92Vj6aK7o7 qpkk8dFZ2MkWsP79v6OsirYyhuLmlZ9Bw6saYe6GnzXYrpSZfse87X2GtMc1O0w4PDQhG2vmLfB60 hp6IU8cQ==; 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 1sjLMy-006FVM-NA for pgsql-bugs@lists.postgresql.org; Wed, 28 Aug 2024 16:18: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 1sjLMw-0084gB-TE for pgsql-bugs@lists.postgresql.org; Wed, 28 Aug 2024 16:18:03 +0000 Content-Type: multipart/mixed; boundary="===============1357059146400334472==" MIME-Version: 1.0 Subject: BUG #18594: CASE WHEN ELSE failing to return the expected output when the same colum is used in WHEN and ELSE To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: fco.j.ossandon@gmail.com Reply-To: fco.j.ossandon@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 28 Aug 2024 16:17:03 +0000 Message-ID: <18594-af265c6988d431d8@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 --===============1357059146400334472== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODU5NApMb2dnZWQgYnk6ICAgICAgICAgIEZyYW5jaXNjbyBKYXZpZXIg T3NzYW5kb24KRW1haWwgYWRkcmVzczogICAgICBmY28uai5vc3NhbmRvbkBnbWFpbC5jb20KUG9z dGdyZVNRTCB2ZXJzaW9uOiAxNS41Ck9wZXJhdGluZyBzeXN0ZW06ICAgTGludXgKRGVzY3JpcHRp b246ICAgICAgICAKCkRlYXIgZGV2ZWxvcGVyczoNCkkgaGF2ZSBiZWVuIHVzaW5nIFBvc3RncmVz IGZvciBzb21lIHllYXJzIG5vdywgYW5kIEkganVzdCBmb3VuZCB3aGF0IGxvb2tzCmxpa2UgYSBi dWcsIG9yIGF0IGxlYXN0IEkgZGlkIG5vdCBzZWUgYW55dGhpbmcgaW4gdGhlIGRvY3VtZW50YXRp b24gdGhhdApjb3VsZCBleHBsYWluIGl0Lg0KDQoqIHZlcnNpb24oKToNClBvc3RncmVTUUwgMTUu NSBvbiB4ODZfNjQtcGMtbGludXgtZ251LCBjb21waWxlZCBieSBnY2MgKEdDQykgNy4zLjEgMjAx ODA3MTIKKFJlZCBIYXQgNy4zLjEtMTIpLCA2NC1iaXQNCg0KVGhlIG1haW4gaXNzdWUgaXMgdGhh dCAiQ0FTRSBXSEVOIFRIRU4gRUxTRSIgaXMgZ2l2aW5nIGFuIGV4cGVjdGVkIHJlc3VsdCBpbgp3 aGF0IHNlZW1zIGxpa2Ugc2ltcGxlIGxvZ2ljLiBJIGhhdmUgYSBzZXJpZXMgb2YgV0hFTnMgd2l0 aCBjb25kaXRpb25zIG92ZXIKdGhlIHZhbHVlIG9mIGEgY29sdW1uIGFuZCBhbiBFTFNFIHdoZXJl IEkgcmV0dXJuIHRoZSBzYW1lIGNvbHVtbiB2YWx1ZSBpZgp0aGUgQ0FTRXMgYWJvdmUgZG9uJ3Qg YXBwbHksIGFuZCB0aGUgcXVlcnkgYWx3YXlzIHJldHVybnMgdGhlIHZhbHVlIG9mIHRoZQpFTFNF IGNvbmRpdGlvbiBsaWtlIGlmIHRoZSBXSEVOcyBhYm92ZSB3b3VsZCBub3QgZXhpc3QuIFRoZSBm b2xsb3dpbmcgcXVlcnkKZXhlbXBsaWZpZXMgdGhpcywgd2hlcmUgdGhlIGZpcnN0IENBU0UgY29s dW1uIGdpdmVzIGFuIHVuZXhwZWN0ZWQgcmVzdWx0CndoZW4gdXNpbmcgdGhlIHNhbWUgY29sdW1u IGluIHRoZSBFTFNFLCB3aGlsZSB0aGUgb3RoZXIgQ0FTRSBjb2x1bW5zIHByb3ZpZGUKdGhlIGV4 cGVjdGVkIHJlc3VsdCB3aGVuIHJlbW92aW5nIHRoZSBFTFNFIG9yIHVzaW5nIGEgZGlmZmVyZW50 IGNvbHVtbiBpbgp0aGUgRUxTRSBvciBhIGNvbnN0YW50IHN0cmluZzoNCmBgYA0KU0VMRUNUIG9p ZCwNCiAgICAgICB0eXBuYW1lLA0KICAgICAgIHR5cGNhdGVnb3J5LA0KICAgICAgIENBU0UNCiAg ICAgICAgICBXSEVOIHR5cGNhdGVnb3J5ID0gJ04nIFRIRU4gJ051bWVyaWMgdHlwZXMnDQogICAg ICAgICAgV0hFTiB0eXBjYXRlZ29yeSA9ICdTJyBUSEVOICdTdHJpbmcgdHlwZXMnDQogICAgICAg ICAgV0hFTiB0eXBjYXRlZ29yeSA9ICdFJyBUSEVOICdFbnVtIHR5cGVzJw0KICAgICAgICAgIEVM U0UgdHlwY2F0ZWdvcnkNCiAgICAgICBFTkQgQVMgdGVzdF9jYXNlX2ZhaWxzLA0KICAgICAgIENB U0UNCiAgICAgICAgICBXSEVOIHR5cGNhdGVnb3J5ID0gJ04nIFRIRU4gJ051bWVyaWMgdHlwZXMn DQogICAgICAgICAgV0hFTiB0eXBjYXRlZ29yeSA9ICdTJyBUSEVOICdTdHJpbmcgdHlwZXMnDQog ICAgICAgICAgV0hFTiB0eXBjYXRlZ29yeSA9ICdFJyBUSEVOICdFbnVtIHR5cGVzJw0KICAgICAg IEVORCBBUyB0ZXN0X2Nhc2Vfd29ya3Nfbm9fZWxzZSwNCiAgICAgICBDQVNFDQogICAgICAgICAg V0hFTiB0eXBjYXRlZ29yeSA9ICdOJyBUSEVOICdOdW1lcmljIHR5cGVzJw0KICAgICAgICAgIFdI RU4gdHlwY2F0ZWdvcnkgPSAnUycgVEhFTiAnU3RyaW5nIHR5cGVzJw0KICAgICAgICAgIFdIRU4g dHlwY2F0ZWdvcnkgPSAnRScgVEhFTiAnRW51bSB0eXBlcycNCiAgICAgICAgICBFTFNFIHR5cG5h bWUNCiAgICAgICBFTkQgQVMgdGVzdF9jYXNlX3dvcmtzX290aGVyX2NvbCwNCiAgICAgICBDQVNF DQogICAgICAgICAgV0hFTiB0eXBjYXRlZ29yeSA9ICdOJyBUSEVOICdOdW1lcmljIHR5cGVzJw0K ICAgICAgICAgIFdIRU4gdHlwY2F0ZWdvcnkgPSAnUycgVEhFTiAnU3RyaW5nIHR5cGVzJw0KICAg ICAgICAgIFdIRU4gdHlwY2F0ZWdvcnkgPSAnRScgVEhFTiAnRW51bSB0eXBlcycNCiAgICAgICAg ICBFTFNFICdFTFNFJw0KICAgICAgIEVORCBBUyB0ZXN0X2Nhc2Vfd29ya3NfY29uc3RhbnQNCkZS T00gcGdfdHlwZQ0KT1JERVIgQlkgb2lkDQpMSU1JVCAxMA0KOw0KYGBgDQpUaGlzIHJldHVybnMg dGhlIGZvbGxvd2luZzoNCmBgYA0Kb2lkfHR5cG5hbWUgIAp8dHlwY2F0ZWdvcnl8dGVzdF9jYXNl X2ZhaWxzfHRlc3RfY2FzZV93b3Jrc19ub19lbHNlfHRlc3RfY2FzZV93b3Jrc19vdGhlcl9jb2x8 dGVzdF9jYXNlX3dvcmtzX2NvbnN0YW50fA0KLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKw0KIDE2fGJvb2wgICAgICB8QiAgICAgICAg ICB8QiAgICAgICAgICAgICAgfCAgICAgICAgICAgICAgICAgICAgICAgfGJvb2wgICAgIAogICAg ICAgICAgICAgICB8RUxTRSAgICAgICAgICAgICAgICAgICAgfA0KIDE3fGJ5dGVhICAgICB8VSAg ICAgICAgICB8VSAgICAgICAgICAgICAgfCAgICAgICAgICAgICAgICAgICAgICAgfGJ5dGVhICAg IAogICAgICAgICAgICAgICB8RUxTRSAgICAgICAgICAgICAgICAgICAgfA0KIDE4fGNoYXIgICAg ICB8WiAgICAgICAgICB8WiAgICAgICAgICAgICAgfCAgICAgICAgICAgICAgICAgICAgICAgfGNo YXIgICAgIAogICAgICAgICAgICAgICB8RUxTRSAgICAgICAgICAgICAgICAgICAgfA0KIDE5fG5h bWUgICAgICB8UyAgICAgICAgICB8UyAgICAgICAgICAgICAgfFN0cmluZyB0eXBlcyAgICAgICAg ICAgfFN0cmluZwp0eXBlcyAgICAgICAgICAgICB8U3RyaW5nIHR5cGVzICAgICAgICAgICAgfA0K IDIwfGludDggICAgICB8TiAgICAgICAgICB8TiAgICAgICAgICAgICAgfE51bWVyaWMgdHlwZXMg ICAgICAgICAgfE51bWVyaWMKdHlwZXMgICAgICAgICAgICB8TnVtZXJpYyB0eXBlcyAgICAgICAg ICAgfA0KIDIxfGludDIgICAgICB8TiAgICAgICAgICB8TiAgICAgICAgICAgICAgfE51bWVyaWMg dHlwZXMgICAgICAgICAgfE51bWVyaWMKdHlwZXMgICAgICAgICAgICB8TnVtZXJpYyB0eXBlcyAg ICAgICAgICAgfA0KIDIyfGludDJ2ZWN0b3J8QSAgICAgICAgICB8QSAgICAgICAgICAgICAgfCAg ICAgICAgICAgICAgICAgICAgICAKfGludDJ2ZWN0b3IgICAgICAgICAgICAgICB8RUxTRSAgICAg ICAgICAgICAgICAgICAgfA0KIDIzfGludDQgICAgICB8TiAgICAgICAgICB8TiAgICAgICAgICAg ICAgfE51bWVyaWMgdHlwZXMgICAgICAgICAgfE51bWVyaWMKdHlwZXMgICAgICAgICAgICB8TnVt ZXJpYyB0eXBlcyAgICAgICAgICAgfA0KIDI0fHJlZ3Byb2MgICB8TiAgICAgICAgICB8TiAgICAg ICAgICAgICAgfE51bWVyaWMgdHlwZXMgICAgICAgICAgfE51bWVyaWMKdHlwZXMgICAgICAgICAg ICB8TnVtZXJpYyB0eXBlcyAgICAgICAgICAgfA0KIDI1fHRleHQgICAgICB8UyAgICAgICAgICB8 UyAgICAgICAgICAgICAgfFN0cmluZyB0eXBlcyAgICAgICAgICAgfFN0cmluZwp0eXBlcyAgICAg ICAgICAgICB8U3RyaW5nIHR5cGVzICAgICAgICAgICAgfA0KYGBgDQpJdCBsb29rcyB3ZWlyZCwg c28gSSdtIHJlcG9ydGluZyB0aGlzIHRvIHlvdSBmb3IgcmV2aWV3Lg0KDQpCZXN0IHJlZ2FyZHMs Cgo= --===============1357059146400334472==--