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 1k8M1O-0008Th-96 for pgsql-bugs@arkaria.postgresql.org; Wed, 19 Aug 2020 11:12:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k8M1M-00035T-5Y for pgsql-bugs@arkaria.postgresql.org; Wed, 19 Aug 2020 11:12:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k8LO0-000873-T8 for pgsql-bugs@lists.postgresql.org; Wed, 19 Aug 2020 10:32:04 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k8LNy-00071v-HP for pgsql-bugs@lists.postgresql.org; Wed, 19 Aug 2020 10:32:04 +0000 Content-Type: multipart/mixed; boundary="===============7939637055585635363==" MIME-Version: 1.0 Subject: BUG #16585: Wrong filtering on a COALESCE field after using GROUPING SETS To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: pavelsivash@gmail.com Reply-To: pavelsivash@gmail.com, pgsql-bugs@lists.postgresql.org Date: Wed, 19 Aug 2020 10:31:49 +0000 Message-ID: <16585-9d8c340d23ade8c1@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7939637055585635363== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjU4NQpMb2dnZWQgYnk6ICAgICAgICAgIFBhdWwgU2l2YXNoCkVtYWls IGFkZHJlc3M6ICAgICAgcGF2ZWxzaXZhc2hAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTIuNApPcGVyYXRpbmcgc3lzdGVtOiAgIHg4Nl82NC1wYy1saW51eC1nbnUKRGVzY3JpcHRpb246 ICAgICAgICAKCkhlbGxvISBUaGVyZSBpcyBhIHByb2JsZW0gd2l0aCBmaWx0ZXJpbmcgQ09BTEVT Q0UgZmllbGQgd2hpY2ggaGFzIGNvbnN0YW50CmZyb20gbmVzdGVkIHN1YnNlbGVjdCB3aXRoIEdS T1VQSU5HIFNFVFMgYXMgZmlyc3QgZWxlbWVudC4gDQoNCkV4YW1wbGU6IA0KDQpXSVRIIHRhYmxl MSBBUyAoDQogICAgIFNFTEVDVCAyIEFTIGNpdHlfaWQsIDUgQVMgY250DQogICAgIFVOSU9OIEFM TA0KICAgICBTRUxFQ1QgMiBBUyBjaXR5X2lkLCAxIEFTIGNudA0KICAgICBVTklPTiBBTEwNCiAg ICAgU0VMRUNUIDMgQVMgY2l0eV9pZCwgMiBBUyBjbnQNCiAgICAgVU5JT04gQUxMDQogICAgIFNF TEVDVCAzIEFTIGNpdHlfaWQsIDcgQVMgY250DQoJKSwgDQogDQpmaW4gQVMgKA0KCVNFTEVDVCAN CgkgICAgY29hbGVzY2UoY291bnRyeV9pZCwgY2l0eV9pZCkgQVMgbG9jYXRpb25faWQsDQoJICAg IHRvdGFsDQoJRlJPTSAoDQoJCVNFTEVDVA0KCQkJMSBhcyBjb3VudHJ5X2lkLA0KCQkJY2l0eV9p ZCwNCgkJCXN1bShjbnQpIGFzIHRvdGFsDQoJCUZST00gdGFibGUxIA0KCQlHUk9VUCBCWSBHUk9V UElORyBTRVRTICgxLDIpDQoJCSkgYmFzZQ0KCSkNCgkNClNFTEVDVCAqIA0KRlJPTSBmaW4gDQpX SEVSRSBsb2NhdGlvbl9pZCA9IDE7DQoNCkFzIHlvdSBjYW4gc2VlIGluIHRoZSBlbmQgSSB3YW50 IHRvIGtlZXAgb25seSByb3dzIHdpdGggbG9jYXRpb25faWQgPSAxIGJ1dAp0aGUgcmVzdWx0IGdp dmVzIG1lIGFsbCBhdmFpbGFibGUgcm93cy4gVGhpcyBoYXBwZW5zIGJlY2F1c2UgUG9zdGdyZXMg c2Vlcwp0aGF0IEkgZmlsdGVyIENPQUxFU0NFIGZpZWxkIHdoaWNoIGhhcyAiY291bnRyeV9pZCIg YXMgZmlyc3QgZWxlbWVudCBhbmQKImNvdW50cnlfaWQiIGlzIHByZXZpb3VzbHkgc2V0IGFzIGNv bnN0YW50IC0gMS4gQnV0IHRoZSB0aGluZyBpcyB0aGF0IHVzaW5nCkdST1VQSU5HIFNFVFMgdHVy bnMgImNvdW50cnlfaWQiIHRvIE5VTEwgaW4gc29tZSByb3dzIGFuZCB0aGlzIGJlaGF2aW91ciBp cwp3cm9uZy4gDQoNCldoZW4gSSBjaGFuZ2UgZmluYWwgZmlsdGVyIHRvICJsb2NhdGlvbl9pZCA9 IDIiIGl0IHJldHVybnMgMCByb3dzIGZvciB0aGUKc2FtZSByZWFzb24uIA0KDQpUaGFuayB5b3Ug aW4gYWR2YW5jZSEKCg== --===============7939637055585635363==--