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 1n3ccE-0006Pk-P9 for pgsql-bugs@arkaria.postgresql.org; Sat, 01 Jan 2022 11:32:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n3ccB-0003ik-J1 for pgsql-bugs@arkaria.postgresql.org; Sat, 01 Jan 2022 11:31:59 +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 1n2xf5-0006MO-CM for pgsql-bugs@lists.postgresql.org; Thu, 30 Dec 2021 15:48:15 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n2xeu-0001op-MT for pgsql-bugs@lists.postgresql.org; Thu, 30 Dec 2021 15:48:14 +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=7qUvs/EciZqUq3uns3cHnfqbiDaz8KPUYYWPqZEzy/M=; b=4I8r+pxx2tlfw+kC1V599v1s5E 6M927aCE1fM0jOaabGhIRHvK6YQYjzuf2ETr+0rDdFPnp7V3WhSMrbm0uzrbZdIwYFY4w2pIhR2+8 UGzPliuiu6U26kpAKq/bs8BaXiK6DcXlK9f+eVXHWsYd5hZRyEIhb7zH2q5Tqpd7NYWE6hlm/d0xL P3fZpNCqD9qyCRkMm3IdLdQb09Tdmaoe6yLGZ554ux8gp/Amyt8WH8Rd1bk42tP4SQDL2ZF7qphOm bmSkohRmKdU0R2UMvNJXLrQ95n+UWfcoUWLU4y8MpODLOwXmjhZDtMxvrIwFaOnWZeyLoSwX+9sjK OYOOEshA==; 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 1n2xet-0007c5-Dh for pgsql-bugs@lists.postgresql.org; Thu, 30 Dec 2021 15:48:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n2xes-0000Db-9B for pgsql-bugs@lists.postgresql.org; Thu, 30 Dec 2021 15:48:02 +0000 Content-Type: multipart/mixed; boundary="===============5384567090851144430==" MIME-Version: 1.0 Subject: BUG #17350: GIST TRGM Index is broken when combining with combining INCLUDE with a string function (e.g. lower). To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: louis.jachiet@telecom-paris.fr Reply-To: louis.jachiet@telecom-paris.fr, pgsql-bugs@lists.postgresql.org Date: Thu, 30 Dec 2021 15:47:06 +0000 Message-ID: <17350-b5bdcf476e5badbb@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 --===============5384567090851144430== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzM1MApMb2dnZWQgYnk6ICAgICAgICAgIGxvdWlzIGphY2hpZXQKRW1h aWwgYWRkcmVzczogICAgICBsb3Vpcy5qYWNoaWV0QHRlbGVjb20tcGFyaXMuZnIKUG9zdGdyZVNR TCB2ZXJzaW9uOiAxMy40Ck9wZXJhdGluZyBzeXN0ZW06ICAgQXJjaGxpbnV4CkRlc2NyaXB0aW9u OiAgICAgICAgCgpIZWxsbyBldmVyeW9uZSwNCg0KSSBob3BlIHRoaXMgaXMgbm90IGEgZHVwbGlj YXRlIG9mIGEgc2ltaWxhciBidWcgKEkgdHJpZWQgdG8gY2hlY2vigKYpLiBHSVNUClRSR00gSW5k ZXggc2VlbXMgdG8gcmV0dXJuDQp3cm9uZyB2YWx1ZXMgd2hlbiBwb3B1bGF0ZWQgd2l0aCBhIHN0 cmluZyBmdW5jdGlvbiAoc3VjaCBhcyBsb3dlcikgIGFuZCBhbgppbmNsdWRlLiBJZiBJIGlzc3Vl IHRoZSANCmZvbGxvd2luZyBsaW5lcywgaW5zdGVhZCBvZiByZXR1cm5pbmcgJ2ZvbycgYW5kICdi YXInLCBwb3N0Z3Jlc3FsIHdpbGwKcmV0dXJuICB0d28gZW1wdHkgbGluZXM6DQoNCiAgICBDUkVB VEUgRVhURU5TSU9OIElGIE5PVCBFWElTVFMgcGdfdHJnbSA7DQogICAgQ1JFQVRFIFRBQkxFIHQg KGEgVkFSQ0hBUig1MCkpOw0KICAgIElOU0VSVCBJTlRPIHQgVkFMVUVTICgnZm9vJykgOw0KICAg IElOU0VSVCBJTlRPIHQgVkFMVUVTICgnQkFSJykgOw0KICAgIENSRUFURSBJTkRFWCB0ZXN0X2lk eCBPTiB0IFVTSU5HIGdpc3QobG93ZXIoYSkgZ2lzdF90cmdtX29wcykgSU5DTFVERQooYSkgOw0K ICAgIHNldCBlbmFibGVfc2Vxc2Nhbj1vZmYgOw0KICAgIFNFTEVDVCBsb3dlcihhKSBGUk9NIHQg Ow0KDQpPYnZpb3VzbHkgZm9yIHRoaXMgbGFzdCBTRUxFQ1QsIHRoZSBpbmRleCBpcyBvbmx5IHVz ZWZ1bCBiZWNhdXNlIG9mIHRoZQpzZXFzY2FuPW9mZiANCmJ1dCBpZiB5b3UgaGF2ZSBhIGxhcmdl IGRhdGFiYXNlIGFuZCBpc3N1ZSBhIGNvbW1hbmQgbGlrZToNCg0KICAgIFNFTEVDVCAxIEZST00g dCBXSEVSRSBsb3dlcihhKSBMSUtFICclbyUnIDsNCg0KdGhlbiB0aGUgb3V0cHV0IHdpbGwgYmUg YWxzbyBlbXB0eSBiZWNhdXNlIHRoZSBpbmRleCB3aWxsIHJldHVybiBlbXB0eSBsaW5lcwphbmQg dGhlIHJlY2hlY2sgY29uZGl0aW9uIHdpbGwgZmFpbC4NCklmIEkgdXNlIGEgZnVuY3Rpb24gZGlm ZmVyZW50IHRoYW4gbG93ZXIgKGUuZy4gdXBwZXIpIHRoZSBwcm9ibGVtIHBlcnNpc3RzCmJ1dCBp ZiByZW1vdmUgdGhlIGZ1bmN0aW9uIG9yIGlmIHJlbW92ZSB0aGUNCmluY2x1ZGUgdGhlbiBldmVy eXRoaW5nIHdvcmtzIGp1c3QgZmluZS4gSXQgcmVhbGx5IHNlZW1zIHRoYXQgaXQgaXMgdGhlCmNv bWJpbmF0aW9uIG9mIGluY2x1ZGUgKyBzdHJpbmcgZnVuY3Rpb24gKyBnaXN0IHRyZ20NCnRoYXQg bWFrZXMgdGhlIFNFTEVDVCByZXR1cm4gZW1wdHkgbGluZXMuIA0KDQpUaGFuayB5b3UgZm9yIHlv dXIgdGltZSENCg0KUmVnYXJkcwoK --===============5384567090851144430==--