Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TJSuP-0000IO-4k 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-0001ph-VD for pgsql-committers@postgresql.org; Wed, 03 Oct 2012 17:38:56 +0000 Received: from [98.129.198.116] (helo=gemulon.postgresql.org) by mahout.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TJSuK-0000EC-T5 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-0003mf-7G 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/49 X-Sequence-Number: 49358 QXZvaWQgcGxhbm5lciBjcmFzaC9Bc3NlcnQgZmFpbHVyZSB3aXRoIGpvaW5zIHRvIHVuZmxhdHRl bmVkIHN1YnF1ZXJpZXMuCgpleGFtaW5lX3NpbXBsZV92YXJpYWJsZSBzdXBwb3NlZCB0aGF0IGFu eSBSVEVfU1VCUVVFUlkgcmVsIGl0IGdldHMgcG9pbnRlZAphdCBtdXN0IGhhdmUgYmVlbiBwbGFu bmVkIGFscmVhZHkuICBIb3dldmVyLCB0aGlzIGlzbid0IGEgc2FmZSBhc3N1bXB0aW9uCmJlY2F1 c2Ugd2UgbXVzdCBkbyBzZWxlY3Rpdml0eSBlc3RpbWF0aW9uIHdoaWxlIGdlbmVyYXRpbmcgaW5k ZXhzY2FuIHBhdGhzLAphbmQgdGhhdCBjb2RlIG1pZ2h0IGxvb2sgYXQgam9pbiBjbGF1c2VzIGlu dm9sdmluZyBhIHJlbCB0aGF0IHRoZSBsb29wIGluCnNldF9iYXNlX3JlbF9zaXplcygpIGhhc24n dCByZWFjaGVkIHlldC4gIFRoZSBzaW1wbGVzdCBmaXggaXMgdG8gcGxheSBkdW1iCmluIHN1Y2gg YSBzaXR1YXRpb24sIHRoYXQgaXMgZ2l2ZSB1cCB0cnlpbmcgdG8gZXh0cmFjdCBhbnkgc3RhdHMg Zm9yIHRoZQpWYXIuICBUaGlzIGNvdWxkIHBvc3NpYmx5IGJlIGltcHJvdmVkIGJ5IG1ha2luZyBh IHNlcGFyYXRlIHBhc3Mgb3ZlciB0aGUKUlRFIGxpc3QgdG8gcGxhbiBlYWNoIHVuZmxhdHRlbmVk IHN1YnF1ZXJ5IGJlZm9yZSB3ZSBzdGFydCB0aGUgbWFpbgpwbGFubmluZyB3b3JrIC0tLSBidXQg dGhhdCB3b3VsZCBiZSBwcmV0dHkgaW52YXNpdmUgYW5kIGl0IGRvZXNuJ3Qgc2VlbQp3b3J0aCBp dCwgZm9yIG5vdyBhdCBsZWFzdC4gIChXZSBjb3VsZG4ndCBqdXN0IGJyZWFrIHNldF9iYXNlX3Jl bF9zaXplcygpCmludG8gdHdvIGxvb3BzOiB0aGUgcHJlc2NhbiB3b3VsZCBuZWVkIHRvIGhhbmRs ZSBhbGwgc3VicXVlcnkgcmVscyBpbiB0aGUKcXVlcnksIG5vdCBvbmx5IHRob3NlIGluIHRoZSBj dXJyZW50IGpvaW4gc3VicHJvYmxlbS4pCgpUaGlzIGJ1ZyB3YXMgaW50cm9kdWNlZCBpbiBjb21t aXQgMWNiMTA4ZWZiMGU2MGQ4N2U0YWRlYzM4ZTc2MzZiNmU4ZWZiZWI1NywKYWx0aG91Z2ggSSB0 aGluayB0aGF0IHN1YnNlcXVlbnQgY2hhbmdlcyBtYXkgaGF2ZSBleHBvc2VkIGl0IG1vcmUgdGhh biBpdAp3YXMgb3JpZ2luYWxseS4gIFBlciBidWcgIzc1ODAgZnJvbSBNYXhpbSBCb2d1ay4KCkJy YW5jaAotLS0tLS0KUkVMOV8yX1NUQUJMRQoKRGV0YWlscwotLS0tLS0tCmh0dHA6Ly9naXQucG9z dGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi80OWJmMTQ2YjdhZDBiMTc1MWZiNGQxNTg1MzMwNmRh YmYxY2U4M2M2CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC91dGls cy9hZHQvc2VsZnVuY3MuYyB8ICAgIDYgKysrKy0tCjEgZmlsZXMgY2hhbmdlZCwgNCBpbnNlcnRp b25zKCspLCAyIGRlbGV0aW9ucygtKQoK