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 1urBkZ-0020CL-Qu for pgsql-bugs@arkaria.postgresql.org; Wed, 27 Aug 2025 08:43:25 +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 1urBkZ-00DbZr-Ah for pgsql-bugs@arkaria.postgresql.org; Wed, 27 Aug 2025 08:43:23 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1urAAb-00D4JA-4T for pgsql-bugs@lists.postgresql.org; Wed, 27 Aug 2025 07:02:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1urAAZ-001yWm-0D for pgsql-bugs@lists.postgresql.org; Wed, 27 Aug 2025 07:02:08 +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=KjkgmwqzljvvTNFtUkBzttuE4DtUOEPIDT97P7CF1KY=; b=DrmcADN4QwQLGYVyIDCVryKinB VI4yVeFvi6Dbxov7DTZ2yw262LE965iggXqnkO63zVmn2RrbHtYsycqrE1NAzLsivP2OClFIB8QY8 qyGZ9zHYHtRLkdo9xLPx8MYO+uVUJGcTHTg6HVrW9KsCqWNIzm3HTgcq0ppQh53HhOYFBnZuSj5be +yeNAEALPsUnP+iUiMPpreLmKqmPJRbINrRYQNY6YZTTeuUPf5mqj7GXic5UTkkh6cMAU3cw5EnTe DYC4PSlq8EKYgLIzVdyG5UlrN4Rx8RhQMRrbgRzzPZC83zyT4u2O0p0roerRUfQEXUylS74VANneX ZnsrDDTA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1urAAX-005RcK-2S for pgsql-bugs@lists.postgresql.org; Wed, 27 Aug 2025 07:02:07 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1urAAV-00BXZ9-15 for pgsql-bugs@lists.postgresql.org; Wed, 27 Aug 2025 07:02:03 +0000 Content-Type: multipart/mixed; boundary="===============2509056927937773756==" MIME-Version: 1.0 Subject: BUG #19033: Inconsistency between prepared statement and normal statement when cast bit to integer To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: 798604270@qq.com Reply-To: 798604270@qq.com, pgsql-bugs@lists.postgresql.org Date: Wed, 27 Aug 2025 07:01:27 +0000 Message-ID: <19033-9eec36049d7363e8@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 --===============2509056927937773756== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTAzMwpMb2dnZWQgYnk6ICAgICAgICAgIENoaSBaaGFuZwpFbWFpbCBh ZGRyZXNzOiAgICAgIDc5ODYwNDI3MEBxcS5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxOGJldGEz Ck9wZXJhdGluZyBzeXN0ZW06ICAgdWJ1bnR1IDI0LjA0IHdpdGggZG9ja2VyCkRlc2NyaXB0aW9u OiAgICAgICAgCgpIaSwKCkluIHRoZSBub3JtYWwgc3RhdGVtZW50LCBjYXN0aW5nIGEgYml0IHZh bHVlIHRvIElOVCBpcyBhbGxvd2VkLCBidXQgaW4gYQpwcmVwYXJlZCBzdGF0ZW1lbnQsIGl0IHdp bGwgdHJpZ2dlciBhbiBlcnJvci4KCkluIHRoZSBmb2xsb3dpbmcgdGVzdCBjYXNlLCB0aGUgZmly c3QgcXVlcnkgd2lsbCByZXR1cm4gMTUsIGJ1dCB0aGUgRVhFQ1VURQpzdGF0ZW1lbnQgd2lsbCB0 cmlnZ2VyIGFuIGVycm9yOiBwYXJhbWV0ZXIgJDEgb2YgdHlwZSBiaXQgY2Fubm90IGJlIGNvZXJj ZWQKdG8gdGhlIGV4cGVjdGVkIHR5cGUgaW50ZWdlcgoKYGBgClNFTEVDVCAoQicxMTExJyk6OklO VDsKIGludDQKLS0tLS0tCiAgIDE1CigxIHJvdykKClBSRVBBUkUgcHJlcGFyZV9xdWVyeSAodW5r bm93bikgQVMgU0VMRUNUICQxOjpJTlQ7CkVYRUNVVEUgcHJlcGFyZV9xdWVyeShCJzExMTEnKTsK RVJST1I6ICBwYXJhbWV0ZXIgJDEgb2YgdHlwZSBiaXQgY2Fubm90IGJlIGNvZXJjZWQgdG8gdGhl IGV4cGVjdGVkIHR5cGUKaW50ZWdlcgpgYGAKCklmIEkgbW9kaWZ5IHRoZSB1bmtub3duIHR5cGUg dG8gYml0LCB0aGVuIHRoZSBxdWVyeSBjYW4gZXhlY3V0ZSBzdWNjZXNzZnVsbHkKYW5kIHJldHVy biAxNS4KYGBgClBSRVBBUkUgcHJlcGFyZV9xdWVyeSAoYml0KSBBUyBTRUxFQ1QgJDE6OklOVDsK RVhFQ1VURSBwcmVwYXJlX3F1ZXJ5KEInMTExMScpOwogaW50NAotLS0tLS0KICAgMTUKKDEgcm93 KQpgYGAKCkkgYWxzbyBmaW5kIGlmIEkgZmlyc3QgY2FzdCBCJzExMTEnIHRvIGJpdCBhbmQgdGhl biBjYXN0IGl0IHRvIGludGVnZXIsIGl0CndpbGwgYmVjb21lIDEuIEJ1dCB0aGUgY29ycmVjdCBy ZXN1bHQgc2hvdWxkIGJlIDE1LgoKYGBgClNFTEVDVCAoKEInMTExMScpOjpiaXQpOjpJTlQ7CiBp bnQ0Ci0tLS0tLQogICAgMQooMSByb3cpCmBgYAoK --===============2509056927937773756==--