Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qpWKE-0063Ew-K6 for pgsql-bugs@arkaria.postgresql.org; Sun, 08 Oct 2023 16:08:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qpWKC-007ZQY-Ac for pgsql-bugs@arkaria.postgresql.org; Sun, 08 Oct 2023 16:08:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qpW5g-007Un9-FJ for pgsql-bugs@lists.postgresql.org; Sun, 08 Oct 2023 15:53:13 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qpW5c-000wWa-Cu for pgsql-bugs@lists.postgresql.org; Sun, 08 Oct 2023 15:53:12 +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=H5+A4uoorVYP5IpeReCDCk0c3lomTXvUnrB6jVZrqCQ=; b=r2fY25cbZEJ8XcQDy3n5Y2oAvH rM6c5DQc/EfZLIVTnY1Hwsk1zBR9gPe7tE0kthLyMHcKIMd0OKC4gRT1eZbPKk35mr+Do1i/17zaF 9FbuTYSTLTzb67bFfeaC3XAxbqhwuNfdTEOe6oG7325Mxe99dioh+bkZyx+21niBR4IW0KQPRXs/e SP+XP7KZ4zUNyyI/UBwe/2yqyKeF78/JTARldQekItgvO4iZh6CuiuesFOdU25JLyl5bkaFRH4PPn pOmrTaR69LLanpJLvy3UdmlI96NItLZnF3mzzRWhBZWGAZKE4YQLaM1nsTnPjSYrnd4SXE3tMuPq+ aLAFnAhA==; 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 1qpW5Z-0002oy-LY for pgsql-bugs@lists.postgresql.org; Sun, 08 Oct 2023 15:53:07 +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 1qpW5V-002Sal-VU for pgsql-bugs@lists.postgresql.org; Sun, 08 Oct 2023 15:53:02 +0000 Content-Type: multipart/mixed; boundary="===============3736051552115564164==" MIME-Version: 1.0 Subject: BUG #18150: The results returned by index only scan using gist index of bpchar and seqscan have difference. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: ocean_li_996@163.com Reply-To: ocean_li_996@163.com, pgsql-bugs@lists.postgresql.org Date: Sun, 08 Oct 2023 15:52:05 +0000 Message-ID: <18150-b3922f47e62d4d12@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 --===============3736051552115564164== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODE1MApMb2dnZWQgYnk6ICAgICAgICAgIG9jZWFuIGxpCkVtYWlsIGFk ZHJlc3M6ICAgICAgb2NlYW5fbGlfOTk2QDE2My5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMS45 Ck9wZXJhdGluZyBzeXN0ZW06ICAgY2VudG9zNyA1LjEwLjg0IHg4Nl82NApEZXNjcmlwdGlvbjog ICAgICAgIAoKV2hlbiB0ZXN0aW5nIGNvbnNpc3RlbmN5IGJldHdlZW4gaW5kZXggKG9ubHkpIHNj YW4gYW5kIHNlcXNjYW4sIEkgZm91bmQgdGhhdAp0aGUgcmVzdWx0cyByZXR1cm5lZCBieSBpbmRl eCBvbmx5IHNjYW4gdXNpbmcgZ2lzdCBpbmRleCBvZiBicGNoYXIgYW5kCnNlcXNjYW4gaGF2ZSBk aWZmZXJlbmNlLg0KQSBjYXNlIGdpdmVuIGJlbG93IGNhbiByZXByb2R1Y2UgdGhlIHNjZW5lOg0K DQotLSBwcmVwYXJhdGlvbiANCiogY3JlYXRlIGV4dGVuc2lvbiBidHJlZV9naXN0Ow0KKiBjcmVh dGUgdGFibGUgdDEoZl9jaGFyIGNoYXIoMzIpKTsNCiogY3JlYXRlIGluZGV4IG9uIHQxIHVzaW5n IGdpc3QgKGZfY2hhcik7DQoqIGluc2VydCBpbnRvIHQxIHNlbGVjdCBpIGZyb20gZ2VuZXJhdGVf c2VyaWVzKDEsMTAwMDApaTsNCg0KLS0gdGVzdA0KKiBzZXQgZW5hYmxlX2JpdG1hcHNjYW4gdG8g b2ZmOw0KKiBleHBsYWluIGFuYWx5emUgc2VsZWN0ICogZnJvbSB0MSB3aGVyZSBmX2NoYXIgPSAn MSc7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIFFVRVJZIFBMQU4NCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIEluZGV4IE9ubHkgU2NhbiB1c2luZyB0MV9mX2No YXJfaWR4IG9uIHQxICAoY29zdD0wLjE1Li44MC41MSByb3dzPTIxCndpZHRoPTEzMikgKGFjdHVh bCB0aW1lPTAuNDI0Li4wLjQyNiByb3dzPTEgbG9vcHM9MSkNCiAgIEluZGV4IENvbmQ6IChmX2No YXIgPSAnMSc6OmJwY2hhcikNCiAgIEhlYXAgRmV0Y2hlczogMQ0KIFBsYW5uaW5nIFRpbWU6IDAu MTAyIG1zDQogRXhlY3V0aW9uIFRpbWU6IDAuNDc3IG1zDQooNSByb3dzKQ0KDQoqIHNlbGVjdCAq IGZyb20gdDEgd2hlcmUgZl9jaGFyID0gJzEnOw0KIGZfY2hhcg0KLS0tLS0tLS0NCiAxDQooMSBy b3cpDQoNCiogc2V0IGVuYWJsZV9pbmRleHNjYW4gdG8gb2ZmOw0KKiBzZXQgZW5hYmxlX2luZGV4 b25seXNjYW4gdG8gb2ZmOw0KKiBleHBsYWluIGFuYWx5emUgc2VsZWN0ICogZnJvbSB0MSB3aGVy ZSBmX2NoYXIgPSAnMSc7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICBRVUVSWSBQTEFODQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIFNl cSBTY2FuIG9uIHQxICAoY29zdD0wLjAwLi4yMDkuMDAgcm93cz0xIHdpZHRoPTMzKSAoYWN0dWFs CnRpbWU9MC4wMTYuLjIuMzM2IHJvd3M9MSBsb29wcz0xKQ0KICAgRmlsdGVyOiAoZl9jaGFyID0g JzEnOjpicGNoYXIpDQogICBSb3dzIFJlbW92ZWQgYnkgRmlsdGVyOiA5OTk5DQogUGxhbm5pbmcg VGltZTogMC4wNzYgbXMNCiBFeGVjdXRpb24gVGltZTogMi4zNjcgbXMNCig1IHJvd3MpDQoNCiog c2VsZWN0ICogZnJvbSB0MSB3aGVyZSBmX2NoYXIgPSAnMSc7DQogICAgICAgICAgICAgIGZfY2hh cg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIDENCigxIHJvdykNCg0KT2J2 aW91c2x5LCB0aGUgbGFzdCBwYWRkaW5ncyBvZiBpbmRleCBvbmx5IHNjYW4gcmV0dXJuIGFyZSBj dXQuIEJ1dCB0aGUgbGFzdApwYWRkaW5ncyBvZiBzZXFzY2FuIHJldHVybiBhcmUgbm90IGN1dC4g QWN0dWFsbHksIHRoZSBkaWZmZXJlbmNlIGV4aXN0cyBpbgpnaXN0IGluZGV4IGxlYWYga2V5IGFu ZCB0YWJsZSBtZXRhZGF0YS4gQW5kIEkgdGhpbmsgaXQgaXMgY2F1c2VkIGJ5IHRoZQpiZWhhdmlv ciBvZiAqZ2J0X2JwY2hhcl9jb21wcmVzcyogZnVuY3Rpb24uIFJlbGF0ZWQgIGNvZGUgYXJlOg0K KiAuLi4NCiogaWYgKGVudHJ5LT5sZWFma2V5KQ0KKgl7DQoqDQoqCQlEYXR1bQkJZCA9IERpcmVj dEZ1bmN0aW9uQ2FsbDEocnRyaW0xLCBlbnRyeS0+a2V5KTsNCiogLi4uDQoNCkkgZG9uJ3Qga25v dyB3aGV0aGVyIHRoZSBzY2VuZSBpcyBhIGJ1ZyBvciBhbiBleHBlY3RlZCBiZWhhdmlvci4gSW4g bXkKb3BpbmlvbiwgaXQgbWF5IGJlIGEgYnVnLiBTbyBpdCByZXBvcnRlZCBoZXJlLiANCg0KQmVz dCByZWdhcmRzIQoK --===============3736051552115564164==--