Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1epF5x-00084Y-LX for pgsql-bugs@arkaria.postgresql.org; Fri, 23 Feb 2018 15:17:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1epF5v-0001TQ-QC for pgsql-bugs@arkaria.postgresql.org; Fri, 23 Feb 2018 15:17:07 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1epF5v-0001TH-KX for pgsql-bugs@lists.postgresql.org; Fri, 23 Feb 2018 15:17:07 +0000 Received: from wrigleys.postgresql.org ([204.145.124.246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1epF5r-0004Bp-Pe for pgsql-bugs@lists.postgresql.org; Fri, 23 Feb 2018 15:17:07 +0000 Content-Type: multipart/mixed; boundary="===============7045552684216912903==" MIME-Version: 1.0 Subject: BUG #15082: PostgreSQL 11 dev bug with window range partition by QUERY To: pgsql-bugs@lists.postgresql.org From: =?utf-8?q?PG_Bug_reporting_form?= Cc: digoal@126.com Reply-To: digoal@126.com, pgsql-bugs@lists.postgresql.org Date: Fri, 23 Feb 2018 15:16:39 +0000 Message-ID: <151939899974.1461.9411971793110285476@wrigleys.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7045552684216912903== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTA4MgpMb2dnZWQgYnk6ICAgICAgICAgIFpob3UgRGlnb2FsCkVtYWls IGFkZHJlc3M6ICAgICAgZGlnb2FsQDEyNi5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiBVbnN1cHBv cnRlZC9Vbmtub3duCk9wZXJhdGluZyBzeXN0ZW06ICAgQ2VudE9TIDcuNCB4NjQKRGVzY3JpcHRp b246ICAgICAgICAKCmBgYA0KY3JlYXRlIHRhYmxlIHQoDQogIHNpZCBpbnQsICAgICAtLSDlrabl j7cNCiAgc3ViIGludDIsICAgIC0tIOenkeebrg0KICBkZXMgdGV4dCwgICAgLS0g56eR55uu5o+P 6L+wDQogIHNjb3JlIGZsb2F0NCAgICAtLSDliIbmlbANCik7DQoNCg0KaW5zZXJ0IGludG8gdCB2 YWx1ZXMgDQogICgxLCAxLCAn6K+t5paHJywgODEpLA0KICAoMiwgMSwgJ+ivreaWhycsIDcxKSwN CiAgKDMsIDEsICfor63mlocnLCA5OSksDQogICg0LCAxLCAn6K+t5paHJywgMTAwKSwNCiAgKDUs IDEsICfor63mlocnLCAzMiksDQogICg2LCAxLCAn6K+t5paHJywgODkpLA0KICAoNywgMSwgJ+iv reaWhycsIDkwLjUpLA0KICAoMSwgMiwgJ+aVsOWtpicsIDgxKSwNCiAgKDIsIDIsICfmlbDlraYn LCA5NiksDQogICgzLCAyLCAn5pWw5a2mJywgNzgpLA0KICAoNCwgMiwgJ+aVsOWtpicsIDkwKSwN CiAgKDUsIDIsICfmlbDlraYnLCAxMiksDQogICg2LCAyLCAn5pWw5a2mJywgOTcpLA0KICAoNywg MiwgJ+aVsOWtpicsIDk5LjUpLA0KICAoMSwgMywgJ+iLseivrScsIDEwMCksDQogICgyLCAzLCAn 6Iux6K+tJywgOTUpLA0KICAoMywgMywgJ+iLseivrScsIDk1KSwNCiAgKDQsIDMsICfoi7Hor60n LCA5NSksDQogICg1LCAzLCAn6Iux6K+tJywgNTYpLA0KICAoNiwgMywgJ+iLseivrScsIDg3KSwN CiAgKDcsIDMsICfoi7Hor60nLCA5MyksDQogICgxLCA0LCAn54mp55CGJywgNjApLA0KICAoMiwg NCwgJ+eJqeeQhicsIDYwKSwNCiAgKDMsIDQsICfniannkIYnLCA2NSksDQogICg0LCA0LCAn54mp 55CGJywgNjUpLA0KICAoNSwgNCwgJ+eJqeeQhicsIDY1KSwNCiAgKDYsIDQsICfniannkIYnLCA3 MSksDQogICg3LCA0LCAn54mp55CGJywgNzEpDQo7DQoNCg0Kc2VsZWN0IA0KICAqLCANCiAgc3Vt KHNjb3JlKSBvdmVyIHcxLCANCiAgYXZnKHNjb3JlKSBvdmVyIHcxLCANCiAgZmlyc3RfdmFsdWUo c2NvcmUpIG92ZXIgdzEsIA0KICBsYXN0X3ZhbHVlKHNjb3JlKSBvdmVyIHcxIA0KZnJvbSB0IA0K ICB3aW5kb3cgdzEgYXMgKHBhcnRpdGlvbiBieSBzdWIgb3JkZXIgYnkgc2NvcmU6OmludCByYW5n ZSBiZXR3ZWVuIDEKcHJlY2VkaW5nIGFuZCA2IGZvbGxvd2luZykgDQpvcmRlciBieSBzdWIsIHNj b3JlOw0KDQoNCiBzaWQgfCBzdWIgfCBkZXMgIHwgc2NvcmUgfCBzdW0gfCAgICAgICAgIGF2ZyAg ICAgICAgIHwgZmlyc3RfdmFsdWUgfApsYXN0X3ZhbHVlIA0KLS0tLS0rLS0tLS0rLS0tLS0tKy0t LS0tLS0rLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0t LS0tDQogICA1IHwgICAxIHwg6K+t5paHIHwgICAgMzIgfCA1NjIgfCA4MC4yODU3MTQyODU3MTQy ODU3IHwgICAgICAgICAgMzIgfCAgICAgICAKMTAwDQogICAyIHwgICAxIHwg6K+t5paHIHwgICAg NzEgfCA1NjIgfCA4MC4yODU3MTQyODU3MTQyODU3IHwgICAgICAgICAgMzIgfCAgICAgICAKMTAw DQogICAxIHwgICAxIHwg6K+t5paHIHwgICAgODEgfCA1NjIgfCA4MC4yODU3MTQyODU3MTQyODU3 IHwgICAgICAgICAgMzIgfCAgICAgICAKMTAwDQogICA2IHwgICAxIHwg6K+t5paHIHwgICAgODkg fCA1NjIgfCA4MC4yODU3MTQyODU3MTQyODU3IHwgICAgICAgICAgMzIgfCAgICAgICAKMTAwDQog ICA3IHwgICAxIHwg6K+t5paHIHwgICAgOTAgfCA1NjIgfCA4MC4yODU3MTQyODU3MTQyODU3IHwg ICAgICAgICAgMzIgfCAgICAgICAKMTAwDQogICAzIHwgICAxIHwg6K+t5paHIHwgICAgOTkgfCA1 NjIgfCA4MC4yODU3MTQyODU3MTQyODU3IHwgICAgICAgICAgMzIgfCAgICAgICAKMTAwDQogICA0 IHwgICAxIHwg6K+t5paHIHwgICAxMDAgfCA1NjIgfCA4MC4yODU3MTQyODU3MTQyODU3IHwgICAg ICAgICAgMzIgfCAgICAgICAKMTAwDQogICA1IHwgICAyIHwg5pWw5a2mIHwgICAgMTIgfCA1NTQg fCA3OS4xNDI4NTcxNDI4NTcxNDI5IHwgICAgICAgICAgMTIgfCAgICAgICAKMTAwDQogICAzIHwg ICAyIHwg5pWw5a2mIHwgICAgNzggfCA1NTQgfCA3OS4xNDI4NTcxNDI4NTcxNDI5IHwgICAgICAg ICAgMTIgfCAgICAgICAKMTAwDQogICAxIHwgICAyIHwg5pWw5a2mIHwgICAgODEgfCA1NTQgfCA3 OS4xNDI4NTcxNDI4NTcxNDI5IHwgICAgICAgICAgMTIgfCAgICAgICAKMTAwDQogICA0IHwgICAy IHwg5pWw5a2mIHwgICAgOTAgfCA1NTQgfCA3OS4xNDI4NTcxNDI4NTcxNDI5IHwgICAgICAgICAg MTIgfCAgICAgICAKMTAwDQogICAyIHwgICAyIHwg5pWw5a2mIHwgICAgOTYgfCA1NTQgfCA3OS4x NDI4NTcxNDI4NTcxNDI5IHwgICAgICAgICAgMTIgfCAgICAgICAKMTAwDQogICA2IHwgICAyIHwg 5pWw5a2mIHwgICAgOTcgfCA1NTQgfCA3OS4xNDI4NTcxNDI4NTcxNDI5IHwgICAgICAgICAgMTIg fCAgICAgICAKMTAwDQogICA3IHwgICAyIHwg5pWw5a2mIHwgICAxMDAgfCA1NTQgfCA3OS4xNDI4 NTcxNDI4NTcxNDI5IHwgICAgICAgICAgMTIgfCAgICAgICAKMTAwDQogICA1IHwgICAzIHwg6Iux 6K+tIHwgICAgNTYgfCA2MjEgfCA4OC43MTQyODU3MTQyODU3MTQzIHwgICAgICAgICAgNTYgfCAg ICAgICAKMTAwDQogICA2IHwgICAzIHwg6Iux6K+tIHwgICAgODcgfCA2MjEgfCA4OC43MTQyODU3 MTQyODU3MTQzIHwgICAgICAgICAgNTYgfCAgICAgICAKMTAwDQogICA3IHwgICAzIHwg6Iux6K+t IHwgICAgOTMgfCA2MjEgfCA4OC43MTQyODU3MTQyODU3MTQzIHwgICAgICAgICAgNTYgfCAgICAg ICAKMTAwDQogICAzIHwgICAzIHwg6Iux6K+tIHwgICAgOTUgfCA2MjEgfCA4OC43MTQyODU3MTQy ODU3MTQzIHwgICAgICAgICAgNTYgfCAgICAgICAKMTAwDQogICA0IHwgICAzIHwg6Iux6K+tIHwg ICAgOTUgfCA2MjEgfCA4OC43MTQyODU3MTQyODU3MTQzIHwgICAgICAgICAgNTYgfCAgICAgICAK MTAwDQogICAyIHwgICAzIHwg6Iux6K+tIHwgICAgOTUgfCA2MjEgfCA4OC43MTQyODU3MTQyODU3 MTQzIHwgICAgICAgICAgNTYgfCAgICAgICAKMTAwDQogICAxIHwgICAzIHwg6Iux6K+tIHwgICAx MDAgfCA2MjEgfCA4OC43MTQyODU3MTQyODU3MTQzIHwgICAgICAgICAgNTYgfCAgICAgICAKMTAw DQogICAxIHwgICA0IHwg54mp55CGIHwgICAgNjAgfCA0NTcgfCA2NS4yODU3MTQyODU3MTQyODU3 IHwgICAgICAgICAgNjAgfCAgICAgICAgCjcxDQogICAyIHwgICA0IHwg54mp55CGIHwgICAgNjAg fCA0NTcgfCA2NS4yODU3MTQyODU3MTQyODU3IHwgICAgICAgICAgNjAgfCAgICAgICAgCjcxDQog ICAzIHwgICA0IHwg54mp55CGIHwgICAgNjUgfCA0NTcgfCA2NS4yODU3MTQyODU3MTQyODU3IHwg ICAgICAgICAgNjAgfCAgICAgICAgCjcxDQogICA0IHwgICA0IHwg54mp55CGIHwgICAgNjUgfCA0 NTcgfCA2NS4yODU3MTQyODU3MTQyODU3IHwgICAgICAgICAgNjAgfCAgICAgICAgCjcxDQogICA1 IHwgICA0IHwg54mp55CGIHwgICAgNjUgfCA0NTcgfCA2NS4yODU3MTQyODU3MTQyODU3IHwgICAg ICAgICAgNjAgfCAgICAgICAgCjcxDQogICA2IHwgICA0IHwg54mp55CGIHwgICAgNzEgfCA0NTcg fCA2NS4yODU3MTQyODU3MTQyODU3IHwgICAgICAgICAgNjAgfCAgICAgICAgCjcxDQogICA3IHwg ICA0IHwg54mp55CGIHwgICAgNzEgfCA0NTcgfCA2NS4yODU3MTQyODU3MTQyODU3IHwgICAgICAg ICAgNjAgfCAgICAgICAgCjcxDQooMjggcm93cykNCg0KDQpzZWxlY3QgDQogICosIA0KICBzdW0o c2NvcmUpIG92ZXIgdzEsIA0KICBhdmcoc2NvcmUpIG92ZXIgdzEsIA0KICBmaXJzdF92YWx1ZShz Y29yZSkgb3ZlciB3MSwgDQogIGxhc3RfdmFsdWUoc2NvcmUpIG92ZXIgdzEgDQpmcm9tIHQgDQog IHdpbmRvdyB3MSBhcyAob3JkZXIgYnkgc2NvcmU6OmludCByYW5nZSBiZXR3ZWVuIDEgcHJlY2Vk aW5nIGFuZCA2CmZvbGxvd2luZykgDQpvcmRlciBieSBzY29yZTsNCg0KIHNpZCB8IHN1YiB8IGRl cyAgfCBzY29yZSB8IHN1bSB8ICAgICAgICAgYXZnICAgICAgICAgfCBmaXJzdF92YWx1ZSB8Cmxh c3RfdmFsdWUgDQotLS0tLSstLS0tLSstLS0tLS0rLS0tLS0tLSstLS0tLSstLS0tLS0tLS0tLS0t LS0tLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0NCiAgIDUgfCAgIDIgfCDmlbDlraYg fCAgICAxMiB8ICAxMiB8IDEyLjAwMDAwMDAwMDAwMDAwMDAgfCAgICAgICAgICAxMiB8ICAgICAg ICAKMTINCiAgIDUgfCAgIDEgfCDor63mlocgfCAgICAzMiB8ICAzMiB8IDMyLjAwMDAwMDAwMDAw MDAwMDAgfCAgICAgICAgICAzMiB8ICAgICAgICAKMzINCiAgIDUgfCAgIDMgfCDoi7Hor60gfCAg ICA1NiB8IDE3NiB8IDU4LjY2NjY2NjY2NjY2NjY2NjcgfCAgICAgICAgICA1NiB8ICAgICAgICAK NjANCiAgIDEgfCAgIDQgfCDniannkIYgfCAgICA2MCB8IDMxNSB8IDYzLjAwMDAwMDAwMDAwMDAw MDAgfCAgICAgICAgICA2MCB8ICAgICAgICAKNjUNCiAgIDIgfCAgIDQgfCDniannkIYgfCAgICA2 MCB8IDMxNSB8IDYzLjAwMDAwMDAwMDAwMDAwMDAgfCAgICAgICAgICA2MCB8ICAgICAgICAKNjUN CiAgIDMgfCAgIDQgfCDniannkIYgfCAgICA2NSB8IDQwOCB8IDY4LjAwMDAwMDAwMDAwMDAwMDAg fCAgICAgICAgICA2NSB8ICAgICAgICAKNzENCiAgIDQgfCAgIDQgfCDniannkIYgfCAgICA2NSB8 IDQwOCB8IDY4LjAwMDAwMDAwMDAwMDAwMDAgfCAgICAgICAgICA2NSB8ICAgICAgICAKNzENCiAg IDUgfCAgIDQgfCDniannkIYgfCAgICA2NSB8IDQwOCB8IDY4LjAwMDAwMDAwMDAwMDAwMDAgfCAg ICAgICAgICA2NSB8ICAgICAgICAKNzENCiAgIDYgfCAgIDQgfCDniannkIYgfCAgICA3MSB8IDIx MyB8IDcxLjAwMDAwMDAwMDAwMDAwMDAgfCAgICAgICAgICA3MSB8ICAgICAgICAKNzENCiAgIDcg fCAgIDQgfCDniannkIYgfCAgICA3MSB8IDIxMyB8IDcxLjAwMDAwMDAwMDAwMDAwMDAgfCAgICAg ICAgICA3MSB8ICAgICAgICAKNzENCiAgIDIgfCAgIDEgfCDor63mlocgfCAgICA3MSB8IDIxMyB8 IDcxLjAwMDAwMDAwMDAwMDAwMDAgfCAgICAgICAgICA3MSB8ICAgICAgICAKNzENCiAgIDMgfCAg IDIgfCDmlbDlraYgfCAgICA3OCB8IDI0MCB8IDgwLjAwMDAwMDAwMDAwMDAwMDAgfCAgICAgICAg ICA3OCB8ICAgICAgICAKODENCiAgIDEgfCAgIDEgfCDor63mlocgfCAgICA4MSB8IDI0OSB8IDgz LjAwMDAwMDAwMDAwMDAwMDAgfCAgICAgICAgICA4MSB8ICAgICAgICAKODcNCiAgIDEgfCAgIDIg fCDmlbDlraYgfCAgICA4MSB8IDI0OSB8IDgzLjAwMDAwMDAwMDAwMDAwMDAgfCAgICAgICAgICA4 MSB8ICAgICAgICAKODcNCiAgIDYgfCAgIDMgfCDoi7Hor60gfCAgICA4NyB8IDQ0OSB8IDg5Ljgw MDAwMDAwMDAwMDAwMDAgfCAgICAgICAgICA4NyB8ICAgICAgICAKOTMNCiAgIDYgfCAgIDEgfCDo r63mlocgfCAgICA4OSB8IDY0NyB8IDkyLjQyODU3MTQyODU3MTQyODYgfCAgICAgICAgICA4OSB8 ICAgICAgICAKOTUNCiAgIDcgfCAgIDEgfCDor63mlocgfCAgICA5MCB8IDc0MyB8IDkyLjg3NTAw MDAwMDAwMDAwMDAgfCAgICAgICAgICA4OSB8ICAgICAgICAKOTYNCiAgIDQgfCAgIDIgfCDmlbDl raYgfCAgICA5MCB8IDc0MyB8IDkyLjg3NTAwMDAwMDAwMDAwMDAgfCAgICAgICAgICA4OSB8ICAg ICAgICAKOTYNCiAgIDcgfCAgIDMgfCDoi7Hor60gfCAgICA5MyB8IDY3MCB8IDk1LjcxNDI4NTcx NDI4NTcxNDMgfCAgICAgICAgICA5MyB8ICAgICAgICAKOTkNCiAgIDMgfCAgIDMgfCDoi7Hor60g fCAgICA5NSB8IDg3NyB8IDk3LjQ0NDQ0NDQ0NDQ0NDQ0NDQgfCAgICAgICAgICA5NSB8ICAgICAg IAoxMDANCiAgIDIgfCAgIDMgfCDoi7Hor60gfCAgICA5NSB8IDg3NyB8IDk3LjQ0NDQ0NDQ0NDQ0 NDQ0NDQgfCAgICAgICAgICA5NSB8ICAgICAgIAoxMDANCiAgIDQgfCAgIDMgfCDoi7Hor60gfCAg ICA5NSB8IDg3NyB8IDk3LjQ0NDQ0NDQ0NDQ0NDQ0NDQgfCAgICAgICAgICA5NSB8ICAgICAgIAox MDANCiAgIDIgfCAgIDIgfCDmlbDlraYgfCAgICA5NiB8IDg3NyB8IDk3LjQ0NDQ0NDQ0NDQ0NDQ0 NDQgfCAgICAgICAgICA5NSB8ICAgICAgIAoxMDANCiAgIDYgfCAgIDIgfCDmlbDlraYgfCAgICA5 NyB8IDU5MiB8IDk4LjY2NjY2NjY2NjY2NjY2NjcgfCAgICAgICAgICA5NiB8ICAgICAgIAoxMDAN CiAgIDMgfCAgIDEgfCDor63mlocgfCAgICA5OSB8IDM5OSB8IDk5Ljc1MDAwMDAwMDAwMDAwMDAg fCAgICAgICAgICA5OSB8ICAgICAgIAoxMDANCiAgIDcgfCAgIDIgfCDmlbDlraYgfCAgIDEwMCB8 IDM5OSB8IDk5Ljc1MDAwMDAwMDAwMDAwMDAgfCAgICAgICAgICA5OSB8ICAgICAgIAoxMDANCiAg IDQgfCAgIDEgfCDor63mlocgfCAgIDEwMCB8IDM5OSB8IDk5Ljc1MDAwMDAwMDAwMDAwMDAgfCAg ICAgICAgICA5OSB8ICAgICAgIAoxMDANCiAgIDEgfCAgIDMgfCDoi7Hor60gfCAgIDEwMCB8IDM5 OSB8IDk5Ljc1MDAwMDAwMDAwMDAwMDAgfCAgICAgICAgICA5OSB8ICAgICAgIAoxMDANCigyOCBy b3dzKQ0KYGBgDQoNCndoZW4gaSB1c2UgZnJhbWUgY2xhdXNlKHJhbmdlKSwgaXQncyBvbmx5IHJp Z2h0IHdoZW4gZG9uJ3QgdXNlIHBhcnRpdGlvbiBieSwKYW5kIHVzZSB0aGUgd2hvbGUgcm93cyBh cyBvbmUgcGFydGl0aW9uLg0KDQppcyBpdCBhIGJ1Zz8NCg0KZGlnb2FsLA0KYmVzdCByZWdhcmRz LgoK --===============7045552684216912903==--