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 1oiv8V-0005PV-Mm for pgsql-bugs@arkaria.postgresql.org; Thu, 13 Oct 2022 10:08:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oiv8U-0007DO-7K for pgsql-bugs@arkaria.postgresql.org; Thu, 13 Oct 2022 10:08:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oinzE-0005WX-8D for pgsql-bugs@lists.postgresql.org; Thu, 13 Oct 2022 02:30:16 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oinz6-0004ED-7S for pgsql-bugs@lists.postgresql.org; Thu, 13 Oct 2022 02:30:15 +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=kXFXly50gLBqoQ6gwg1lKZgpJk7JZzVakBc8QXzEYZQ=; b=mj0PCgMOmkvqKxxaMZLTnOj+vY htHNhWB9CoRG7trbFzV39JXnGnAWsdwDEhtyUsACPrSCJWCVmV3lBUm+6Hy0tToxDhP+xqX6oqRUR rodPKfFRR+Lh0BigiT2PlkDlGG2kJ5z3gkS4Yf6HofqPmOIVfhc79an1dPgAqWsx0jIIci8KWOq6d hqFWQUYkwGuZM45jt4E/U9sUqjzNX2BGMXnUy3yZxBVlUTBx5CFgg+svWrW8SIW+9DkmvKT6bG9pD Q3jcSPbNP+fF0eDbkHQ4br6DlPkptYyJ4Ep8YKsO1dbPcrHmgiVTGMo9UXESPFjvGhGqeXVm0KRjr iZUzIRuQ==; 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 1oinz4-00068G-FL for pgsql-bugs@lists.postgresql.org; Thu, 13 Oct 2022 02: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 1oinz0-005wP2-Tk for pgsql-bugs@lists.postgresql.org; Thu, 13 Oct 2022 02:30:02 +0000 Content-Type: multipart/mixed; boundary="===============2583226545864836015==" MIME-Version: 1.0 Subject: BUG #17637: case-when branches taken even if they dont match, raising errors To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: hctf90@gmail.com Reply-To: hctf90@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 13 Oct 2022 02:30:00 +0000 Message-ID: <17637-5904e3fdee533c7f@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 --===============2583226545864836015== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzYzNwpMb2dnZWQgYnk6ICAgICAgICAgIEZhY3VuZG8gRXRjaGV6YXIK RW1haWwgYWRkcmVzczogICAgICBoY3RmOTBAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTQuNQpPcGVyYXRpbmcgc3lzdGVtOiAgIERlYmlhbiAxMS4zLjAtMwpEZXNjcmlwdGlvbjogICAg ICAgIAoKSGkhIEkndmUgY29tZSBhY3Jvc3Mgc29tZSB3ZWlyZCBiZWhhdmlvci4gSSdtIGluc2Vy dGluZyBhIHJvdyBpbnRvIGEgdGFibGUsCmFuZCBJIHBhcnNlL2Nhc3QgYSB0ZXh0IGNvbHVtbiBp biBvbmUgd2F5IG9yIHRoZSBvdGhlciBkZXBlbmRpbmcgb24gdGhlCnJlc3VsdCBvZiBhIGpvaW4g d2l0aCBhIGNhc2Utd2hlbiBleHByZXNzaW9uLiBUaGUgaXNzdWUgaXMgdGhhdCBmb3Igc29tZQpy ZWFzb24gaXQgc2VlbXMgdGhlIGJyYW5jaGVzIHRoYXQgYXJlbid0IHRha2VuIGFyZSBldmFsdWF0 ZWQgYW55d2F5LCB3aGljaAppbiB0dXJuIHJhaXNlcyBhIGNhc3QgZXJyb3IuIEhlcmUgaXMgYSB0 aW55IHJlcHJvIHdoZXJlIEkgbWFrZSB0d28gdGFibGVzCmFuZCB0aGVuIHRyeSB0byBpbnNlcnQg aW4gdGhlIHRlc3QgdGFibGUgYSBmbG9hdDggb3IgYm9vbCB2YWx1ZSBiYXNlZCBvbiB0aGUKcmVz dWx0IG9mIHRoZSBqb2luZWQgdG1hcCB0YWJsZS4NCg0KVGhpcyB0aW55IHJlcHJvIGJlbG93IHJh aXNlcyB0aGUgZXJyb3IgU1FMIEVycm9yIFsyMlAwMl06IEVSUk9SOiBpbnZhbGlkCmlucHV0IHN5 bnRheCBmb3IgdHlwZSBib29sZWFuOiAiMTIzLjQiIExpa2UgaXQncyB0cnlpbmcgdG8gcGFyc2Ug dGhlIHRleHQKY29sdW1uIGFzIGJvb2wgZXZlbiBpZiBpdCBzaG91bGRuJ3QgcmVhY2ggdGhhdCBw YXJ0IG9mIHRoZSBjYXNlLXdoZW4uDQoNCmRyb3AgdGFibGUgaWYgZXhpc3RzIHRlc3Q7DQpkcm9w IHRhYmxlIGlmIGV4aXN0cyB0bWFwOw0KY3JlYXRlIHRhYmxlIHRlc3QoDQogaWQgaW50OCwNCiB2 ZiBmbG9hdDgsDQogdmIgYm9vbA0KKTsNCmNyZWF0ZSB0YWJsZSB0bWFwKA0KIGlkIGludDgsDQog bWFwcGVkX3RvIGludDgNCik7DQppbnNlcnQgaW50byB0bWFwIHZhbHVlcygxLCAxKTsNCmluc2Vy dCBpbnRvIHRtYXAgdmFsdWVzKDIsIDIpOw0KaW5zZXJ0IGludG8gdGVzdCANCndpdGggdG1wIGFz IChzZWxlY3QgMTo6aW50OCBpZCwgJzEyMy40Jzo6dGV4dCB2KQ0Kc2VsZWN0IHQuaWQsDQpjYXNl IG0ubWFwcGVkX3RvIHdoZW4gMSB0aGVuIHY6OmZsb2F0OCBlbHNlIG51bGwgZW5kLA0KY2FzZSBt Lm1hcHBlZF90byB3aGVuIDIgdGhlbiB2Ojpib29sIGVsc2UgbnVsbCBlbmQNCmZyb20gdG1wIHQN CmpvaW4gdG1hcCBtIG9uIG0uaWQgPSB0LmlkOw0KDQpXZWlyZGx5IGVub3VnaCBpZiB5b3UgZm9y ZWdvIHRoZSBqb2luLCBkb2luZyB0aGlzIGJlbG93LCBpdCB3b3JrcyBmaW5lOg0KDQpkcm9wIHRh YmxlIGlmIGV4aXN0cyB0ZXN0Ow0KY3JlYXRlIHRhYmxlIHRlc3QoDQogaWQgaW50OCwNCiB2ZiBm bG9hdDgsDQogdmIgYm9vbA0KKTsNCmluc2VydCBpbnRvIHRlc3QgDQp3aXRoIHRtcCBhcyAoc2Vs ZWN0IDE6OmludDggaWQsICcxMjMuNCc6OnRleHQgdikNCnNlbGVjdCB0LmlkLA0KY2FzZSB0Lmlk IHdoZW4gMSB0aGVuIHY6OmZsb2F0OCBlbHNlIG51bGwgZW5kLA0KY2FzZSB0LmlkIHdoZW4gMiB0 aGVuIHY6OmJvb2wgZWxzZSBudWxsIGVuZA0KZnJvbSB0bXAgdDsNCg0KVGhpcyBzaG91bGQgcmVz dWx0IGluIHRoZSBzYW1lIGJlaGF2aW9yIHlldCBpdCB3b3JrcyBmaW5lLCB3aXRob3V0IHRocm93 aW5nCmFuIGVycm9yLg0KDQpJJ3ZlIGFsc28gdGVzdGVkIHRoaXMgaW4gaHR0cHM6Ly93d3cuZGIt ZmlkZGxlLmNvbSB3aXRoIHZlcnNpb25zIDE1IGJldGEsCjEzLCAxMi4gQWxsIHdpdGggdGhlIHNh bWUgZXJyb3IuIFZlcnNpb25zIDExIGFuZCAxMCBzZWVtIHRvIHdvcmsgZmluZS4NCg0KVGhhbmsg eW91IGZvciB5b3VyIHRpbWUuCgo= --===============2583226545864836015==--