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 1hDUOg-0002z4-EN for pgsql-bugs@arkaria.postgresql.org; Mon, 08 Apr 2019 13:33:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hDUOe-0003il-Rd for pgsql-bugs@arkaria.postgresql.org; Mon, 08 Apr 2019 13:33:12 +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 1hDUOe-0003ie-KM for pgsql-bugs@lists.postgresql.org; Mon, 08 Apr 2019 13:33:12 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hDUOX-0000ag-8y for pgsql-bugs@lists.postgresql.org; Mon, 08 Apr 2019 13:33:12 +0000 Content-Type: multipart/mixed; boundary="===============5175088469045072820==" MIME-Version: 1.0 Subject: BUG #15741: ERROR: failed to build any 3-way joins To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: skorski.anthony@gmail.com Reply-To: skorski.anthony@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 08 Apr 2019 13:32:44 +0000 Message-ID: <15741-276f1f464b3f40eb@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============5175088469045072820== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTc0MQpMb2dnZWQgYnk6ICAgICAgICAgIEFudGhvbnkgU0tPUlNLSQpF bWFpbCBhZGRyZXNzOiAgICAgIHNrb3Jza2kuYW50aG9ueUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2 ZXJzaW9uOiAxMC42Ck9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDE4LjA0CkRlc2NyaXB0aW9u OiAgICAgICAgCgpIaQ0KDQpUcnlpbmcgdG8gYnVpbGQgYSB0b29sIHdoaWNoIGF1dG9tYXRpY2Fs bHkgYnVpbGRzIHF1ZXJpZXMgdG8gImZsYXR0ZW4iIEpTT05CCmZpZWxkcywgSSBjYW1lIHRvIGEg YEVSUk9SOiBmYWlsZWQgdG8gYnVpbGQgYW55IDMtd2F5IGpvaW5zYCBtZXNzYWdlIHdoaWxlCnRy eWluZyB0byBleGVjdXRlIHNvbWUgb2YgdGhvc2UgcXVlcmllcy4NCg0KSXQgaXMgcmVwcm9kdWNp YmxlIGZyb20gYSBzaW1wbGUgdGFibGUuLi4NCmBDUkVBVEUgVEFCTEUgcmFuZG9tX3RhYmxlIChy YW5kb21fZmllbGQgSlNPTkIpO2ANCg0KLi4uIHNvbWUgSlNPTiBkYXRhIGluIG5lc3RlZCBhcnJh eXMgLi4uDQpgSU5TRVJUIElOVE8gcHVibGljLnJhbmRvbV90YWJsZSAocmFuZG9tX2ZpZWxkKSBW QUxVRVMgKCd7ImJhciI6IFtbWzEsIDIsIDMsCjRdXV0sICJmb28iOiBbW1siYWJjIiwgImRlZiJd LCBbInR1dyIsICJ4eXoiXV1dfScpO2ANCg0KLi4uIGFuZCBhIFdJUCBxdWVyeSB0byBmbGF0dGVu IHRoaXMgSlNPTiBkYXRhLg0KYGBgDQpTRUxFQ1QgKg0KRlJPTSByYW5kb21fdGFibGUNCiAgICBM RUZUIE9VVEVSIEpPSU4gTEFURVJBTCAoDQogICAgICAgIFNFTEVDVCAqDQogICAgICAgIEZST00g anNvbmJfYXJyYXlfZWxlbWVudHMocmFuZG9tX3RhYmxlLnJhbmRvbV9maWVsZCAtPiAnZm9vJykN CiAgICAgICAgICAgIFdJVEggT1JESU5BTElUWSBBUyBmb29fbGV2ZWxfMShmb29fMSwgZm9vXzFf aW5kZXgpDQogICAgICAgIExFRlQgT1VURVIgSk9JTiBMQVRFUkFMICgNCiAgICAgICAgICAgIFNF TEVDVCAqDQogICAgICAgICAgICBGUk9NIGpzb25iX2FycmF5X2VsZW1lbnRzKGZvb18xKQ0KICAg ICAgICAgICAgICAgIFdJVEggT1JESU5BTElUWSBBUyBmb29fbGV2ZWxfMihmb29fMiwgZm9vXzJf aW5kZXgpDQogICAgICAgICAgICAtLUxFRlQgT1VURVIgSk9JTiBMQVRFUkFMICgNCiAgICAgICAg ICAgIC0tICAgIFNFTEVDVCAqDQogICAgICAgICAgICAtLSAgICBGUk9NIGpzb25iX2FycmF5X2Vs ZW1lbnRzKGZvb18yKQ0KICAgICAgICAgICAgLS0gICAgICAgIFdJVEggT1JESU5BTElUWSBBUyBm b29fbGV2ZWxfMyhmb29fMywgZm9vXzNfaW5kZXgpDQogICAgICAgICAgICAtLSkgQVMgZm9vX2xh dGVyYWxfMiBPTiBUUlVFDQogICAgICAgICkgQVMgZm9vX2xhdGVyYWxfMSBPTiBUUlVFDQoNCiAg ICAgICAgRlVMTCBPVVRFUiBKT0lOIGpzb25iX2FycmF5X2VsZW1lbnRzKHJhbmRvbV90YWJsZS5y YW5kb21fZmllbGQgLT4KJ2JhcicpDQogICAgICAgICAgICBXSVRIIE9SRElOQUxJVFkgQVMgYmFy X2xldmVsXzEoYmFyXzEsIGJhcl8xX2luZGV4KSBPTiBGQUxTRQ0KICAgICAgICBMRUZUIE9VVEVS IEpPSU4gTEFURVJBTCAoDQogICAgICAgICAgICBTRUxFQ1QgKg0KICAgICAgICAgICAgRlJPTSBq c29uYl9hcnJheV9lbGVtZW50cyhiYXJfMSkNCiAgICAgICAgICAgICAgICBXSVRIIE9SRElOQUxJ VFkgQVMgYmFyX2xldmVsXzIoYmFyXzIsIGJhcl8yX2luZGV4KQ0KICAgICAgICApIEFTIGJhcl9s YXRlcmFsXzEgT04gVFJVRQ0KICAgICkgQVMgcG91ZXQgT04gVFJVRTsNCmBgYA0KDQpOb3RlIHRo ZSBjb21tZW50ZWQgcGFydC4gQXMgaXMgdGhlIHF1ZXJ5IHdvcmtzIGFzIGV4cGVjdGVkIChmb3Ig aXRzIFdJUApzc3RhdHVzKS4NCk9uY2UgdW5jb21tZW50ZWQsIHRoZSBgRVJST1I6IGZhaWxlZCB0 byBidWlsZCBhbnkgMy13YXkgam9pbnNgIG9jY3VycyBhbmQgSQpkaWQgbm90IGZpbmQgYW55dGhp bmcgYWJvdXQgc3VjaCBhIHBvdGVudGlhbCBQb3N0Z3Jlc3FsIGxpbWl0YXRpb24gb3IgYW55Cndv cmthcm91bmQuDQoNClRoaXMgYmVoYXZpb3Igb2NjdXJzIG9uIGV2ZXJ5IFBvc3RncmVzIHZlcnNp b24gSSB0ZXN0ZWQuIEEgZmlkZGxlIGlzCmF2YWlsYWJsZSBoZXJlIHRvIGhpZ2hsaWdodCB0aGUg cHJvYmxlbToKaHR0cHM6Ly9kYmZpZGRsZS51ay8/cmRibXM9cG9zdGdyZXNfMTAmZmlkZGxlPTBj NDBiYTc1MGIzZTQ3N2UwMDJmODc5ZWRkMGQ2ODQxDQoNClBsZWFzZSBsZXQgbWUga25vdyBpZiBp dCBhY3R1YWxseSBpcyBhIGJ1ZyBhbmQgaWYgaXQgaGFzIGEgY2hhbmNlIHRvIGJlCmZpeGVkLg0K DQpSZWdhcmRzLgoK --===============5175088469045072820==--