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 1nZvFv-0007Ti-6p for pgsql-bugs@arkaria.postgresql.org; Thu, 31 Mar 2022 13:54:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nZvFt-0000YL-CW for pgsql-bugs@arkaria.postgresql.org; Thu, 31 Mar 2022 13:54:29 +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 1nZv4w-0002BE-9R for pgsql-bugs@lists.postgresql.org; Thu, 31 Mar 2022 13:43:10 +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 1nZv4t-0005PL-UT for pgsql-bugs@lists.postgresql.org; Thu, 31 Mar 2022 13:43:09 +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=p9HsLAwMA1wASn9nw5isRdANE7G6dQSDZSoHgH/x1Pc=; b=KmXE+BO0YcG5bIwMyYxetJV2+x ZFYdtNHj2RY3eeLc1w/V2L4FPkYx6Uccssdov1arm4Whz2Wxak5lpx13u+oTeJ29fDf5YJ5pApwmK ifw0MaWeTIXvgptPhDFNpHvOtGljOh0lW+8ngvvs32hhrX2jsJAclWP3Pt7qlAWFnArhaOsdjIj89 IFBjJ3EGrZ/tfH63knYSTEOWv8Qw0vqSDqkAMQSmlXoho7HvVi/jgQ6cSqV8SftKB9Gm/8EsbZXZF T+NY7pr3+02/JgCE2smygzWIV2CB+PA8udQ2Dq5+DcV55F1VZd7kY7y8VS5b85YuH3a9BQVGOYSZS Qr/WUMtg==; 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 1nZv4r-00065T-4E for pgsql-bugs@lists.postgresql.org; Thu, 31 Mar 2022 13:43: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 1nZv4n-000hvn-Te for pgsql-bugs@lists.postgresql.org; Thu, 31 Mar 2022 13:43:02 +0000 Content-Type: multipart/mixed; boundary="===============7634357346904422464==" MIME-Version: 1.0 Subject: BUG #17452: IN caluse behaves differently when there is one item comapred to when multiple To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: andreas@proxel.se Reply-To: andreas@proxel.se, pgsql-bugs@lists.postgresql.org Date: Thu, 31 Mar 2022 13:42:05 +0000 Message-ID: <17452-d10a023545015922@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 --===============7634357346904422464== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzQ1MgpMb2dnZWQgYnk6ICAgICAgICAgIEFuZHJlYXMgS2FybHNzb24K RW1haWwgYWRkcmVzczogICAgICBhbmRyZWFzQHByb3hlbC5zZQpQb3N0Z3JlU1FMIHZlcnNpb246 IDE0LjIKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eCBhbmQgTWFjIGF0IGxlYXN0CkRlc2NyaXB0 aW9uOiAgICAgICAgCgpIaSwNCg0KSSBub3RpY2VkIHRoYXQgdGhlIG9wdGltaXphdGlvbiAoaW4g dHJhbnNmb3JtQUV4cHJJbigpKSBmb3IgdGhlIGNhc2Ugd2hlcmUKdGhlcmUgaXMgYW4gSU4gKC4u Likgd2l0aCBvbmx5IG9uZSBpdGVtIGJyZWFrcyBjZXJ0YWluIHF1ZXJpZXMuIE9mIGNvdXJzZSBp dAppcyBhbHNvIHBvc3NpYmxlIHRoYXQgaXQgaXMgdGhlIHNpbmdsZS1pdGVtIGNhc2Ugd2hpY2gg aXMgY29ycmVjdCBhbmQgdGhlCm11bHRpcGxlLWl0ZW0gY2FzZSB3aGljaCBpcyBicm9rZW4uIFRo ZSBjYXNlIHdoZXJlIEkgZm91bmQgdGhpcyBiZWhhdmlvciB3YXMKY2F1c2VkIGJ5IHRoZSBjYXN0 aW5nIHJ1bGVzIGFyb3VuZCB0aGUgcmVnKiB0eXBlcyBidXQgdGhlcmUgY291bGQgYmUgb3RoZXIK c2ltaWxhciBpc3N1ZXMuDQoNCkhlcmUgaXMgYSBzaW1wbGlmaWVkIGV4YW1wbGUgYmFzZWQgb24g YSByZWFsIHF1ZXJ5Og0KDQojIFNFTEVDVCB2ZXJzaW9uKCk7DQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIHZlcnNpb24gICAgICAgICAgICAg CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIFBv c3RncmVTUUwgMTQuMiAoRGViaWFuIDE0LjItMS5wZ2RnMTIwKzErYjIpIG9uIHg4Nl82NC1wYy1s aW51eC1nbnUsCmNvbXBpbGVkIGJ5IGdjYyAoRGViaWFuIDExLjIuMC0xOCkgMTEuMi4wLCA2NC1i aXQNCigxIHJvdykNCg0KIyBTRUxFQ1QgJ3ZlcnNpb24nOjpyZWdwcm9jIElOICgndmVyc2lvbicp Ow0KRVJST1I6ICBpbnZhbGlkIGlucHV0IHN5bnRheCBmb3IgdHlwZSBvaWQ6ICJ2ZXJzaW9uIg0K TElORSAxOiBTRUxFQ1QgJ3ZlcnNpb24nOjpyZWdwcm9jIElOICgndmVyc2lvbicpOw0KICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBeDQojIFNFTEVDVCAndmVyc2lvbic6OnJl Z3Byb2MgSU4gKCd2ZXJzaW9uJywgJ3ZlcnNpb24nKTsNCiA/Y29sdW1uPyANCi0tLS0tLS0tLS0N CiB0DQooMSByb3cpDQoNCkJlc3QgcmVnYXJkcywNCkFuZHJlYXMKCg== --===============7634357346904422464==--