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 1oIca4-00071Y-2k for pgsql-bugs@arkaria.postgresql.org; Mon, 01 Aug 2022 21:04:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oIca1-0000qo-HJ for pgsql-bugs@arkaria.postgresql.org; Mon, 01 Aug 2022 21:04:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIWp2-00007b-LS for pgsql-bugs@lists.postgresql.org; Mon, 01 Aug 2022 14:55:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIWoy-0007hX-EQ for pgsql-bugs@lists.postgresql.org; Mon, 01 Aug 2022 14:55:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=mw5vOUfe+aT9TM76MBfyHxoeSFMm4IT0bWkgi5x5IMI=; b=K+gwS6VA4xsMeET42Ew3GEhC7u iAz6GTsDQBMKJuX/TwVoOPiJUaZBWoMsx2nqfs7B6MfS50IPJvLEL+AYFX9HtkHZo1ExdJoe2jl1f DDoQjrUBTOh5JrRGWsJJ2dZkTjOfXb7FZ9a9U7fXpVsO2QqKeajF2ki4xpR1Z0URWpp3pXae0fHu4 oduNlTj9epNOqQNyVaM21psMGh+sODBCjvneV4DxStj1WBALDg/SxAWBmY3DmMwb7kvBNcueodZaa wGtqtnAkhu45pD6XcmRMHJEnI3dQCCQWtW/Fe7jcpesK1+zHQFxH111tXIPrbHABVrY3mR7cEnkhV LcStxSTA==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIWox-0004XI-PK for pgsql-bugs@lists.postgresql.org; Mon, 01 Aug 2022 14:55:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1oIWov-00B6qA-BP for pgsql-bugs@lists.postgresql.org; Mon, 01 Aug 2022 14:55:01 +0000 Content-Type: multipart/mixed; boundary="===============4685397012451485550==" MIME-Version: 1.0 Subject: BUG #17564: Planner bug in combination of generate_series(), unnest() and ORDER BY To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kleptog@gmail.com Reply-To: kleptog@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 01 Aug 2022 14:54:30 +0000 Message-ID: <17564-c7472c2f90ef2da3@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4685397012451485550== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzU2NApMb2dnZWQgYnk6ICAgICAgICAgIE1hcnRpam4gdmFuIE9vc3Rl cmhvdXQKRW1haWwgYWRkcmVzczogICAgICBrbGVwdG9nQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZl cnNpb246IDE0LjQKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gTGludXggKEJ1bGxzZXllKQpE ZXNjcmlwdGlvbjogICAgICAgIAoKV2UgcmFuIGludG8gYSBzdHJhbmdlIHBsYW5uZXIgaXNzdWUg b24gb3VyIHByb2R1Y3Rpb24gc3lzdGVtIG9uIEZyaWRheS4KQmFzaWNhbGx5LCBhIHF1ZXJ5IHdv dWxkIGZhaWwgaW4gdGhlIHBsYW5uaW5nIHN0YWdlLCBkZXBlbmRpbmcgb25lIG9mIHRoZQpwYXJh bWV0ZXJzLiBUaGlzIHNob3VsZG4ndCBoYXBwZW4gKEFJVUkpLiBUaGUgcXVlcnkgaXMgYXMgZm9s bG93cwooc2ltcGxpZmllZCBjb25zaWRlcmFibHkgZnJvbSB0aGUgb3JpZ2luYWwpOg0KDQpkYj0j IGV4cGxhaW4gU0VMRUNUIGdlbmVyYXRlX3N1YnNjcmlwdHMoQVJSQVlbXTo6aW50ZWdlcltdLCAx KSBBUyBpZCwgDQogICAgICAgdW5uZXN0KEFSUkFZW106Ompzb25iW10pIC0+PiAndGltZXN0YW1w JyAgQVMgdGltZXN0YW1wIA0KRlJPTSByZXN1bHRzIA0KSk9JTiBncm91cHMgT04gZ3JvdXBzLmlk ID0gcmVzdWx0cy5ncm91cF9pZCANCldIRVJFIHJlc3VsdHMuc2VhcmNoX2lkID0gMzMzNiANCm9y ZGVyIGJ5IHRpbWVzdGFtcDsNCg0KKFllcywgSSBrbm93IHRoZSBjb21iaW5hdGlvbiBvZiB1bm5l c3QoKSBhbmQgZ2VuZXJhdGVfc3Vic2NyaXB0cygpIGluIHRoaXMKd2F5IGlzIGV2aWwsIGJ1dCBp dCBkb2VzIHdvcmsuKQ0KDQpUaGUgZXJyb3IgaXM6DQoNCkVSUk9SOiAgc2V0LXZhbHVlZCBmdW5j dGlvbiBjYWxsZWQgaW4gY29udGV4dCB0aGF0IGNhbm5vdCBhY2NlcHQgYSBzZXQNCkxJTkUgMjog ICAgICAgIHVubmVzdChBUlJBWVtdOjpqc29uYltdKSAtPj4gJ3RpbWVzdGFtcCcgIEFTIHRpbWVz dGFtLi4uDQoNCkhvd2V2ZXIsIGlmIHlvdSBkaXNhYmxlIG5lc3RlZCBsb29wcywgaXQgd29ya3Mg ZmluZToNCg0KZGI9IyBzZXQgZW5hYmxlX25lc3Rsb29wID1mYWxzZTsNClNFVA0KZGI9IyBleHBs YWluIFNFTEVDVCBnZW5lcmF0ZV9zdWJzY3JpcHRzKEFSUkFZW106OmludGVnZXJbXSwgMSkgQVMg aWQsIA0KICAgICAgIHVubmVzdChBUlJBWVtdOjpqc29uYltdKSAtPj4gJ3RpbWVzdGFtcCcgIEFT IHRpbWVzdGFtcCANCkZST00gcmVzdWx0cyANCkpPSU4gZ3JvdXBzIE9OIGdyb3Vwcy5pZCA9IHJl c3VsdHMuZ3JvdXBfaWQgDQpXSEVSRSByZXN1bHRzLnNlYXJjaF9pZCA9IDMzMzYgDQpvcmRlciBi eSB0aW1lc3RhbXA7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIFFVRVJZIFBMQU4gICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBTb3J0ICAoY29zdD01NDUyMy4xOS4u NTU0NzguMTkgcm93cz0zODIwMDAgd2lkdGg9MzYpDQogICBTb3J0IEtleTogKCgodW5uZXN0KCd7 fSc6Ompzb25iW10pKSAtPj4gJ3RpbWVzdGFtcCc6OnRleHQpKQ0KICAgLT4gIFJlc3VsdCAgKGNv c3Q9MTkuNzUuLjg2NTguMTUgcm93cz0zODIwMDAgd2lkdGg9MzYpDQogICAgICAgICAtPiAgUHJv amVjdFNldCAgKGNvc3Q9MTkuNzUuLjE5NzMuMTUgcm93cz0zODIwMDAgd2lkdGg9MzYpDQogICAg ICAgICAgICAgICAtPiAgSGFzaCBKb2luICAoY29zdD0xOS43NS4uNTkuMzMgcm93cz0zODIgd2lk dGg9MCkNCiAgICAgICAgICAgICAgICAgICAgIEhhc2ggQ29uZDogKGdyb3Vwcy5pZCA9IHJlc3Vs dHMuZ3JvdXBfaWQpDQogICAgICAgICAgICAgICAgICAgICAtPiAgU2VxIFNjYW4gb24gZ3JvdXBz ICAoY29zdD0wLjAwLi4zNi41NCByb3dzPTExNTQKd2lkdGg9NCkNCiAgICAgICAgICAgICAgICAg ICAgIC0+ICBIYXNoICAoY29zdD0xNC45Ny4uMTQuOTcgcm93cz0zODIgd2lkdGg9NCkNCiAgICAg ICAgICAgICAgICAgICAgICAgICAgIC0+ICBJbmRleCBPbmx5IFNjYW4gdXNpbmcgcmVzdWx0c19w a2V5IG9uIHJlc3VsdHMKIChjb3N0PTAuMjkuLjE0Ljk3IHJvd3M9MzgyIHdpZHRoPTQpDQogICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBJbmRleCBDb25kOiAoc2VhcmNoX2lkID0gMzMz NikNCigxMCByb3dzKQ0KDQpJZiB5b3UgcmVtb3ZlIHRoZSBPUkRFUiBCWSwgaXQgd29ya3MuDQoN CklmIHlvdSByZW1vdmUgdGhlIGdlbmVyYXRlX3NlcmllcygpLCBpdCB3b3Jrcy4NCg0KSWYgeW91 IHJlbW92ZSB0aGUgSk9JTiwgaXQgd29ya3MuDQoNCklmIHlvdSByZW1vdmUgdGhlICItPj4gJ3Rp bWVzdGFtcCciLCBpdCB3b3Jrcy4NCg0KSWYgeW91IHdyYXAgdGhlIHF1ZXJ5IGluIGEgc3VicXVl cnkgd2l0aG91dCB0aGUgT1JERVIgQlksIGFuZCB0aGVuIHRoZSBwdXQKdGhlIE9SREVSIEJZIG9u IHRoYXQsIGl0IHdvcmtzLiBMaWtlIHNvOg0KDQpleHBsYWluIFNFTEVDVCAqIEZST00gKFNFTEVD VCBnZW5lcmF0ZV9zdWJzY3JpcHRzKEFSUkFZW106OmludGVnZXJbXSwgMSkgQVMKaWQsIA0KICAg ICAgIHVubmVzdChBUlJBWVtdOjpqc29uYltdKSAtPj4gJ3RpbWVzdGFtcCcgIEFTIHRpbWVzdGFt cCANCkZST00gcmVzdWx0cyANCkpPSU4gZ3JvdXBzIE9OIGdyb3Vwcy5pZCA9IHJlc3VsdHMuZ3Jv dXBfaWQgDQpXSEVSRSByZXN1bHRzLnNlYXJjaF9pZCA9IDMzMzYpIHgNCm9yZGVyIGJ5IHRpbWVz dGFtcDsNCg0KVGhpcyBnaXZlcyB0aGUgc2FtZSBxdWVyeSBwbGFuIGFzIGFib3ZlIGFmdGVyIGRp c2FibGluZyB0aGUgbmVzdGVkIGxvb3BzLg0KDQpXaGF0IGFwcGVhcnMgdG8gYmUgaGFwcGVuaW5n IGlzIHRoYXQgdGhlIHBsYW5uZXIgYXR0ZW1wdHMgYSB0cmFuc2Zvcm1hdGlvbgphbmQgcGxhY2Vz IHRoZSB1bm5lc3QoKSBpbiB0aGUgT1JERVIgQlkgc3RhdGVtZW50IHJlcGxhY2luZyB0aGUgcmVm ZXJlbmNlIHRvCnRoZSAidGltZXN0YW1wIiBmaWVsZCB3aXRoIHRoZSBhY3R1YWwgZXhwcmVzc2lv bi4gVGhlcmUgdW5uZXN0KCkgaXMgY2xlYXJseQpub3QgYWxsb3dlZC4gUGVyaGFwcyB0aGUgZmFj dCB0aGF0IHRoZSB1bm5lc3QoKSBpcyBoaWRkZW4gYmVuZWF0aCB0aGUKb3BlcmF0b3IoLT4+KSBw cmV2ZW50cyB0aGUgcGxhbm5lciBmcm9tIG5vdGljaW5nIHRoZSB0cmFuc2Zvcm1hdGlvbiBpcyBu b3QKcGVybWl0dGVkLg0KDQpUaGlzIGlzIGEgcGFpbiB0byByZXByb2R1Y2UuIEp1c3QgZHVtcGlu ZyBhcmUgcmVzdG9yaW5nIHRoZSB0YWJsZXMgZWxzZXdoZXJlCmRpZCBub3Qgd29yay4gV2Ugbm90 aWNlZCB0aGF0IHRoZSAncmVzdWx0cycgdGFibGUgaW4gcHJvZHVjdGlvbiB3YXMgcXVpdGUKYmxv YXRlZCBhbmQgd2hlbiB3ZSByZXBsaWNhdGVkIHRoYXQgaW4gdGhlIHRlc3QgZW52aXJvbm1lbnQs IGl0IGZpbmFsbHkKdHJpZ2dlcmVkLiBBdCBsZWFzdCBhdCAzMDAlIGJsb2F0IGl0IHRyaWdnZXJl ZCwgdGhhdCBwcm9iYWJseSB0cmlnZ2VycyB0aGUKcGxhbm5lciB0byB0cnkgc29tZSBvdGhlciBw bGFucy4NCg0KVGhpcyBpcyBub3QgYSBjcml0aWNhbCBidWcsIHNpbmNlIGl0IGlzIGVhc2lseSB3 b3JrZWQgYXJvdW5kIGFuZCB0aGUKY29tYmluYXRpb24gb2YgY29uZGl0aW9ucyBzZWVtcyBxdWl0 ZSB1bnVzdWFsLg0KDQpOb3RpY2VkIGluIDEzLjQsIHJlcHJvZHVjZWQgaW4gMTMuNyBhbmQgMTQu NC4NCg0KSGF2ZSBhIG5pY2UgZGF5LA0KTWFydGlqbgoK --===============4685397012451485550==--