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 1qRZht-002EM6-UH for pgsql-bugs@arkaria.postgresql.org; Thu, 03 Aug 2023 14:53:42 +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 1qRZhs-00EJjs-FP for pgsql-bugs@arkaria.postgresql.org; Thu, 03 Aug 2023 14:53:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qRZhs-00EJjk-6I for pgsql-bugs@lists.postgresql.org; Thu, 03 Aug 2023 14:53:40 +0000 Received: from mail.proses.de ([87.234.246.173]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qRZhq-000MIv-0V for pgsql-bugs@lists.postgresql.org; Thu, 03 Aug 2023 14:53:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=quipsy.de; s=seg; t=1691074417; bh=ufaNKtErJ70MwS8BpYC7U81TnrbCmoJY5bSnehhESeM=; h=From:To:CC:Subject:Date:References:In-Reply-To; b=WqykADu4o0gSuN5VdDw1uf81vGbNHFRhlrr8CHuzEiW6EFQuoVlBmfoOwJGn9e/fV zxaG8wUQa1wIVGAGDGcvZLdX6cwmr9De6E4uCgQVF3BvPnaqMmd6d80ODEcyQf9HtW WlyNJ995HwGiVvJwAZ9JbMBYLFYcLtUxaSS1z7oCCeEeSAOcVz3t5kGITOfo8Ac+yZ Wv9Q0hD4Cdx+V2YN1TeKnI7lCmLkBkq6sWxmGWyYe6yeUFQXiOWHcd2wT3/0jEFdVo s6c8HFEAbIPlm3kRKi0k/up49rRvdUf4u8yMhSSv+sCd1C4xYO65ZYvmd4EYWr8QAO Bttm3MeRKJL4Q== Received: from ProSeS-MX2016.proses.de (Not Verified[10.147.37.34]) by mail.proses.de with Trustwave SEG (v10,0,1,2030) id ; Thu, 03 Aug 2023 16:53:36 +0200 Received: from ProSeS-MX2016.proses.de (10.147.37.34) by ProSeS-MX2016.proses.de (10.147.37.34) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384) id 15.1.2242.10; Thu, 3 Aug 2023 16:53:36 +0200 Received: from ProSeS-MX2016.proses.de ([::1]) by ProSeS-MX2016.proses.de ([::1]) with mapi id 15.01.2242.010; Thu, 3 Aug 2023 16:53:36 +0200 From: "[Quipsy] Markus Karg" To: "David G. Johnston" CC: "pgsql-bugs@lists.postgresql.org" Subject: AW: WHERE column = X AND column = Y will always be zero matching rows Thread-Topic: WHERE column = X AND column = Y will always be zero matching rows Thread-Index: AdnGFY1ZyFwM9s1qTQibB1h7OxfWU///5nkA///doxA= Date: Thu, 3 Aug 2023 14:53:36 +0000 Message-ID: <81214324c32a4e6586e40d22b007c05e@quipsy.de> References: <1e15568107854a75ae8dd35a5a75daa7@quipsy.de> In-Reply-To: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.147.32.78] Content-Type: multipart/alternative; boundary="_000_81214324c32a4e6586e40d22b007c05equipsyde_" MIME-Version: 1.0 X-SEG-SpamProfiler-Analysis: v=2.4 cv=L6yj/8f8 c=1 sm=1 tr=0 ts=64cbbf70 a=hljXQ6ALYVQa6Cx5z6SxUg==:117 a=xqWC_Br6kY4A:10 a=O53yQbXMW-gA:10 a=UttIx32zK-AA:10 a=pGLkceISAAAA:8 a=epTmVMiNAAAA:8 a=gHgsOxOWrFzgBBpC5aIA:9 a=QEXdDO2ut3YA:10 a=yMhMjlubAAAA:8 a=SSmOFEACAAAA:8 a=_1qDNcvLToIiLjopUlMA:9 a=kMy0Txtrb_gJddCj:21 a=gKO2Hq4RSVkA:10 a=UiCQ7L4-1S4A:10 a=hTZeC7Yk6K0A:10 a=frz4AuCg-hUA:10 a=lqcHg5cX4UMA:10 a=rVnDm9A_-c-k2ki-JAcA:9 a=ndEWmUVY6Yapc0oHF_P4:22 X-SEG-SpamProfiler-Score: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_81214324c32a4e6586e40d22b007c05equipsyde_ Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 RGF2aWQsDQoNCnRoYW5rIHlvdSBmb3IgeW91ciBvcGluaW9uLCBzbyBpdCBpcyBhIGNoYW5jZSBm b3IgZnV0dXJlIG9wdGltaXphdGlvbi4NCg0KV2hldGhlciBvciBub3QgdGhpcyDigJ5zaG91bGQg bm90IGhhcHBlbuKAnCBpcyBhIGRpZmZlcmVudCBkaXNjdXNzaW9uLiDwn5iJDQoNCi1NYXJrdXMN Cg0KVm9uOiBEYXZpZCBHLiBKb2huc3RvbiA8ZGF2aWQuZy5qb2huc3RvbkBnbWFpbC5jb20+DQpH ZXNlbmRldDogRG9ubmVyc3RhZywgMy4gQXVndXN0IDIwMjMgMTY6NDgNCkFuOiBbUXVpcHN5XSBN YXJrdXMgS2FyZyA8a2FyZ0BxdWlwc3kuZGU+DQpDYzogcGdzcWwtYnVnc0BsaXN0cy5wb3N0Z3Jl c3FsLm9yZw0KQmV0cmVmZjogUmU6IFdIRVJFIGNvbHVtbiA9IFggQU5EIGNvbHVtbiA9IFkgd2ls bCBhbHdheXMgYmUgemVybyBtYXRjaGluZyByb3dzDQoNCk9uIFRodXJzZGF5LCBBdWd1c3QgMywg MjAyMywgW1F1aXBzeV0gTWFya3VzIEthcmcgPGthcmdAcXVpcHN5LmRlPG1haWx0bzprYXJnQHF1 aXBzeS5kZT4+IHdyb3RlOg0KRVhQTEFJTiBTRUxFQ1QgY29sdW1uIEZST00gVGFibGUgV0hFUkUg Y29sdW1uID0gWCBBTkQgY29sdW1uID0gWQ0KDQrigKZzYXlzIHRoYXQgUG9zdGdyZVNRTCBhY3R1 YWxseSB3YW50cyB0byBwZXJmb3JtIGEgU2NhbiENCg0KSSB3b25kZXIgd2h5IHNxdWFuZGVyaW5n IGFueSByZXNvdXJjZXMgaW50byBhIFNjYW4gaGVyZQ0KDQpNb3N0bHkgYmVjYXVzZSBubyBvbmUg d2FudHMgdG8gdm9sdW50ZWVyIHRvIHdyaXRlIGNvZGUgdG8gZGVhbCB3aXRoIHBvb3JseSB3cml0 dGVuIHF1ZXJpZXMsIG5vciwgbW9yZSB0ZWNobmljYWxseSwgZXhwZW5kIGNvbXB1dGUgcmVzb3Vy Y2VzIGxvb2tpbmcgZm9yIHNpdHVhdGlvbnMgdGhhdCBzaG91bGQgbm90IGhhcHBlbi4NCg0KRGF2 aWQgSi4NCg0K --_000_81214324c32a4e6586e40d22b007c05equipsyde_ Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: base64 PGh0bWwgeG1sbnM6dj0idXJuOnNjaGVtYXMtbWljcm9zb2Z0LWNvbTp2bWwiIHhtbG5zOm89InVy bjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmljZSIgeG1sbnM6dz0idXJuOnNjaGVt YXMtbWljcm9zb2Z0LWNvbTpvZmZpY2U6d29yZCIgeG1sbnM6bT0iaHR0cDovL3NjaGVtYXMubWlj cm9zb2Z0LmNvbS9vZmZpY2UvMjAwNC8xMi9vbW1sIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv VFIvUkVDLWh0bWw0MCI+DQo8aGVhZD4NCjxtZXRhIGh0dHAtZXF1aXY9IkNvbnRlbnQtVHlwZSIg Y29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PXV0Zi04Ij4NCjxtZXRhIG5hbWU9IkdlbmVyYXRv ciIgY29udGVudD0iTWljcm9zb2Z0IFdvcmQgMTUgKGZpbHRlcmVkIG1lZGl1bSkiPg0KPHN0eWxl PjwhLS0NCi8qIEZvbnQgRGVmaW5pdGlvbnMgKi8NCkBmb250LWZhY2UNCgl7Zm9udC1mYW1pbHk6 IkNhbWJyaWEgTWF0aCI7DQoJcGFub3NlLTE6MiA0IDUgMyA1IDQgNiAzIDIgNDt9DQpAZm9udC1m YWNlDQoJe2ZvbnQtZmFtaWx5OkNhbGlicmk7DQoJcGFub3NlLTE6MiAxNSA1IDIgMiAyIDQgMyAy IDQ7fQ0KLyogU3R5bGUgRGVmaW5pdGlvbnMgKi8NCnAuTXNvTm9ybWFsLCBsaS5Nc29Ob3JtYWws IGRpdi5Nc29Ob3JtYWwNCgl7bWFyZ2luOjBjbTsNCgltYXJnaW4tYm90dG9tOi4wMDAxcHQ7DQoJ Zm9udC1zaXplOjExLjBwdDsNCglmb250LWZhbWlseToiQ2FsaWJyaSIsc2Fucy1zZXJpZjt9DQph OmxpbmssIHNwYW4uTXNvSHlwZXJsaW5rDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCgljb2xv cjpibHVlOw0KCXRleHQtZGVjb3JhdGlvbjp1bmRlcmxpbmU7fQ0KYTp2aXNpdGVkLCBzcGFuLk1z b0h5cGVybGlua0ZvbGxvd2VkDQoJe21zby1zdHlsZS1wcmlvcml0eTo5OTsNCgljb2xvcjpwdXJw bGU7DQoJdGV4dC1kZWNvcmF0aW9uOnVuZGVybGluZTt9DQpwLm1zb25vcm1hbDAsIGxpLm1zb25v cm1hbDAsIGRpdi5tc29ub3JtYWwwDQoJe21zby1zdHlsZS1uYW1lOm1zb25vcm1hbDsNCgltc28t bWFyZ2luLXRvcC1hbHQ6YXV0bzsNCgltYXJnaW4tcmlnaHQ6MGNtOw0KCW1zby1tYXJnaW4tYm90 dG9tLWFsdDphdXRvOw0KCW1hcmdpbi1sZWZ0OjBjbTsNCglmb250LXNpemU6MTEuMHB0Ow0KCWZv bnQtZmFtaWx5OiJDYWxpYnJpIixzYW5zLXNlcmlmO30NCnNwYW4uRS1NYWlsRm9ybWF0dm9ybGFn ZTE4DQoJe21zby1zdHlsZS10eXBlOnBlcnNvbmFsLXJlcGx5Ow0KCWZvbnQtZmFtaWx5OiJDYWxp YnJpIixzYW5zLXNlcmlmOw0KCWNvbG9yOndpbmRvd3RleHQ7fQ0KLk1zb0NocERlZmF1bHQNCgl7 bXNvLXN0eWxlLXR5cGU6ZXhwb3J0LW9ubHk7DQoJZm9udC1mYW1pbHk6IkNhbGlicmkiLHNhbnMt c2VyaWY7DQoJbXNvLWZhcmVhc3QtbGFuZ3VhZ2U6RU4tVVM7fQ0KQHBhZ2UgV29yZFNlY3Rpb24x DQoJe3NpemU6NjEyLjBwdCA3OTIuMHB0Ow0KCW1hcmdpbjo3MC44NXB0IDcwLjg1cHQgMi4wY20g NzAuODVwdDt9DQpkaXYuV29yZFNlY3Rpb24xDQoJe3BhZ2U6V29yZFNlY3Rpb24xO30NCi0tPjwv c3R5bGU+PCEtLVtpZiBndGUgbXNvIDldPjx4bWw+DQo8bzpzaGFwZWRlZmF1bHRzIHY6ZXh0PSJl ZGl0IiBzcGlkbWF4PSIxMDI2IiAvPg0KPC94bWw+PCFbZW5kaWZdLS0+PCEtLVtpZiBndGUgbXNv IDldPjx4bWw+DQo8bzpzaGFwZWxheW91dCB2OmV4dD0iZWRpdCI+DQo8bzppZG1hcCB2OmV4dD0i ZWRpdCIgZGF0YT0iMSIgLz4NCjwvbzpzaGFwZWxheW91dD48L3htbD48IVtlbmRpZl0tLT4NCjwv aGVhZD4NCjxib2R5IGxhbmc9IkRFIiBsaW5rPSJibHVlIiB2bGluaz0icHVycGxlIj4NCjxkaXYg Y2xhc3M9IldvcmRTZWN0aW9uMSI+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0i bXNvLWZhcmVhc3QtbGFuZ3VhZ2U6RU4tVVMiPkRhdmlkLDxvOnA+PC9vOnA+PC9zcGFuPjwvcD4N CjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJtc28tZmFyZWFzdC1sYW5ndWFnZTpF Ti1VUyI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+ PHNwYW4gc3R5bGU9Im1zby1mYXJlYXN0LWxhbmd1YWdlOkVOLVVTIj50aGFuayB5b3UgZm9yIHlv dXIgb3Bpbmlvbiwgc28gaXQgaXMgYSBjaGFuY2UgZm9yIGZ1dHVyZSBvcHRpbWl6YXRpb24uPG86 cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5bGU9Im1z by1mYXJlYXN0LWxhbmd1YWdlOkVOLVVTIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48L3A+DQo8 cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0ibXNvLWZhcmVhc3QtbGFuZ3VhZ2U6RU4t VVMiPldoZXRoZXIgb3Igbm90IHRoaXMg4oCec2hvdWxkIG5vdCBoYXBwZW7igJwgaXMgYSBkaWZm ZXJlbnQgZGlzY3Vzc2lvbi4NCjwvc3Bhbj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6JnF1b3Q7 U2Vnb2UgVUkgRW1vamkmcXVvdDssc2Fucy1zZXJpZjttc28tZmFyZWFzdC1sYW5ndWFnZTpFTi1V UyI+JiMxMjg1MjE7PC9zcGFuPjxzcGFuIHN0eWxlPSJtc28tZmFyZWFzdC1sYW5ndWFnZTpFTi1V UyI+PG86cD48L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PHNwYW4gc3R5 bGU9Im1zby1mYXJlYXN0LWxhbmd1YWdlOkVOLVVTIj48bzpwPiZuYnNwOzwvbzpwPjwvc3Bhbj48 L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48c3BhbiBzdHlsZT0ibXNvLWZhcmVhc3QtbGFuZ3Vh Z2U6RU4tVVMiPi1NYXJrdXM8bzpwPjwvbzpwPjwvc3Bhbj48L3A+DQo8cCBjbGFzcz0iTXNvTm9y bWFsIj48c3BhbiBzdHlsZT0ibXNvLWZhcmVhc3QtbGFuZ3VhZ2U6RU4tVVMiPjxvOnA+PC9vOnA+ PC9zcGFuPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPjxzcGFuIHN0eWxlPSJtc28tZmFyZWFz dC1sYW5ndWFnZTpFTi1VUyI+PG86cD4mbmJzcDs8L286cD48L3NwYW4+PC9wPg0KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+PGI+Vm9uOjwvYj4gRGF2aWQgRy4gSm9obnN0b24gJmx0O2RhdmlkLmcuam9o bnN0b25AZ21haWwuY29tJmd0OyA8YnI+DQo8Yj5HZXNlbmRldDo8L2I+IERvbm5lcnN0YWcsIDMu IEF1Z3VzdCAyMDIzIDE2OjQ4PGJyPg0KPGI+QW46PC9iPiBbUXVpcHN5XSBNYXJrdXMgS2FyZyAm bHQ7a2FyZ0BxdWlwc3kuZGUmZ3Q7PGJyPg0KPGI+Q2M6PC9iPiBwZ3NxbC1idWdzQGxpc3RzLnBv c3RncmVzcWwub3JnPGJyPg0KPGI+QmV0cmVmZjo8L2I+IFJlOiBXSEVSRSBjb2x1bW4gPSBYIEFO RCBjb2x1bW4gPSBZIHdpbGwgYWx3YXlzIGJlIHplcm8gbWF0Y2hpbmcgcm93czxvOnA+PC9vOnA+ PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8cCBjbGFz cz0iTXNvTm9ybWFsIj5PbiBUaHVyc2RheSwgQXVndXN0IDMsIDIwMjMsIFtRdWlwc3ldIE1hcmt1 cyBLYXJnICZsdDs8YSBocmVmPSJtYWlsdG86a2FyZ0BxdWlwc3kuZGUiPmthcmdAcXVpcHN5LmRl PC9hPiZndDsgd3JvdGU6PG86cD48L286cD48L3A+DQo8YmxvY2txdW90ZSBzdHlsZT0iYm9yZGVy Om5vbmU7Ym9yZGVyLWxlZnQ6c29saWQgI0NDQ0NDQyAxLjBwdDtwYWRkaW5nOjBjbSAwY20gMGNt IDYuMHB0O21hcmdpbi1sZWZ0OjQuOHB0O21hcmdpbi1yaWdodDowY20iPg0KPGRpdj4NCjxkaXY+ DQo8cCBjbGFzcz0iTXNvTm9ybWFsIiBzdHlsZT0ibXNvLW1hcmdpbi10b3AtYWx0OmF1dG87bXNv LW1hcmdpbi1ib3R0b20tYWx0OmF1dG8iPkVYUExBSU4gU0VMRUNUIGNvbHVtbiBGUk9NIFRhYmxl IFdIRVJFIGNvbHVtbiA9IFggQU5EIGNvbHVtbiA9IFk8bzpwPjwvbzpwPjwvcD4NCjxwIGNsYXNz PSJNc29Ob3JtYWwiIHN0eWxlPSJtc28tbWFyZ2luLXRvcC1hbHQ6YXV0bzttc28tbWFyZ2luLWJv dHRvbS1hbHQ6YXV0byI+Jm5ic3A7PG86cD48L286cD48L3A+DQo8cCBjbGFzcz0iTXNvTm9ybWFs IiBzdHlsZT0ibXNvLW1hcmdpbi10b3AtYWx0OmF1dG87bXNvLW1hcmdpbi1ib3R0b20tYWx0OmF1 dG8iPuKApnNheXMgdGhhdCBQb3N0Z3JlU1FMIGFjdHVhbGx5IHdhbnRzIHRvIHBlcmZvcm0gYSBT Y2FuITxvOnA+PC9vOnA+PC9wPg0KPHAgY2xhc3M9Ik1zb05vcm1hbCIgc3R5bGU9Im1zby1tYXJn aW4tdG9wLWFsdDphdXRvO21zby1tYXJnaW4tYm90dG9tLWFsdDphdXRvIj4mbmJzcDs8bzpwPjwv bzpwPjwvcD4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiIHN0eWxlPSJtc28tbWFyZ2luLXRvcC1hbHQ6 YXV0bzttc28tbWFyZ2luLWJvdHRvbS1hbHQ6YXV0byI+SSB3b25kZXIgd2h5IHNxdWFuZGVyaW5n IGFueSByZXNvdXJjZXMgaW50byBhIFNjYW4gaGVyZTxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8 L2Rpdj4NCjwvYmxvY2txdW90ZT4NCjxkaXY+DQo8cCBjbGFzcz0iTXNvTm9ybWFsIj48bzpwPiZu YnNwOzwvbzpwPjwvcD4NCjwvZGl2Pg0KPGRpdj4NCjxwIGNsYXNzPSJNc29Ob3JtYWwiPk1vc3Rs eSBiZWNhdXNlIG5vIG9uZSB3YW50cyB0byB2b2x1bnRlZXIgdG8gd3JpdGUgY29kZSB0byBkZWFs IHdpdGggcG9vcmx5IHdyaXR0ZW4gcXVlcmllcywgbm9yLCBtb3JlIHRlY2huaWNhbGx5LCBleHBl bmQgY29tcHV0ZSByZXNvdXJjZXMgbG9va2luZyBmb3Igc2l0dWF0aW9ucyB0aGF0IHNob3VsZCBu b3QgaGFwcGVuLjxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9Ik1zb05v cm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8L2Rpdj4NCjxkaXY+DQo8cCBjbGFzcz0iTXNv Tm9ybWFsIj5EYXZpZCBKLjxvOnA+PC9vOnA+PC9wPg0KPC9kaXY+DQo8ZGl2Pg0KPHAgY2xhc3M9 Ik1zb05vcm1hbCI+PG86cD4mbmJzcDs8L286cD48L3A+DQo8L2Rpdj4NCjwvZGl2Pg0KPC9ib2R5 Pg0KPC9odG1sPg0K --_000_81214324c32a4e6586e40d22b007c05equipsyde_--