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 1lz1an-00020q-02 for pgsql-bugs@arkaria.postgresql.org; Thu, 01 Jul 2021 18:39:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lz1aj-0000KE-SQ for pgsql-bugs@arkaria.postgresql.org; Thu, 01 Jul 2021 18:39:13 +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 1lz0fZ-00013v-Ju for pgsql-bugs@lists.postgresql.org; Thu, 01 Jul 2021 17:40:09 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lz0fW-0005Vi-5g for pgsql-bugs@lists.postgresql.org; Thu, 01 Jul 2021 17:40: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=A69IkTB7mIFQzvn1CJfCso7XRb1hQnpb0RLK33aEnMY=; b=uehtB1cBZHPI1d08ksJbeYeEF7 q9LFutJOf9aP6Ine6Lx3p4Y5PIR1Ik2x6QTFmJD5FOFTnksl6OBZ065T9ePjAOPJvklaNenirbxQs sJE3aP1sifUOUDdDu0AoPVd/LJRQDl3Ch2BfMDx6qbqUudCdJRFyJ1V4Qovrmn8qB1ebRFOdMfS7a HqbuL0vMeSiUx4ugaaM2b4GHZhEWMb//u1ovOqfPeWCvqUEg1XK9/TUbwgX//GvkMhRtWkgJQsS74 zOnKUwcbsO1FU5nvepF5Xqn+nJ5qZxg6IgmA5Z5LD1TBtopv+CjvY9iVUXeG9LDiKV+wLeTwHoKnZ O1TiwvLQ==; 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 1lz0fV-0006mz-Dr for pgsql-bugs@lists.postgresql.org; Thu, 01 Jul 2021 17:40:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lz0fS-0006v2-GO for pgsql-bugs@lists.postgresql.org; Thu, 01 Jul 2021 17:40:02 +0000 Content-Type: multipart/mixed; boundary="===============1671459314394809597==" MIME-Version: 1.0 Subject: BUG #17079: btree_gin and type coersion combination doesn't work To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: maxim.boguk@gmail.com Reply-To: maxim.boguk@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 01 Jul 2021 17:39:24 +0000 Message-ID: <17079-c5edf57c47debc2c@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 --===============1671459314394809597== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzA3OQpMb2dnZWQgYnk6ICAgICAgICAgIE1heGltIEJvZ3VrCkVtYWls IGFkZHJlc3M6ICAgICAgbWF4aW0uYm9ndWtAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lvbjog MTMuMwpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAgCgpIaSwN Cg0KVGhlcmUgYXJlIHNpbXBsZSBjYXNlIHdoZW4gdHlwZSBjb2VyY2lvbiB3b3JrIHdpdGggY29t bW9uIGJ0cmVlIGluZGV4IGJ1dApkb2Vzbid0IHdvcmsgd2l0aCBidHJlZV9naW4uDQoocmVhc29u IGZvciB0ZXN0aW5nIGJ0cmVlX2dpbiB3YXMgZmFjdCB0aGF0IHRoZSBidHJlZV9naW4gaW5kZXgg Y291bGQKcHJvdmlkZSBvdmVyIDEweCBzaXplIHJlZHVjdGlvbiBmb3Igc29tZSBjb2x1bW4gd2l0 aCBtZWRpdW0gdG8gbG93CmNhcmRpbmFsaXR5IHdoaWNoIHByb3ZpZGVzIGh1Z2Ugc2F2aW5ncyBm b3IgYXJjaGl2ZSB0YWJsZXMpOg0KDQp0ZXN0PSMgY3JlYXRlIHRhYmxlIHRlc3QgYXMgc2VsZWN0 IGlkOjpiaWdpbnQgZnJvbQpnZW5lcmF0ZV9zZXJpZXMoMSwxMDAwMDAwKSBhcyBnKGlkKTsNClNF TEVDVCAxMDAwMDAwDQp0ZXN0PSMgY3JlYXRlIGluZGV4IHRlc3RfaWRfYnRyZWUgb24gdGVzdCB1 c2luZyBidHJlZShpZCk7DQpDUkVBVEUgSU5ERVgNCnRlc3Q9IyBhbmFseXplIHRlc3Q7DQpBTkFM WVpFDQp0ZXN0PSMgZXhwbGFpbiBhbmFseXplIHNlbGVjdCAqIGZyb20gdGVzdCB3aGVyZSBpZD0x MDAwMDsNCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICBRVUVSWSBQTEFOICAgICAgICAgICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBJbmRleCBPbmx5IFNjYW4gdXNpbmcgdGVzdF9pZF9i dHJlZSBvbiB0ZXN0ICAoY29zdD0wLjQyLi44LjQ0IHJvd3M9MQp3aWR0aD04KSAoYWN0dWFsIHRp bWU9MC4xMDEuLjAuMTAzIHJvd3M9MSBsb29wcz0xKQ0KICAgSW5kZXggQ29uZDogKGlkID0gMTAw MDApDQogICBIZWFwIEZldGNoZXM6IDENCiBQbGFubmluZyBUaW1lOiAwLjMyMiBtcw0KIEV4ZWN1 dGlvbiBUaW1lOiAwLjE0MCBtcw0KKDUgcm93cykNCg0KLS0gc28gZmFyIGFsbCBnb29kDQoNCnRl c3Q9IyBkcm9wIGluZGV4IHRlc3RfaWRfYnRyZWU7DQpEUk9QIElOREVYDQp0ZXN0PSMgY3JlYXRl IGluZGV4IHRlc3RfaWRfYnRyZWUgb24gdGVzdCB1c2luZyBnaW4oaWQpOw0KQ1JFQVRFIElOREVY DQp0ZXN0PSMgYW5hbHl6ZSB0ZXN0Ow0KQU5BTFlaRQ0KDQotLSBtYW51YWwgdHlwZSBjb2VyY2lv biB3b3JrDQp0ZXN0PSMgZXhwbGFpbiBhbmFseXplIHNlbGVjdCAqIGZyb20gdGVzdCB3aGVyZSBp ZD0xMDAwMDo6YmlnaW50Ow0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgUVVFUlkgUExBTiAgICAgICAgICAgIAogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogQml0bWFwIEhlYXAgU2NhbiBvbiB0ZXN0 ICAoY29zdD0yMC4wMS4uMjQuMDIgcm93cz0xIHdpZHRoPTgpIChhY3R1YWwKdGltZT0wLjIyOS4u MC4yMzIgcm93cz0xIGxvb3BzPTEpDQogICBSZWNoZWNrIENvbmQ6IChpZCA9ICcxMDAwMCc6OmJp Z2ludCkNCiAgIEhlYXAgQmxvY2tzOiBleGFjdD0xDQogICAtPiAgQml0bWFwIEluZGV4IFNjYW4g b24gdGVzdF9pZF9idHJlZSAgKGNvc3Q9MC4wMC4uMjAuMDEgcm93cz0xIHdpZHRoPTApCihhY3R1 YWwgdGltZT0wLjE1Ny4uMC4xNTggcm93cz0xIGxvb3BzPTEpDQogICAgICAgICBJbmRleCBDb25k OiAoaWQgPSAnMTAwMDAnOjpiaWdpbnQpDQogUGxhbm5pbmcgVGltZTogMC4yNTggbXMNCiBFeGVj dXRpb24gVGltZTogMC4zNTkgbXMNCig3IHJvd3MpDQoNCi0tYmlnaW50IGlucHV0IHdvcmsgYXMg d2VsbA0KdGVzdD0jIGV4cGxhaW4gYW5hbHl6ZSBzZWxlY3QgKiBmcm9tIHRlc3Qgd2hlcmUgaWQ9 MTAwMDAwMDAwMDA7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICBRVUVSWSBQTEFOICAgICAgICAgICAgCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBCaXRtYXAgSGVhcCBTY2FuIG9uIHRlc3QgIChj b3N0PTIwLjAxLi4yNC4wMiByb3dzPTEgd2lkdGg9OCkgKGFjdHVhbAp0aW1lPTAuMDI4Li4wLjAz MCByb3dzPTAgbG9vcHM9MSkNCiAgIFJlY2hlY2sgQ29uZDogKGlkID0gJzEwMDAwMDAwMDAwJzo6 YmlnaW50KQ0KICAgLT4gIEJpdG1hcCBJbmRleCBTY2FuIG9uIHRlc3RfaWRfYnRyZWUgIChjb3N0 PTAuMDAuLjIwLjAxIHJvd3M9MSB3aWR0aD0wKQooYWN0dWFsIHRpbWU9MC4wMjMuLjAuMDI0IHJv d3M9MCBsb29wcz0xKQ0KICAgICAgICAgSW5kZXggQ29uZDogKGlkID0gJzEwMDAwMDAwMDAwJzo6 YmlnaW50KQ0KIFBsYW5uaW5nIFRpbWU6IDAuMTI3IG1zDQogRXhlY3V0aW9uIFRpbWU6IDAuMDkx IG1zDQoNCi0tc3VycHJpc2UgaW5kZXggaXNuJ3QgdXNlZA0KdGVzdD0jIGV4cGxhaW4gYW5hbHl6 ZSBzZWxlY3QgKiBmcm9tIHRlc3Qgd2hlcmUgaWQ9MTAwMDA7DQogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTiAgICAgICAgICAgICAg CiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIEdhdGhlciAgKGNvc3Q9 MTAwMC4wMC4uMTA2MzMuNDMgcm93cz0xIHdpZHRoPTgpIChhY3R1YWwgdGltZT0xLjgzNS4uNTUu OTM5CnJvd3M9MSBsb29wcz0xKQ0KICAgV29ya2VycyBQbGFubmVkOiAyDQogICBXb3JrZXJzIExh dW5jaGVkOiAyDQogICAtPiAgUGFyYWxsZWwgU2VxIFNjYW4gb24gdGVzdCAgKGNvc3Q9MC4wMC4u OTYzMy4zMyByb3dzPTEgd2lkdGg9OCkKKGFjdHVhbCB0aW1lPTMyLjE2My4uNDkuMTc0IHJvd3M9 MCBsb29wcz0zKQ0KICAgICAgICAgRmlsdGVyOiAoaWQgPSAxMDAwMCkNCiAgICAgICAgIFJvd3Mg UmVtb3ZlZCBieSBGaWx0ZXI6IDMzMzMzMw0KIFBsYW5uaW5nIFRpbWU6IDAuMTk0IG1zDQogRXhl Y3V0aW9uIFRpbWU6IDU1Ljk1NSBtcw0KDQpJcyBpdCBleHBlY3RlZCBiZWhhdmlvciBvciBidWc/ DQoNCktpbmQgUmVnYXJkcywNCk1heGltCgo= --===============1671459314394809597==--