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 1jS5gv-0000Q1-9e for pgsql-bugs@arkaria.postgresql.org; Fri, 24 Apr 2020 21:16:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jS5gs-0000z9-Ev for pgsql-bugs@arkaria.postgresql.org; Fri, 24 Apr 2020 21:16:54 +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 1jS4bP-0005zj-8r for pgsql-bugs@lists.postgresql.org; Fri, 24 Apr 2020 20:07:11 +0000 Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jS4bI-0004LX-FF for pgsql-bugs@lists.postgresql.org; Fri, 24 Apr 2020 20:07:10 +0000 Content-Type: multipart/mixed; boundary="===============8063858451259547234==" MIME-Version: 1.0 Subject: BUG #16388: Different results when bitmap scan enabled/disabled To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: charlie@torqinterface.com Reply-To: charlie@torqinterface.com, pgsql-bugs@lists.postgresql.org Date: Fri, 24 Apr 2020 20:06:41 +0000 Message-ID: <16388-98cffba38d0b7e6e@postgresql.org> X-Auto-Response-Suppress: All List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============8063858451259547234== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjM4OApMb2dnZWQgYnk6ICAgICAgICAgIENoYXJsZXMgT2ZmZW5iYWNo ZXIKRW1haWwgYWRkcmVzczogICAgICBjaGFybGllQHRvcnFpbnRlcmZhY2UuY29tClBvc3RncmVT UUwgdmVyc2lvbjogMTEuNwpPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dQpEZXNjcmlwdGlvbjog ICAgICAgIAoKSGkgcGdzcWwtYnVncywNCg0KV2hlbiBQb3N0Z3JlcyB1c2VzIGEgYml0bWFwIGhl YXAgc2NhbiB0byBldmFsdWF0ZSBhIHRzcXVlcnkgdGhhdCBpbmNsdWRlcyAhLAppdCBpcyBnaXZp bmcgbWUgZGlmZmVyZW50IChhbmQgaW5jb3JyZWN0KSByZXN1bHRzIGNvbXBhcmVkIHRvIHdoZW4g aXQKcGVyZm9ybXMgYSBzZXFzY2FuLg0KDQpDYW4gYW55Ym9keSBzaGVkIHNvbWUgbGlnaHQgb24g dGhpcz8gU2ltcGx5IGVuYWJsaW5nIC8gZGlzYWJsaW5nIGJpdG1hcHNjYW4KY2hhbmdlcyB0aGUg cXVlcnkgcmVzdWx0cywgd2hpY2ggZmVlbHMgbGlrZSBhIGJ1ZyB0byBtZS4gQXJlIHRoZXJlIGFu eQp3b3JrYXJvdW5kcz8gSSBmb3VuZCBvbmUgZm9yIG15IHJlcHJvIGJlbG93ICh1c2luZyBOT1Qp IGJ1dCBmb3Igc29tZSBvZiB0aGUKY29tcGxpY2F0ZWQgdHNxdWVyeSBxdWVyaWVzIHRoYXQgSSBo YXZlIGluIHByb2R1Y3Rpb24sIEknbSBub3Qgc3VyZSBJIGNhbgptYWtlIHRoYXQgd29yay4NCg0K Q1JFQVRFIFRBQkxFIGV4YW1wbGVzIChjb250ZW50IHRleHQpOw0KQ1JFQVRFIElOREVYIHRzX2lk eCBPTiBleGFtcGxlcyBVU0lORyBnaW4odG9fdHN2ZWN0b3IoJ3NpbXBsZScsIGNvbnRlbnQpKTsN CklOU0VSVCBJTlRPIGV4YW1wbGVzIFZBTFVFUyAoJ0V4YW1wbGUgd2l0aCBhIHdvcmQnKTsNCg0K LyogSW5jb3JyZWN0bHkgcmV0dXJucyBubyByZXN1bHRzICovDQpTRVQgZW5hYmxlX3NlcXNjYW4g PSBPRkY7DQpTRVQgZW5hYmxlX2luZGV4c2NhbiA9IE9GRjsNClNFVCBlbmFibGVfYml0bWFwc2Nh biA9IE9OOw0KU0VMRUNUICogRlJPTSBleGFtcGxlcyANCldIRVJFIHRvX3RzdmVjdG9yKCdzaW1w bGUnLCBjb250ZW50KSBAQCB0b190c3F1ZXJ5KCdzaW1wbGUnLAonIShleGFtcGxlPC0+d29yZCkn KQ0KDQovKiBDb3JyZWN0bHkgcmV0dXJucyByZXN1bHRzICovIA0KU0VUIGVuYWJsZV9zZXFzY2Fu ID0gT0ZGOw0KU0VUIGVuYWJsZV9pbmRleHNjYW4gPSBPRkY7DQpTRVQgZW5hYmxlX2JpdG1hcHNj YW4gPSBPRkY7IC8qIGRpc2FibGVkICovDQpTRUxFQ1QgKiBGUk9NIGV4YW1wbGVzIA0KV0hFUkUg dG9fdHN2ZWN0b3IoJ3NpbXBsZScsIGNvbnRlbnQpIEBAIHRvX3RzcXVlcnkoJ3NpbXBsZScsCich KGV4YW1wbGU8LT53b3JkKScpDQoNCi8qIEFsc28gY29ycmVjdGx5IHJldHVybnMgcmVzdWx0cyBi eSB1c2luZyBpbmRleCBhbmQgTk9UIGtleXdvcmQgKi8gDQpTRVQgZW5hYmxlX3NlcXNjYW4gPSBP RkY7DQpTRVQgZW5hYmxlX2luZGV4c2NhbiA9IE9GRjsNClNFVCBlbmFibGVfYml0bWFwc2NhbiA9 IE9OOyAvKiBlbmFibGVkICovDQpTRUxFQ1QgKiBGUk9NIGV4YW1wbGVzIA0KV0hFUkUgTk9UIHRv X3RzdmVjdG9yKCdzaW1wbGUnLCBjb250ZW50KSBAQCB0b190c3F1ZXJ5KCdzaW1wbGUnLAonKGV4 YW1wbGU8LT53b3JkKScpDQoNClRoYW5rcyBmb3IgeW91ciB0aW1lLCBhbmQgYW55IHRob3VnaHRz IHRoYXQgeW91IG1pZ2h0IGhhdmUgdG8gc3BhcmUuDQotQ2hhcmxpZQoK --===============8063858451259547234==--