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 1rWh56-006lJk-0l for pgsql-bugs@arkaria.postgresql.org; Sun, 04 Feb 2024 18:19:04 +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 1rWh54-007OYk-Fl for pgsql-bugs@arkaria.postgresql.org; Sun, 04 Feb 2024 18:19:02 +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 1rWMeQ-0037mp-5M for pgsql-bugs@lists.postgresql.org; Sat, 03 Feb 2024 20:30:10 +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 1rWMeN-004vAN-4z for pgsql-bugs@lists.postgresql.org; Sat, 03 Feb 2024 20:30: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=P//5rbId9UIL1XQmFOXs6It30EfVPXLuNiSmnD0MYNg=; b=HUaizVBip7cSMerAlR7B7nxnVB iJAqrc4/Mydsk4/8c/dPeyTWcRcz7HszSMEPPGhjgSRY7b/ubToZF9P4hSXL9hjOwaBtGFDsbd9pW GqN1GJL5MG6E/evKZqlZGy1yo4ZrOegba1bhr18M+aw2LvXdqATO/0YlHdjfySrVG300HPkivWgZ6 1LLBEiD410o5RvtdH0JhQJf0L8eu3ypMjRsNACHHj6ECzyyegVUQZmI9efCXMPAfDy4vtW5aDqRMV 5KUi+mn/wfrIUQHQ14nVZidabQg+JCP0sI+ygL3zuhlDmjWo+Bs6MlWzPoupqsz8lK7YoBw7rRdlR 4V0kMoZA==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rWMeM-00Eh25-3M for pgsql-bugs@lists.postgresql.org; Sat, 03 Feb 2024 20:30:06 +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 1rWMeI-00G3X5-LC for pgsql-bugs@lists.postgresql.org; Sat, 03 Feb 2024 20:30:02 +0000 Content-Type: multipart/mixed; boundary="===============0807352739840678953==" MIME-Version: 1.0 Subject: BUG #18327: Column naming inconsistency for boolean literals in ELSE clauses of CASE expressions. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: work.michael.2956@gmail.com Reply-To: work.michael.2956@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 03 Feb 2024 20:29:56 +0000 Message-ID: <18327-f25f77a50d104716@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 --===============0807352739840678953== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODMyNwpMb2dnZWQgYnk6ICAgICAgICAgIE1pY2hhZWwgQm9uZGFyZW5r bwpFbWFpbCBhZGRyZXNzOiAgICAgIHdvcmsubWljaGFlbC4yOTU2QGdtYWlsLmNvbQpQb3N0Z3Jl U1FMIHZlcnNpb246IDE0LjEwCk9wZXJhdGluZyBzeXN0ZW06ICAgTWFjT1MgU29ub21hIDE0LjEu MSAoMjNCODEpCkRlc2NyaXB0aW9uOiAgICAgICAgCgpJJ20gcnVubmluZyBteSBxdWVyaWVzIG9u IHRoZSBUUEMtSCBzY2hlbWEsIHdoaWNoIGNhbiBiZSBmb3VuZCBhdDoKaHR0cHM6Ly9naXRodWIu Y29tL2RpbWl0cmkvdHBjaC1jaXR1cy9ibG9iL21hc3Rlci9zY2hlbWEvdHBjaC1zY2hlbWEuc3Fs DQoNCkkgZm91bmQgdGhlIGZvbGxvd2luZyBpbmNvbnNpc3RlbmN5Og0KDQpgYGANCnRwY2g9IyBz ZWxlY3QgY2FzZSB3aGVuIHRydWUgdGhlbiB0cnVlIGVsc2UgdHJ1ZSBlbmQ7DQogY2FzZSANCi0t LS0tLQ0KIHQNCigxIHJvdykNCg0KdHBjaD0jIHNlbGVjdCBjYXNlIHdoZW4gdHJ1ZSB0aGVuIHRy dWUgZWxzZSAoc2VsZWN0IHRydWUpIGVuZDsNCiBib29sIA0KLS0tLS0tDQogdA0KKDEgcm93KQ0K YGBgDQoNCkFzIHlvdSBjYW4gc2VlLCB0aGUgYXV0by1nZW5lcmF0ZWQgYWxpYXNlcyBkbyBub3Qg Y29ycmVzcG9uZC4gVGhlIGV4cGVjdGVkCmJlaGF2aW91ciB3YXMgZm9yIHRoZSBmaXJzdCBxdWVy eSB0byBhbHNvIG5hbWUgdGhlIGNvbHVtbiAnYm9vbCcuDQoNCkkgYmFzZSBteSBleHBlY3RhdGlv bnMgb246DQoNCjEpIFRoaXMgcXVlcnkgbmFtaW5nIHRoZSByZXN1bHQgJ2Jvb2wnOg0KYGBgDQp0 cGNoPSMgc2VsZWN0IHRydWU7DQogYm9vbCANCi0tLS0tLQ0KIHQNCigxIHJvdykNCmBgYA0KDQoy KSBUaGVzZSBxdWVyaWVzIHByb3BhZ2F0aW5nIHRoZSBjb2x1bW4gbmFtZSBmcm9tIHRoZSBlbHNl IGNsYXVzZSBvZiB0aGUKY2FzZSBleHByZXNzaW9uOg0KMi4xKSBQcm9wYWdhdGlvbiBvZiB0aGUg YWdncmVnYXRlIGZ1bmN0aW9uIG5hbWUNCmBgYA0KdHBjaD0jIHNlbGVjdCBjYXNlIHdoZW4gdHJ1 ZSB0aGVuIHRydWUgZWxzZSBib29sX29yKHRydWUpIGVuZDsNCiBib29sX29yIA0KLS0tLS0tLS0t DQogdA0KKDEgcm93KQ0KYGBgDQoyLjIpIFByb3BhZ2F0aW9uIG9mIHRoZSBbY29tcG91bmRdIGNv bHVtbiBpZGVudGlmaWVyOg0KYGBgDQp0cGNoPSMgc2VsZWN0IGNhc2Ugd2hlbiB0cnVlIHRoZW4g MSBlbHNlIHQxLm5fbmF0aW9ua2V5IGVuZCBmcm9tIG5hdGlvbiBhcwp0MSBsaW1pdCAxOw0KIG5f bmF0aW9ua2V5IA0KLS0tLS0tLS0tLS0tLQ0KICAgICAgICAgICAxDQooMSByb3cpDQpgYGANCjIu MykgUHJvcGFnYXRpb24gb2YgdGhlIHNpbXBsZSBjb2x1bW4gaWRlbnRpZmllcjoNCmBgYA0KdHBj aD0jIHNlbGVjdCBjYXNlIHdoZW4gdHJ1ZSB0aGVuIDEgZWxzZSBuX25hdGlvbmtleSBlbmQgZnJv bSBuYXRpb24gbGltaXQKMTsNCiBuX25hdGlvbmtleSANCi0tLS0tLS0tLS0tLS0NCiAgICAgICAg ICAgMQ0KKDEgcm93KQ0KYGBgDQoyLjQpIEFuZCBldmVuIG5lc3RlZCBjYXNlIGV4cHJlc3Npb25z Og0KYGBgDQp0cGNoPSMgc2VsZWN0IGNhc2Ugd2hlbiB0cnVlIHRoZW4gMSBlbHNlICgNCiAgICBj YXNlIHdoZW4gdHJ1ZSB0aGVuIDEgZWxzZSB0MS5uX25hdGlvbmtleSBlbmQNCikgZW5kIGZyb20g bmF0aW9uIGFzIHQxIGxpbWl0IDE7DQogbl9uYXRpb25rZXkgDQotLS0tLS0tLS0tLS0tDQogICAg ICAgICAgIDENCigxIHJvdykNCmBgYAoK --===============0807352739840678953==--