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 1lt9Y9-0001h1-CS for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jun 2021 13:56:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lt9Y8-0001rb-4H for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jun 2021 13:56:16 +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 1lt9Y7-0001rS-TQ for pgsql-bugs@lists.postgresql.org; Tue, 15 Jun 2021 13:56:15 +0000 Received: from smtp03.optiver.com ([195.246.114.70]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lt9Y5-0003Ef-1y for pgsql-bugs@lists.postgresql.org; Tue, 15 Jun 2021 13:56:15 +0000 Received: from pps.filterd (smtp03.optiver.com [127.0.0.1]) by smtp03.optiver.com (8.16.0.42/8.16.0.42) with SMTP id 15FDkojg024862; Tue, 15 Jun 2021 15:56:12 +0200 Received: from opammb0562.comp.optiver.com (opammb0562.comp.optiver.com [10.131.160.2]) by smtp03.optiver.com with ESMTP id 396j8b0frw-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-SHA384 bits=256 verify=NOT); Tue, 15 Jun 2021 15:56:12 +0200 Received: from opammb0562.comp.optiver.com (10.131.160.2) by opammb0562.comp.optiver.com (10.131.160.2) with Microsoft SMTP Server (TLS) id 15.0.1497.18; Tue, 15 Jun 2021 15:56:11 +0200 Received: from opammb0562.comp.optiver.com ([fe80::f88f:f345:d769:f129]) by opammb0562.comp.optiver.com ([fe80::f88f:f345:d769:f129%17]) with mapi id 15.00.1497.018; Tue, 15 Jun 2021 15:56:11 +0200 From: Floris Van Nee To: Pantelis Theodosiou , "pgsql-bugs@lists.postgresql.org" Thread-Topic: Postgres turns LEFT JOIN into INNER JOIN - incorrect results [External] Thread-Index: AQHXYe0G4vOOZZmHZ0uNwgXkhN+K6qsVF8mQ Date: Tue, 15 Jun 2021 13:56:10 +0000 Message-ID: <928a013baac445b2b280d6ab3ad78fa5@opammb0562.comp.optiver.com> References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.131.160.182] x-tm-as-product-ver: SMEX-14.0.0.3031-8.6.1012-26222.000 x-tm-as-result: No-10--2.333400-5.000000 x-tmase-matchedrid: VPleTT1nwdQnOSkKKt9ulBvgzEPRJaDEKQNhMboqZloTiSW9r3PknHmp YhpUpTLtI1K6BTvWHFy3OZm/AfC3ZsO8HCp69vyLdhnFihmbnwVr2qJoNIuCjaaYOpHIeBwh8z7 0XDTUjsY4OrXgRmQaY1HhfKSz2XBNe0KdwKqkb5qOtWfhyZ77DsO+wkQncuC8/dFcowvugkueAi CmPx4NwHJnzNw42kCx2bNx1HEv7HAqtq5d3cxkNffvWahKfRU4EVIZbjiVU1f+ZWUKhmLOOVwbW ABJw4Z6/u7Z11dwlZo/OyUap0r1rtT6PR8YFBC6tZh2+vNVh4TAP/w3hApJhzVRH1PZHURvPJXc PkgxEwmbYLZwudds349pbpRrbisdIMW4USIcKqueqD9WtJkSIw== x-tm-as-user-approved-sender: Yes x-tm-as-user-blocked-sender: No x-tmase-result: 10--2.333400-5.000000 x-tmase-version: SMEX-14.0.0.3031-8.6.1012-26222.000 x-tm-snts-smtp: E84A056E14A01D7D3D20A8F6035839DC6462D606B9AE2B948CB8740880530B072000:8 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 Subject: RE: Postgres turns LEFT JOIN into INNER JOIN - incorrect results X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:6.0.391,18.0.761 definitions=2021-06-15_04:2021-06-14,2021-06-15 signatures=0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk DQo+IEl0IHdvcmtzIGNvcnJlY3RseSBpZiB5b3UgcmVuYW1lIHRoZSBjb2x1bW4gbmFtZSB0byBh bnl0aGluZyBvdGhlciB0aGFuIF9hIDoNCj4gDQo+wqAgwqAgQ1JFQVRFIE9SIFJFUExBQ0UgRlVO Q1RJT04gdGVzdF9pbnRlcm5hbChfYSB0ZXh0KQ0KPiDCoCBSRVRVUk5TIFRBQkxFKGEgdGV4dCnC oCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCDCoCAtLSA8LSBkaWZmZXJlbnQgdGhhbiBfYQ0K PsKgIMKgIExBTkdVQUdFIHNxbA0KDQoNCj4gSXQgYWxzbyB3b3JrcyBpZiB5b3UgcmVuYW1lIHRo ZSBwYXJhbWV0ZXIgKF9hKSBoZXJlIHdpdGggc29tZXRoaW5nIGVsc2UuDQoNCkFoLCBvZiBjb3Vy c2UhIFNvcnJ5IGZvciB0aGUgY29uZnVzaW9uLi4gVGhlIHJldHVybiBjb2x1bW4gc2hhZG93cyB0 aGUgcGFyYW1ldGVyIGluIHRoZSBvdXRlciBmdW5jdGlvbi4uLg0KVGhhbmtzIGZvciB0aGUgZXhw bGFuYXRpb24hIE5vIGJ1ZywganVzdCBhY2NpZGVudGFsbHkgbmFtaW5nIHRoZSByZXR1cm5lZCBj b2x1bW4gd3JvbmcuDQoNCi1GbG9yaXMNCg0K