Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hd7mt-0005Dc-QH for pgsql-bugs@arkaria.postgresql.org; Tue, 18 Jun 2019 06:40:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hd7mr-0002YJ-TW for pgsql-bugs@arkaria.postgresql.org; Tue, 18 Jun 2019 06:40:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hd7mr-0002YC-Lg for pgsql-bugs@lists.postgresql.org; Tue, 18 Jun 2019 06:40:09 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hd7mo-0002JN-2G for pgsql-bugs@lists.postgresql.org; Tue, 18 Jun 2019 06:40:09 +0000 Content-Type: multipart/mixed; boundary="===============8164327332737010134==" MIME-Version: 1.0 Subject: BUG #15857: Parallel Hash Join makes join instead of exists To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: krujkov@gmail.com Reply-To: krujkov@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 18 Jun 2019 06:39:20 +0000 Message-ID: <15857-d1ba2a64bce0795e@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8164327332737010134== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTg1NwpMb2dnZWQgYnk6ICAgICAgICAgIFZsYWRpbWlyIEtyaXVrb3YK RW1haWwgYWRkcmVzczogICAgICBrcnVqa292QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDExLjMKT3BlcmF0aW5nIHN5c3RlbTogICBDZW50T1MgNwpEZXNjcmlwdGlvbjogICAgICAgIAoK Q1JFQVRFIFRBQkxFIGEoaWQgaW50KTsNCkFMVEVSIFRBQkxFIGEgQUREIENPTlNUUkFJTlQgYV9w a2V5IFBSSU1BUlkgS0VZKGlkKTsNCklOU0VSVCBJTlRPIGEoaWQpIFNFTEVDVCBnZW5lcmF0ZV9z ZXJpZXMoMSwgMTAwMDAwMCk7DQpJTlNFUlQgSU5UTyBhKGlkKSBTRUxFQ1QgZ2VuZXJhdGVfc2Vy aWVzKDEwMDAwMDEsIDEwMDAwMDAwKTsNCkNSRUFURSBUQUJMRSBiKGlkIGludCwgYmFzZV9pZCBp bnQpOw0KQUxURVIgVEFCTEUgYiBBREQgQ09OU1RSQUlOVCBiX3BrZXkgUFJJTUFSWSBLRVkoaWQp Ow0KSU5TRVJUIElOVE8gYiAoaWQpIHNlbGVjdCBnZW5lcmF0ZV9zZXJpZXMoMSwgMTAwMDAwMCk7 DQpVUERBVEUgYiBTRVQgYmFzZV9pZCA9IDEwMDAwMDAgLSBpZDsNCkNSRUFURSBUQUJMRSBjKGlk IGludCwgYmFzZV9pZCBpbnQpOw0KQUxURVIgVEFCTEUgYyBBREQgQ09OU1RSQUlOVCBjX3BrZXkg UFJJTUFSWSBLRVkoaWQpOw0KSU5TRVJUIElOVE8gYyAoaWQpIFNFTEVDVCBnZW5lcmF0ZV9zZXJp ZXMoMSwgMTAwMDAwMCk7DQpVUERBVEUgYyBTRVQgYmFzZV9pZCA9IGlkIC8gMTA7DQrigIsNClZB Q1VVTSBBTkFMWVpFOw0KU0VUIHJhbmRvbV9wYWdlX2Nvc3QgPSAxLjE7DQpTRVQgd29ya19tZW0g PSAnMzI3NmtCJzsNClNFVCBlZmZlY3RpdmVfY2FjaGVfc2l6ZSA9ICc5MEdCJzsNCuKAiw0KLS0g VGhpcyBnaXZlcyBhbiBpbmNvcnJlY3QgcmVzdWx0IG9mIDk5OTk5MSwgd2hlbiAxMDAwMDAgaXMg ZXhwZWN0ZWQgb24KUG9zdGdyZXMgMTEuMyBhbmQgMTIgYmV0YSAxLg0KU0VMRUNUIENPVU5UICgq KQ0KICBGUk9NIGENCiAgSk9JTiBiDQogICAgT04gYS5pZD1iLmJhc2VfaWQNCiBXSEVSRSBFWElT VFMgKA0KICAgICAgIFNFTEVDVCAxDQogICAgICAgICBGUk9NIGMNCiAgICAgICAgV0hFUkUgYy5i YXNlX2lkID0gYS5pZA0KICAgICAgICk7DQrigIsNCi0tIEp1c3QgZm9yIHRoZSByZWZlcmVuY2Us ICJiYWQiIHBsYW4gaGFzIHRoaXMgc2hhcGU6DQotLSBGaW5hbGl6ZSBBZ2dyZWdhdGUgIChjb3N0 PTYzMjExLjU4Li42MzIxMS41OSByb3dzPTEgd2lkdGg9OCkNCi0tICAgLT4gIEdhdGhlciAgKGNv c3Q9NjMyMTEuMzYuLjYzMjExLjU3IHJvd3M9MiB3aWR0aD04KQ0KLS0gICAgICAgICBXb3JrZXJz IFBsYW5uZWQ6IDINCi0tICAgICAgICAgLT4gIFBhcnRpYWwgQWdncmVnYXRlICAoY29zdD02MjIx MS4zNi4uNjIyMTEuMzcgcm93cz0xIHdpZHRoPTgpDQotLSAgICAgICAgICAgICAgIC0+ICBOZXN0 ZWQgTG9vcCAgKGNvc3Q9MTk4NTMuNDQuLjYyMjAxLjI1IHJvd3M9NDA0NQp3aWR0aD0wKQ0KLS0g ICAgICAgICAgICAgICAgICAgICAtPiAgUGFyYWxsZWwgSGFzaCBKb2luICAoY29zdD0xOTg1My4w MC4uNDI2MTQuNzgKcm93cz00MDU4MCB3aWR0aD04KQ0KLS0gICAgICAgICAgICAgICAgICAgICAg ICAgICBIYXNoIENvbmQ6IChiLmJhc2VfaWQgPSBjLmJhc2VfaWQpDQotLSAgICAgICAgICAgICAg ICAgICAgICAgICAgIC0+ICBQYXJhbGxlbCBTZXEgU2NhbiBvbiBiIAooY29zdD0wLjAwLi4xMzAx Ni42NyByb3dzPTQxNjY2NyB3aWR0aD00KQ0KLS0gICAgICAgICAgICAgICAgICAgICAgICAgICAt PiAgUGFyYWxsZWwgSGFzaCAgKGNvc3Q9MTMwMTYuNjcuLjEzMDE2LjY3CnJvd3M9NDE2NjY3IHdp ZHRoPTQpDQotLSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIC0+ICBQYXJhbGxlbCBT ZXEgU2NhbiBvbiBjIAooY29zdD0wLjAwLi4xMzAxNi42NyByb3dzPTQxNjY2NyB3aWR0aD00KQ0K LS0gICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXggT25seSBTY2FuIHVzaW5nIGFfcGtleSBv biBhIAooY29zdD0wLjQzLi4wLjQ4IHJvd3M9MSB3aWR0aD00KQ0KLS0gICAgICAgICAgICAgICAg ICAgICAgICAgICBJbmRleCBDb25kOiAoaWQgPSBiLmJhc2VfaWQpCgo= --===============8164327332737010134==--