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 1pkViK-0002zl-6Q for pgsql-committers@arkaria.postgresql.org; Thu, 06 Apr 2023 19:56:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pkViI-0007ZY-6h for pgsql-committers@arkaria.postgresql.org; Thu, 06 Apr 2023 19:56:06 +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 1pkVfN-0005o8-2t for pgsql-committers@lists.postgresql.org; Thu, 06 Apr 2023 19:53:05 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pkVfF-001IvX-Ea for pgsql-committers@lists.postgresql.org; Thu, 06 Apr 2023 19:53:04 +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 1pkVfE-0003SO-0a for pgsql-committers@lists.postgresql.org; Thu, 06 Apr 2023 19:52:56 +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 1pkVfC-001jC6-4T for pgsql-committers@lists.postgresql.org; Thu, 06 Apr 2023 19:52:55 +0000 Content-Type: multipart/mixed; boundary="===============6028164783668949056==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix ts_headline() edge cases for empty query and empty search te X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 06 Apr 2023 19:52:55 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6028164783668949056== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHRzX2hlYWRsaW5lKCkgZWRnZSBjYXNlcyBmb3IgZW1wdHkgcXVlcnkgYW5kIGVtcHR5IHNl YXJjaCB0ZXh0LgoKdHNxdWVyeSdzIEdFVFFVRVJZKCkgbWFjcm8gaXMgb25seSBzYWZlIHRvIGFw cGx5IHRvIGEgdHNxdWVyeQp0aGF0IGlzIGtub3duIG5vbi1lbXB0eTsgb3RoZXJ3aXNlIGl0IGdp dmVzIGEgcG9pbnRlciB0byBnYXJiYWdlLgpCZWZvcmUgY29tbWl0IDVhNjE3ZDc1ZCwgdHNfaGVh ZGxpbmUoKSBhdm9pZGVkIHRoaXMgcGl0ZmFsbCwgYnV0Cm9ubHkgaW4gYSB2ZXJ5IGluZGlyZWN0 LCBub25vYnZpb3VzIHdheS4gIChobENvdmVyIGNvdWxkIG5vdCByZWFjaAppdHMgVFNfZXhlY3V0 ZSBjYWxsLCBiZWNhdXNlIGlmIHRoZSBxdWVyeSBjb250YWlucyBubyBsZXhlbWVzCnRoZW4gaGxG aXJzdEluZGV4IHdvdWxkIHN1cmVseSByZXR1cm4gLTEuKSAgQWZ0ZXIgdGhhdCBjb21taXQsCml0 IGZlbGwgaW50byB0aGUgdHJhcCwgcmVzdWx0aW5nIGluIHdlaXJkIGVycm9ycyBzdWNoIGFzCiJ1 bnJlY29nbml6ZWQgb3BlcmF0b3IiIGFuZC9vciB2YWxncmluZCBjb21wbGFpbnRzLiAgSW4gSEVB RCwKZml4IHRoaXMgYnkgbm90IGNhbGxpbmcgVFNfZXhlY3V0ZV9sb2NhdGlvbnMoKSBhdCBhbGwg Zm9yIGFuCmVtcHR5IHF1ZXJ5LiAgSW4gdGhlIGJhY2sgYnJhbmNoZXMsIGFkZCBhIGRlZmVuc2l2 ZSBjaGVjayB0bwpobENvdmVyKCkgLS0tIHRoYXQncyBub3QgZml4aW5nIGFueSBsaXZlIGJ1Zywg YnV0IEkganVkZ2UgdGhlCmNvZGUgYSBiaXQgdG9vIGZyYWdpbGUgYXMtaXMuCgpBbHNvLCBib3Ro IG1hcmtfaGxfZnJhZ21lbnRzKCkgYW5kIG1hcmtfaGxfd29yZHMoKSB3ZXJlIGNhcmVsZXNzCmFi b3V0IHRoZSBwb3NzaWJpbGl0eSBvZiBlbXB0eSBzZWFyY2ggdGV4dDogaW4gdGhlIGNhc2VzIHdo ZXJlCm5vIG1hdGNoIGhhcyBiZWVuIGZvdW5kLCB0aGV5J2QgZW5kIHVwIHRlbGxpbmcgbWFya19m cmFnbWVudCgpIHRvCm1hcmsgZnJvbSB3b3JkIGluZGV4ZXMgMCB0byAwIGluY2x1c2l2ZSwgZXZl biB3aGVuIHRoZXJlIGlzIG5vCndvcmQgMC4gIFRoaXMgaXMgaGFybWxlc3Mgc2luY2Ugd2Ugb3Zl ci1hbGxvY2F0ZWQgdGhlIHBycy0+d29yZHMKYXJyYXksIGJ1dCBpdCBkb2VzIGFubm95IHZhbGdy aW5kLiAgRml4IHNvIHRoYXQgdGhlIGVuZCBpbmRleCBpcyAtMQphbmQgdGh1cyBtYXJrX2ZyYWdt ZW50KCkgd2lsbCBkbyBub3RoaW5nIGluIHN1Y2ggY2FzZXMuCgpCb3R0b20gbGluZSBpcyB0aGF0 IHRoaXMgZml4ZXMgYSBsaXZlIGJ1ZyBpbiBIRUFELCBidXQgaW4gdGhlCmJhY2sgYnJhbmNoZXMg aXQncyBvbmx5IGdldHRpbmcgcmlkIG9mIGEgdmFsZ3JpbmQgbml0cGljay4KQmFjay1wYXRjaCBh bnl3YXkuCgpQZXIgcmVwb3J0IGZyb20gQWxleGFuZGVyIExha2hpbi4KCkRpc2N1c3Npb246IGh0 dHBzOi8vcG9zdGdyLmVzL20vYzI3ZjY0MmQtMDIwYi0wMWZmLWFlNjEtMDg2YWYyODdjNGZkQGdt YWlsLmNvbQoKQnJhbmNoCi0tLS0tLQpSRUxfMTNfU1RBQkxFCgpEZXRhaWxzCi0tLS0tLS0KaHR0 cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9iN2Q2YzUxZDQ2OTM3NjUzNTRh MWY2MGU2ZWI0NTAxMGJkZGYwMjNkCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMv YmFja2VuZC90c2VhcmNoL3dwYXJzZXJfZGVmLmMgICAgIHwgIDggKysrKysrLS0Kc3JjL3Rlc3Qv cmVncmVzcy9leHBlY3RlZC90c2VhcmNoLm91dCB8IDIxICsrKysrKysrKysrKysrKysrKysrKwpz cmMvdGVzdC9yZWdyZXNzL3NxbC90c2VhcmNoLnNxbCAgICAgIHwgIDYgKysrKysrCjMgZmlsZXMg Y2hhbmdlZCwgMzMgaW5zZXJ0aW9ucygrKSwgMiBkZWxldGlvbnMoLSkKCg== --===============6028164783668949056==--