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 1tt7ow-008uFy-Kg for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Mar 2025 16:23:39 +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 1tt7ov-00BBg8-8G for pgsql-bugs@arkaria.postgresql.org; Fri, 14 Mar 2025 16:23:37 +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 1tt7ii-00B1Yx-HQ for pgsql-bugs@lists.postgresql.org; Fri, 14 Mar 2025 16:17:13 +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.96) (envelope-from ) id 1tt7ib-002pY6-2c for pgsql-bugs@lists.postgresql.org; Fri, 14 Mar 2025 16:17:11 +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=LQG0iaOkANNU6DLbBezny+CfCgNO+EEFl7H64wMIh+Y=; b=RmhBvXEEzZc9sBDBb5YN4PSMeo 8kkviPOxWH3diEPZvJ2C4M55C9WL6YAGxLVqnQ5UiL0eGXqp6dJoXyrr5/Og2QTSh13DqiyHPBvix vD9EvD+DLLvqvD/otJK8BopsHknQkCZRiMxoMAVVaPCZQ1qHpsTuDnbl2XNnAFMQ5zhHdV0UqSbGj sk+KnR2+r3tQotUNZzWukLnTMFn16/rjVsHU4r+7JgxTzFL8mAn5fbdXAIuv+BUXJjR8Fkxip7EaE PVzT4mnQ57I3f1TbObM6bBhvtT1O7NvAaP6rbElH7Z1uBBPSvvnwvLl1E+lT3N1NNUTdMAnEsT1WA fh+ZFzfA==; 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 1tt7ib-007JwK-3H for pgsql-bugs@lists.postgresql.org; Fri, 14 Mar 2025 16:17: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 1tt7iZ-00Gwdi-Ps for pgsql-bugs@lists.postgresql.org; Fri, 14 Mar 2025 16:17:03 +0000 Content-Type: multipart/mixed; boundary="===============3751532735748705212==" MIME-Version: 1.0 Subject: BUG #18851: Queries with xxx NOT IN (SELECT xxx FROM table) fail to run (or run very slowly) on v17 (v14 ok) To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: joan@sanchezsabe.com Reply-To: joan@sanchezsabe.com, pgsql-bugs@lists.postgresql.org Date: Fri, 14 Mar 2025 16:16:06 +0000 Message-ID: <18851-5a0a9801290135d7@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 --===============3751532735748705212== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODg1MQpMb2dnZWQgYnk6ICAgICAgICAgIEpvYW4gU8OhbmNoZXogU2Fi w6kKRW1haWwgYWRkcmVzczogICAgICBqb2FuQHNhbmNoZXpzYWJlLmNvbQpQb3N0Z3JlU1FMIHZl cnNpb246IDE3LjQKT3BlcmF0aW5nIHN5c3RlbTogICBXaW5kb3dzIDExIDI0SDIgKDI2MTAwLjMx OTQpCkRlc2NyaXB0aW9uOiAgICAgICAgCgpJIGhhdmUgZXhwZXJpZW5jZWQgYSBtaXNiZWhhdmlv dXIgKElNSE8pIGluIFBvc3RncmVTUUwgMTcgdGhhdCBkaWRuJ3Qgb2NjdXIKaW4gUG9zdGdyZVNR TCAxNC4NCg0KTWluaW11bSByZXByb2R1Y2libGUgc2NlbmFyaW8gdG8gc2hvdyB0aGUgZXJyb3I6 DQoNCjEpIFRhYmxlIHdpdGggYSBwcmltYXJ5IGtleSAoaW50ZWdlcikgYW5kIDUwMF8wMDAgcmVj b3JkcyBvbiBpdC4NCg0KQ1JFQVRFIFRBQkxFIHQxIEFTDQooDQogICAgU0VMRUNUDQogICAgICAg IGlkDQogICAgRlJPTQ0KICAgICAgICBnZW5lcmF0ZV9zZXJpZXMoMSwgMTAwMDAwMCkgQVMgcyhp ZCkNCiAgICBPUkRFUiBCWQ0KICAgICAgICByYW5kb20oKQ0KICAgIExJTUlUDQogICAgICAgIDUw MDAwMA0KKSA7DQpBTFRFUiBUQUJMRSB0MQ0KICAgIEFERCBQUklNQVJZIEtFWSAoaWQpOw0KDQpB TkFMWVpFIHQxIDsNCg0KMikgU2Vjb25kIHRhYmxlLCB3aXRoIGEgc21hbGxlciAoMjAwXzAwMCkg bnVtYmVyIG9mIHZhbHVlcyBvZiB0aGUgc2FtZSB0eXBlLApzb21lIG9mIHRoZW0gb3ZlcmxhcHBp bmcgdGhlIGZpcnN0IHRhYmxlLCB3aXRob3V0IGEgcHJpbWFyeSBrZXkgKG5vciBhbnkKaW5kZXgp Lg0KDQpDUkVBVEUgVEFCTEUgdDIgQVMNCigNCiAgICBTRUxFQ1QNCiAgICAgICAgaWQNCiAgICBG Uk9NDQogICAgICAgIGdlbmVyYXRlX3NlcmllcygxLCAxMDAwMDAwKSBBUyBzKGlkKQ0KICAgIE9S REVSIEJZDQogICAgICAgIHJhbmRvbSgpDQogICAgTElNSVQNCiAgICAgICAgMjAwMDAwDQopIDsN Cg0KMykgVGhlIGZvbGxvd2luZyBxdWVyeSwgd2hpY2gganVzdCBsb29rcyBmb3IgdmFsdWVzIGlu IHQyIG5vdCBpbiB0MSwgdGFrZXMKYWJvdXQgMjAwIG1zIG9uIG15IGNvbXB1dGVyIHVzaW5nICJQ b3N0Z3JlU1FMIDE0LjE3LCBjb21waWxlZCBieSBWaXN1YWwgQysrCmJ1aWxkIDE5NDIsIDY0LWJp dCI7IHJ1bm5pbmcgb24gV2luZG93cyAxMSBQcm8gMjRIMiAoMjYxMDAuMzE5NCkuDQoNClNFTEVD VA0KICAgIHQyLmlkDQpGUk9NDQogICAgdDINCldIRVJFDQogICAgdDIuaWQgTk9UIElOIChTRUxF Q1QgaWQgRlJPTSB0MSkgOw0KDQpPdXRwdXQ6IGEgcmFuZG9tIGxpc3Qgb2YgYXJvdW5kIDEwMF8w MDAgbnVtYmVycy4NCiAgIA0KVGhlIHF1ZXJ5IHBsYW4gaXMgYXMgZm9sbG93czoNCg0KICAgIFNl cSBTY2FuIG9uIHB1YmxpYy50MiAgKGNvc3Q9ODQ2My4wMC4uMTE4NDguMDAgcm93cz0xMDAwMDAg d2lkdGg9NCkKKGFjdHVhbCB0aW1lPTEyMi4wOTMuLjE4Ni42Njggcm93cz05OTU2NiBsb29wcz0x KQ0KICAgICAgT3V0cHV0OiB0Mi5pZA0KICAgICAgRmlsdGVyOiAoTk9UIChoYXNoZWQgU3ViUGxh biAxKSkNCiAgICAgIFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDEwMDQzNA0KICAgICAgU3ViUGxh biAxDQogICAgICAgIC0+ICBTZXEgU2NhbiBvbiBwdWJsaWMudDEgIChjb3N0PTAuMDAuLjcyMTMu MDAgcm93cz01MDAwMDAgd2lkdGg9NCkKKGFjdHVhbCB0aW1lPTAuMDE3Li4yMC41NzMgcm93cz01 MDAwMDAgbG9vcHM9MSkNCiAgICAgICAgICAgICAgT3V0cHV0OiB0MS5pZA0KICAgIFBsYW5uaW5n IFRpbWU6IDAuMTczIG1zDQogICAgRXhlY3V0aW9uIFRpbWU6IDE5Mi4wMDIgbXMNCg0KWW91IGNh biBjaGVjayBhIChzbWFsbGlzaCkgdmVyc2lvbiBvbiBodHRwczovL2RiZmlkZGxlLnVrL2FIVEM4 WVFkDQoNCi0tLS0tLS0tDQpUaGUgc2FtZSBxdWVyeSwgZXhlY3V0ZWQgb24gIlBvc3RncmVTUUwg MTcuNCBvbiB4ODZfNjQtd2luZG93cywgY29tcGlsZWQgYnkKbXN2Yy0xOS40Mi4zNDQzNiwgNjQt Yml0KSIgdGFrZXMgImZvcmV2ZXIiLiBJIGFjdHVhbGx5IGdhdmUgdXAgYWZ0ZXIgMTAKbWludXRl cy4NCg0KVGhlIHF1ZXJ5IHBsYW4gd2FzOg0KDQogICAgU2VxIFNjYW4gb24gcHVibGljLnQyICAo Y29zdD0wLjAwLi4xMjk0NDAzMzk2LjAwIHJvd3M9MTAwMDAwIHdpZHRoPTQpDQogICAgICBPdXRw dXQ6IHQyLmlkDQogICAgICBGaWx0ZXI6IChOT1QgKEFOWSAodDIuaWQgPSAoU3ViUGxhbiAxKS5j b2wxKSkpDQogICAgICBTdWJQbGFuIDENCiAgICAgICAgLT4gIE1hdGVyaWFsaXplICAoY29zdD0w LjAwLi4xMTY5NC4wMCByb3dzPTUwMDAwMCB3aWR0aD00KQ0KICAgICAgICAgICAgICBPdXRwdXQ6 IHQxLmlkDQogICAgICAgICAgICAgIC0+ICBTZXEgU2NhbiBvbiBwdWJsaWMudDEgIChjb3N0PTAu MDAuLjcyNDAuMDAgcm93cz01MDAwMDAKd2lkdGg9NCkNCiAgICAgICAgICAgICAgICAgICAgT3V0 cHV0OiB0MS5pZA0KDQpUaGUgc2FtZSBxdWVyeSB3b3JrcyBvbiBzbWFsbGVyIHRhYmxlcyAoc2l6 ZXMgMTAwXzAwMCBhbmQgNDBfMDAwLApyZXNwZWN0aXZlbHk7IGkuZS46IDUgeCBzbWFsbGVyKS4g SW4gdGhhdCBjYXNlLCB0aGUgZXhlY3V0aW9uIHBsYW4gaXMgdGhlCnNhbWUgYXMgd2l0aCBQb3N0 Z3JlU1FMIDE0ICh3aXRoIHZhbHVlcyBkaXZpZGVkIGJ5IGFwcm94LiA1LCBhcyBleHBlY3RlZCkN Cg0KICAgIFNlcSBTY2FuIG9uIHB1YmxpYy50MiAgKGNvc3Q9MTY5OC4wMC4uMjUwMi4wMCByb3dz PTI0NDgwIHdpZHRoPTQpCihhY3R1YWwgdGltZT0yMC44MTMuLjI4LjgyNSByb3dzPTIwMDE2IGxv b3BzPTEpDQogICAgICBPdXRwdXQ6IHQyLmlkDQogICAgICBGaWx0ZXI6IChOT1QgKEFOWSAodDIu aWQgPSAoaGFzaGVkIFN1YlBsYW4gMSkuY29sMSkpKQ0KICAgICAgUm93cyBSZW1vdmVkIGJ5IEZp bHRlcjogMTk5ODQNCiAgICAgIFN1YlBsYW4gMQ0KICAgICAgICAtPiAgU2VxIFNjYW4gb24gcHVi bGljLnQxICAoY29zdD0wLjAwLi4xNDQ4LjAwIHJvd3M9MTAwMDAwIHdpZHRoPTQpCihhY3R1YWwg dGltZT0wLjAxMy4uNC44NDQgcm93cz0xMDAwMDAgbG9vcHM9MSkNCiAgICAgICAgICAgICAgT3V0 cHV0OiB0MS5pZA0KICAgIFBsYW5uaW5nIFRpbWU6IDAuMjA1IG1zDQogICAgRXhlY3V0aW9uIFRp bWU6IDMwLjU2NSBtcw0KDQpTbywgaXQgc2VlbXMgdGhhdCB0aGUgcHJvYmxlbSBhcHBlYXJzIHdo ZW4gdGhlIGV4ZWN1dGlvbiBwbGFubmVyIGFkZHMgdGhlCiJNYXRlcmlhbGl6ZSIgbm9kZS4NCg0K SWYgbmVjZXNzYXJ5LCBJIGNhbiBhZGQgY29uZmlndXJhdGlvbiBmaWxlcyBmb3IgYm90aCB2ZXJz aW9ucyBvZgpQb3N0Z3JlU1FMLg0KDQpNYW55IHRoYW5rcyBpbiBhZHZhbmNlCgo= --===============3751532735748705212==--