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 1oUDon-0002V3-Dx for pgsql-committers@arkaria.postgresql.org; Fri, 02 Sep 2022 21:03:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oUDnn-0000fS-FL for pgsql-committers@arkaria.postgresql.org; Fri, 02 Sep 2022 21:02:11 +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 1oUDnn-0000fJ-86 for pgsql-committers@lists.postgresql.org; Fri, 02 Sep 2022 21:02:11 +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 1oUDng-0006wk-Ol for pgsql-committers@lists.postgresql.org; Fri, 02 Sep 2022 21:02:10 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oUDne-0007mo-I7 for pgsql-committers@lists.postgresql.org; Fri, 02 Sep 2022 21:02:02 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1oUDnd-0018RN-Au for pgsql-committers@lists.postgresql.org; Fri, 02 Sep 2022 21:02:01 +0000 Content-Type: multipart/mixed; boundary="===============2305350380895281352==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix planner to consider matches to boolean columns in extension X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 02 Sep 2022 21:02:01 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2305350380895281352== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHBsYW5uZXIgdG8gY29uc2lkZXIgbWF0Y2hlcyB0byBib29sZWFuIGNvbHVtbnMgaW4gZXh0 ZW5zaW9uIGluZGV4ZXMuCgpUaGUgcGxhbm5lciBoYXMgdG8gc3BlY2lhbC1jYXNlIGluZGV4ZXMg b24gYm9vbGVhbiBjb2x1bW5zLCBiZWNhdXNlCndoYXQgd2UgbmVlZCBmb3IgYW4gaW5kZXhzY2Fu IG9uIHN1Y2ggYSBjb2x1bW4gaXMgYSBxdWFsIG9mIHRoZSBzaGFwZQpvZiAiYm9vbHZhciA9IHBz ZXVkb2NvbnN0YW50Ii4gIEZvciBwbGFpbiBib29sIGNvbnN0YW50cywgcHJldmlvdXMKc2ltcGxp ZmljYXRpb24gd2lsbCBoYXZlIHJlZHVjZWQgdGhpcyB0byAiYm9vbHZhciIgb3IgIk5PVCBib29s dmFyIiwKYW5kIHdlIGhhdmUgdG8gcmV2ZXJzZSB0aGF0IGlmIHdlIHdhbnQgdG8gbWFrZSBhbiBp bmRleHF1YWwuICBUaGVyZSBpcwpleGlzdGluZyBjb2RlIHRvIGRvIHNvLCBidXQgaXQgb25seSBm aXJlcyB3aGVuIHRoZSBpbmRleCdzIG9wZmFtaWx5CmlzIEJPT0xfQlRSRUVfRkFNX09JRCBvciBC T09MX0hBU0hfRkFNX09JRC4gIFRodXMgZXh0ZW5zaW9uIEFNcywgb3IKZXh0ZW5zaW9uIG9wY2xh c3NlcyBzdWNoIGFzIGNvbnRyaWIvYnRyZWVfZ2luLCBhcmUgb3V0IGluIHRoZSBjb2xkLgoKVGhl IHJlYXNvbiBmb3IgaGFyZC13aXJpbmcgdGhlIHNldCBvZiByZWxldmFudCBvcGZhbWlsaWVzIHdh cyBtb3N0bHkKdG8gYXZvaWQgYSBjYXRhbG9nIGxvb2t1cCBpbiBhIGhvdCBjb2RlIHBhdGguICBX ZSBjYW4gaW1wcm92ZSBtYXR0ZXJzCndoaWxlIG5vdCB0YWtpbmcgbXVjaCBvZiBhIHBlcmZvcm1h bmNlIGhpdCBieSByZWx5aW5nIG9uIHRoZQpoYXJkLXdpcmVkIHNldCB3aGVuIHRoZSBvcGZhbWls eSBPSUQgaXMgdmlzaWJseSBidWlsdC1pbiwgYW5kIG9ubHkKY2hlY2tpbmcgdGhlIGNhdGFsb2dz IHdoZW4gZGVhbGluZyB3aXRoIGFuIGV4dGVuc2lvbiBvcGZhbWlseS4KCldoaWxlIGhlcmUsIHJl bmFtZSBJc0Jvb2xlYW5PcGZhbWlseSB0byBJc0J1aWx0aW5Cb29sZWFuT3BmYW1pbHkKdG8gcmVt aW5kIGZ1dHVyZSB1c2VycyBvZiB0aGF0IG1hY3JvIG9mIGl0cyBsaW1pdGF0aW9ucy4gIEF0IHNv bWUKcG9pbnQgd2UgbWlnaHQgd2FudCB0byBtYWtlIGluZHhwYXRoLmMncyBpbXByb3ZlZCB2ZXJz aW9uIG9mIHRoZQp0ZXN0IGdsb2JhbGx5IGFjY2Vzc2libGUsIGJ1dCBpdCdzIG5vdCBwcmVzZW50 bHkgbmVlZGVkIGVsc2V3aGVyZS4KClpvbmdsaWFuZyBRdWFuIGFuZCBUb20gTGFuZQoKRGlzY3Vz c2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9mMjkzYjkxZC0xZDQ2LWQzODYtYjZiYi00YjA2ZmY1 YzY2N2JAeWVhaC5uZXQKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0 cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9mZjcyMGE1OTdjMGE1M2E4ZmNk ZjJjZjRlNDUyNDhkYzVjMzdmOWFiCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpjb250 cmliL2J0cmVlX2dpbi9leHBlY3RlZC9ib29sLm91dCAgIHwgMTAgKysrKysrLS0tLQpjb250cmli L2J0cmVlX2dpc3QvZXhwZWN0ZWQvYm9vbC5vdXQgIHwgIDQgKystLQpzcmMvYmFja2VuZC9vcHRp bWl6ZXIvcGF0aC9pbmR4cGF0aC5jIHwgMTggKysrKysrKysrKysrKysrKysrCnNyYy9iYWNrZW5k L29wdGltaXplci9wYXRoL3BhdGhrZXlzLmMgfCAgOSArKysrKysrLS0Kc3JjL2JhY2tlbmQvcGFy dGl0aW9uaW5nL3BhcnRwcnVuZS5jICB8ICA2ICsrKysrLQpzcmMvaW5jbHVkZS9jYXRhbG9nL3Bn X29wZmFtaWx5LmggICAgIHwgIDMgKystCjYgZmlsZXMgY2hhbmdlZCwgNDAgaW5zZXJ0aW9ucygr KSwgMTAgZGVsZXRpb25zKC0pCgo= --===============2305350380895281352==--