Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TJSuP-0000IX-NV for pgsql-committers@postgresql.org; Wed, 03 Oct 2012 17:38:57 +0000 Received: from mahout.postgresql.org ([98.129.198.123]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TJSuL-0001pi-Va for pgsql-committers@postgresql.org; Wed, 03 Oct 2012 17:38:57 +0000 Received: from [98.129.198.116] (helo=gemulon.postgresql.org) by mahout.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TJSuK-0000ED-O4 for pgsql-committers@postgresql.org; Wed, 03 Oct 2012 17:38:52 +0000 Received: from git by gemulon.postgresql.org with local (Exim 4.72) (envelope-from ) id 1TJSuK-0003md-69 for pgsql-committers@postgresql.org; Wed, 03 Oct 2012 17:38:52 +0000 Date: Wed, 03 Oct 2012 17:38:52 +0000 Message-Id: Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 To: pgsql-committers@postgresql.org From: Tom Lane Subject: pgsql: Avoid planner crash/Assert failure with joins to unflattened sub X-Pg-Spam-Score: -4.0 (----) X-Archive-Number: 201210/50 X-Sequence-Number: 49359 QXZvaWQgcGxhbm5lciBjcmFzaC9Bc3NlcnQgZmFpbHVyZSB3aXRoIGpvaW5zIHRvIHVuZmxhdHRl bmVkIHN1YnF1ZXJpZXMuCgpleGFtaW5lX3NpbXBsZV92YXJpYWJsZSBzdXBwb3NlZCB0aGF0IGFu eSBSVEVfU1VCUVVFUlkgcmVsIGl0IGdldHMgcG9pbnRlZAphdCBtdXN0IGhhdmUgYmVlbiBwbGFu bmVkIGFscmVhZHkuICBIb3dldmVyLCB0aGlzIGlzbid0IGEgc2FmZSBhc3N1bXB0aW9uCmJlY2F1 c2Ugd2UgbXVzdCBkbyBzZWxlY3Rpdml0eSBlc3RpbWF0aW9uIHdoaWxlIGdlbmVyYXRpbmcgaW5k ZXhzY2FuIHBhdGhzLAphbmQgdGhhdCBjb2RlIG1pZ2h0IGxvb2sgYXQgam9pbiBjbGF1c2VzIGlu dm9sdmluZyBhIHJlbCB0aGF0IHRoZSBsb29wIGluCnNldF9iYXNlX3JlbF9zaXplcygpIGhhc24n dCByZWFjaGVkIHlldC4gIFRoZSBzaW1wbGVzdCBmaXggaXMgdG8gcGxheSBkdW1iCmluIHN1Y2gg YSBzaXR1YXRpb24sIHRoYXQgaXMgZ2l2ZSB1cCB0cnlpbmcgdG8gZXh0cmFjdCBhbnkgc3RhdHMg Zm9yIHRoZQpWYXIuICBUaGlzIGNvdWxkIHBvc3NpYmx5IGJlIGltcHJvdmVkIGJ5IG1ha2luZyBh IHNlcGFyYXRlIHBhc3Mgb3ZlciB0aGUKUlRFIGxpc3QgdG8gcGxhbiBlYWNoIHVuZmxhdHRlbmVk IHN1YnF1ZXJ5IGJlZm9yZSB3ZSBzdGFydCB0aGUgbWFpbgpwbGFubmluZyB3b3JrIC0tLSBidXQg dGhhdCB3b3VsZCBiZSBwcmV0dHkgaW52YXNpdmUgYW5kIGl0IGRvZXNuJ3Qgc2VlbQp3b3J0aCBp dCwgZm9yIG5vdyBhdCBsZWFzdC4gIChXZSBjb3VsZG4ndCBqdXN0IGJyZWFrIHNldF9iYXNlX3Jl bF9zaXplcygpCmludG8gdHdvIGxvb3BzOiB0aGUgcHJlc2NhbiB3b3VsZCBuZWVkIHRvIGhhbmRs ZSBhbGwgc3VicXVlcnkgcmVscyBpbiB0aGUKcXVlcnksIG5vdCBvbmx5IHRob3NlIGluIHRoZSBj dXJyZW50IGpvaW4gc3VicHJvYmxlbS4pCgpUaGlzIGJ1ZyB3YXMgaW50cm9kdWNlZCBpbiBjb21t aXQgMWNiMTA4ZWZiMGU2MGQ4N2U0YWRlYzM4ZTc2MzZiNmU4ZWZiZWI1NywKYWx0aG91Z2ggSSB0 aGluayB0aGF0IHN1YnNlcXVlbnQgY2hhbmdlcyBtYXkgaGF2ZSBleHBvc2VkIGl0IG1vcmUgdGhh biBpdAp3YXMgb3JpZ2luYWxseS4gIFBlciBidWcgIzc1ODAgZnJvbSBNYXhpbSBCb2d1ay4KCkJy YW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cDovL2dpdC5wb3N0Z3Jlc3Fs Lm9yZy9wZy9jb21taXRkaWZmLzFmOTFjOGNhMWQyZWRjNjZjNjg4ZWU3MTllZGVkNzllY2QwZThm MWIKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9z ZWxmdW5jcy5jIHwgICAgNiArKysrLS0KMSBmaWxlcyBjaGFuZ2VkLCA0IGluc2VydGlvbnMoKyks IDIgZGVsZXRpb25zKC0pCgo=