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 1jJtJ0-0001E5-NF for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Apr 2020 06:26:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jJtIz-0007kn-Jz for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Apr 2020 06:26:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jJtIy-0007kf-TG for pgsql-hackers@lists.postgresql.org; Thu, 02 Apr 2020 06:26:21 +0000 Received: from sender4-op-o13.zoho.com ([136.143.188.13]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1jJtIt-0004gb-Iz for pgsql-hackers@lists.postgresql.org; Thu, 02 Apr 2020 06:26:19 +0000 ARC-Seal: i=1; a=rsa-sha256; t=1585808770; cv=none; d=zohomail.com; s=zohoarc; b=dt4WGYehPb3dcqyf1eO78CMYr/pi7vEf7NkS0J2kykcPKmCUEsG4+oCxsLLAV2LQ7f2+QzyApT/PERWyzWdcH8FO5wJKob5fpvvBhuIhV0ZZC4FKbW8/t2H2mHK8zUezvuWBZrMDgTAbmGxDvN8Zl+56M+4rVMaM1ORav/xdk9Y= ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=zohomail.com; s=zohoarc; t=1585808770; h=Content-Type:Cc:Date:From:MIME-Version:Message-ID:References:Subject:To; bh=TNthZBd7BfhhZ5shkpnGYPtANuGXvL6BtXXfLw55XW0=; b=e6TcAo/gWBaAc7Pb7E8URFV9wLq+pPLiNYFDTUMdteMjcAP7x6D1phaBtysYNQ4fSa5YUmldUi8FNVfIed4sJPmCrG/cMSInL13/mqHj+Z58mfwnOcDofIlO024Az4SZFNnKhBosbyjEUaFTHP5WDyOW4obRXOK9NfmiTLlu0aM= ARC-Authentication-Results: i=1; mx.zohomail.com; dkim=pass header.i=highgo.ca; spf=pass smtp.mailfrom=movead.li@highgo.ca; dmarc=pass header.from= header.from= DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; t=1585808770; s=zoho; d=highgo.ca; i=movead.li@highgo.ca; h=Date:From:To:Cc:Subject:References:Mime-Version:Message-ID:Content-Type; bh=TNthZBd7BfhhZ5shkpnGYPtANuGXvL6BtXXfLw55XW0=; b=cQrpWMi/CSf15vIC5jgQsy3okKcYl+bvinaTTnWE4IfC0lhMZZnlEN4dYEoYiDdc g2EN/W+Fg+Q0Vzp1vXuS5no/o79wONioTPRqizs5cnaIUOLdwKzV/pTO0OxgTaUdRrl WIlhYh1WXntyBa10b6Esn+lBUYxBe1JbFNRGz5O0= Received: from lchch (124.133.18.218 [124.133.18.218]) by mx.zohomail.com with SMTPS id 1585808767285708.4381110065603; Wed, 1 Apr 2020 23:26:07 -0700 (PDT) Date: Thu, 2 Apr 2020 14:26:08 +0800 From: "movead.li@highgo.ca" To: "Tom Lane" Cc: ashutosh.bapat , pgsql-hackers Subject: Re: A bug when use get_bit() function for a long bytea string References: <20200312115135445367128@highgo.ca>, , <20200313111842791351178@highgo.ca>, , <2020031810480643107833@highgo.ca>, , <2020032817093521193529@highgo.ca>, , <2020040111593809632067@highgo.ca>, <20077.1585757544@sss.pgh.pa.us> X-Priority: 3 X-GUID: 99029BE4-2F13-447D-A464-3CFEAB25C9C6 X-Has-Attach: yes X-Mailer: Foxmail 7.2.14.410[cn] Mime-Version: 1.0 Message-ID: <2020040214260375403022@highgo.ca> Content-Type: multipart/mixed; boundary="----=_001_NextPart182206618585_=----" X-Zoho-Virus-Status: 2 X-ZohoMailClient: External List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. ------=_001_NextPart182206618585_=---- Content-Type: multipart/alternative; boundary="----=_002_NextPart102046884876_=----" ------=_002_NextPart102046884876_=---- Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: base64 DQo+SSBkb24ndCB0aGluayB0aGlzIGhhcyByZWFsbHkgc29sdmVkIHRoZSBvdmVyZmxvdyBoYXph cmRzLiAgRm9yIGV4YW1wbGUsDQo+aW4gYmluYXJ5X2VuY29kZSB3ZSd2ZSBnb3QNCiANCj5yZXN1 bHRsZW4gPSBlbmMtPmVuY29kZV9sZW4oVkFSREFUQV9BTlkoZGF0YSksIGRhdGFsZW4pOw0KPnJl c3VsdCA9IHBhbGxvYyhWQVJIRFJTWiArIHJlc3VsdGxlbik7DQogDQo+YW5kIGFsbCB5b3UndmUg ZG9uZSBhYm91dCB0aGF0IGlzIGNoYW5nZWQgcmVzdWx0bGVuIGZyb20gaW50IHRvIGludDY0Lg0K Pk9uIGEgNjQtYml0IG1hY2hpbmUsIHN1cmUsIHBhbGxvYyB3aWxsIGJlIGFibGUgdG8gZGV0ZWN0 IGlmIHRoZQ0KPnJlc3VsdCBleGNlZWRzIHdoYXQgY2FuIGJlIGFsbG9jYXRlZCAtLS0gYnV0IG9u IGEgMzItYml0IG1hY2hpbmUNCj5pdCdkIGJlIHBvc3NpYmxlIGZvciB0aGUgc2l6ZV90IGFyZ3Vt ZW50IHRvIG92ZXJmbG93IGFsdG9nZXRoZXIuDQo+KE9yIGlmIHlvdSB3YW50IHRvIGFyZ3VlIHRo YXQgaXQgY2FuJ3Qgb3ZlcmZsb3cgYmVjYXVzZSBubyBlbmNvZGVyDQo+ZXhwYW5kcyB0aGUgZGF0 YSBtb3JlIHRoYW4gNFgsIHRoZW4gd2UgZG9uJ3QgbmVlZCB0byBiZSBtYWtpbmcgdGhpcw0KPmNo YW5nZSBhdCBhbGwuKQ0KIA0KPkkgZG9uJ3QgdGhpbmsgdGhlcmUncyByZWFsbHkgYW55IHdheSB0 byBkbyB0aGF0IHNhZmVseSB3aXRob3V0IGFuDQo+ZXhwbGljaXQgY2hlY2sgYmVmb3JlIHdlIGNh bGwgcGFsbG9jLg0KSSBhbSBzb3JyeSBJIGRvIG5vdCB2ZXJ5IHVuZGVyc3RhbmQgdGhlc2Ugd29y ZHMsIGFuZCBlc3BlY2lhbGx5DQp3aGF0J3MgdGhlIG1lYW4gYnkgJ3NpemVfdCcuIA0KSGVyZSBJ IGNoYW5nZSByZXN1bHRsZW4gZnJvbSBpbnQgdG8gaW50NjQsIGlzIGJlY2F1c2Ugd2UgY2FuIGdl dCBhIHJpZ2h0DQplcnJvciByZXBvcnQgdmFsdWUgb3RoZXIgdGhhbiAnLTEnIG9yIGFub3RoZXIg c3RyYW5nZSBudW1iZXIuDQoNCg0KIA0KPldoeSBkaWQgeW91IGNoYW5nZSB0aGUgb3V0cHV0cyBm cm9tIHVuc2lnbmVkIHRvIHNpZ25lZD8gIFdoeSBkaWRuJ3QNCj55b3UgY2hhbmdlIHRoZSBkbGVu IGlucHV0cz8gIEkgZ3JhbnQgdGhhdCB3ZSBrbm93IHRoYXQgdGhlIGlucHV0DQo+Y2FuJ3QgZXhj ZWVkIDFHQiBpbiBQb3N0Z3JlcycgdXNhZ2UsIGJ1dCB0aGVzZSBzaWduYXR1cmVzIGFyZSBqdXN0 DQo+cmFuZG9tbHkgaW5jb25zaXN0ZW50LCBhbmQgeW91IGRpZG4ndCBldmVuIGFkZCBhIGNvbW1l bnQgZXhwbGFpbmluZw0KPndoeS4gIFBlcnNvbmFsbHkgSSB0aGluayBJJ2QgbWFrZSB0aGVtIGxp a2UNCj51aW50NjQgKCplbmNvZGVfbGVuKSAoY29uc3QgY2hhciAqZGF0YSwgc2l6ZV90IGRsZW4p Ow0KPndoaWNoIG1ha2VzIGl0IGV4cGxpY2l0IHRoYXQgdGhlIGRsZW4gYXJndW1lbnQgZGVzY3Jp YmVzIHRoZSBsZW5ndGgNCj5vZiBhIGNodW5rIG9mIGFsbG9jYXRlZCBtZW1vcnksIHdoaWxlIHRo ZSByZXN1bHQgbWlnaHQgZXhjZWVkIHRoYXQuDQpJIHRoaW5rIGl0IG1ha2VzIHNlbmNlIGFuZCBm b2xsb3dlZC4NCiANCj5MYXN0bHksIHRoZXJlIGlzIGEgY29tcG9uZW50IG9mIHRoaXMgdGhhdCBj YW4gYmUgYmFjay1wYXRjaGVkIGFuZA0KPmEgY29tcG9uZW50IHRoYXQgY2FuJ3QgLS0tIHdlIGRv IG5vdCBjaGFuZ2Ugc3lzdGVtIGNhdGFsb2cgY29udGVudHMNCj5pbiByZWxlYXNlZCBicmFuY2hl cy4gIENyYW1taW5nIGJvdGggcGFydHMgaW50byB0aGUgc2FtZSBwYXRjaA0KPmlzIGZvcmNpbmcg dGhlIGNvbW1pdHRlciB0byBwdWxsIHRoZW0gYXBhcnQsIHdoaWNoIGlzIGtpbmQgb2YNCj51bmZy aWVuZGx5Lg0KU29ycnkgYWJvdXQgdGhhdCwgYXR0YWNoZWQgaXMgdGhlIGNoYW5nZWQgcGF0Y2gg Zm9yIFBHMTMsIGFuZCB0aGUgb25lDQpmb3Igb2xkZXIgYnJhbmNoZXMgd2lsbCBzZW5kIHNvb25l ci4NCg0KDQoNClJlZ2FyZHMsDQpIaWdoZ28gU29mdHdhcmUgKENhbmFkYS9DaGluYS9QYWtpc3Rh bikgDQpVUkwgOiB3d3cuaGlnaGdvLmNhIA0KRU1BSUw6IG1haWx0bzptb3ZlYWQoZG90KWxpKGF0 KWhpZ2hnbyhkb3QpY2ENCg== ------=_002_NextPart102046884876_=---- Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable