To: pgsql-hackers <pgsql-hackers@postgresql.org>
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Subject: Add tests for bytea LIKE operator
Organization: EnterpriseDB
Message-ID: <4d13563a-2c8d-fd91-20d5-e71b7a4eaa87@enterprisedb.com>
Date: Thu, 11 Feb 2021 14:23:14 +0100
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0)
 Gecko/20100101 Thunderbird/52.9.1
MIME-Version: 1.0
Content-Type: multipart/mixed;
 boundary="------------509AA672EEDD60201FD36B6F"
Content-Language: en-US
Precedence: bulk

This is a multi-part message in MIME format.
--------------509AA672EEDD60201FD36B6F
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

A few more easy tests for things not covered at all:

     bytea LIKE bytea (bytealike)
     bytea NOT LIKE bytea (byteanlike)
     ESCAPE clause for the above (like_escape_bytea)

also

     name NOT ILIKE text (nameicnlike)

See also 
<https://coverage.postgresql.org/src/backend/utils/adt/like.c.func-sort-c.html>.

--------------509AA672EEDD60201FD36B6F
Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0";
 name="0001-Add-tests-for-bytea-LIKE-operator.patch"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="0001-Add-tests-for-bytea-LIKE-operator.patch"

RnJvbSBlNmFmNGE3YmFhMjcwM2NjODIzOWEzZTk2NzBkMjFlZjM2MDA5ZTkwIE1vbiBTZXAg
MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBQZXRlciBFaXNlbnRyYXV0IDxwZXRlckBlaXNlbnRy
YXV0Lm9yZz4KRGF0ZTogVGh1LCAxMSBGZWIgMjAyMSAxNDoyMTowNiArMDEwMApTdWJqZWN0
OiBbUEFUQ0hdIEFkZCB0ZXN0cyBmb3IgYnl0ZWEgTElLRSBvcGVyYXRvcgoKQWRkIHRlc3Qg
Y292ZXJhZ2UgZm9yIHRoZSBmb2xsb3dpbmcgb3BlcmF0aW9ucywgd2hpY2ggd2VyZSBwcmV2
aW91c2x5Cm5vdCB0ZXN0ZWQgYXQgYWxsOgoKYnl0ZWEgTElLRSBieXRlYSAoYnl0ZWFsaWtl
KQpieXRlYSBOT1QgTElLRSBieXRlYSAoYnl0ZWFubGlrZSkKRVNDQVBFIGNsYXVzZSBmb3Ig
dGhlIGFib3ZlIChsaWtlX2VzY2FwZV9ieXRlYSkKCmFsc28KCm5hbWUgTk9UIElMSUtFIHRl
eHQgKG5hbWVpY25saWtlKQotLS0KIHNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvc3RyaW5n
cy5vdXQgfCA0OCArKysrKysrKysrKysrKysrKysrKysrKysrKysKIHNyYy90ZXN0L3JlZ3Jl
c3Mvc3FsL3N0cmluZ3Muc3FsICAgICAgfCAxMiArKysrKysrCiAyIGZpbGVzIGNoYW5nZWQs
IDYwIGluc2VydGlvbnMoKykKCmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVj
dGVkL3N0cmluZ3Mub3V0IGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zdHJpbmdzLm91
dAppbmRleCA3YzkxYWZhNmU0Li5mYjQ1NzNkODVmIDEwMDY0NAotLS0gYS9zcmMvdGVzdC9y
ZWdyZXNzL2V4cGVjdGVkL3N0cmluZ3Mub3V0CisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3MvZXhw
ZWN0ZWQvc3RyaW5ncy5vdXQKQEAgLTEwMzUsNiArMTAzNSwzMCBAQCBTRUxFQ1QgJ2luZGlv
JyBOT1QgTElLRSAnaW5fbycgQVMgInRydWUiOwogIHQKICgxIHJvdykKIAorU0VMRUNUICdh
YmMnOjpuYW1lIExJS0UgJ19iXycgQVMgInRydWUiOworIHRydWUgCistLS0tLS0KKyB0Ciso
MSByb3cpCisKK1NFTEVDVCAnYWJjJzo6bmFtZSBOT1QgTElLRSAnX2JfJyBBUyAiZmFsc2Ui
OworIGZhbHNlIAorLS0tLS0tLQorIGYKKygxIHJvdykKKworU0VMRUNUICdhYmMnOjpieXRl
YSBMSUtFICdfYl8nOjpieXRlYSBBUyAidHJ1ZSI7CisgdHJ1ZSAKKy0tLS0tLQorIHQKKygx
IHJvdykKKworU0VMRUNUICdhYmMnOjpieXRlYSBOT1QgTElLRSAnX2JfJzo6Ynl0ZWEgQVMg
ImZhbHNlIjsKKyBmYWxzZSAKKy0tLS0tLS0KKyBmCisoMSByb3cpCisKIC0tIHVudXNlZCBl
c2NhcGUgY2hhcmFjdGVyCiBTRUxFQ1QgJ2hhd2tleWUnIExJS0UgJ2glJyBFU0NBUEUgJyMn
IEFTICJ0cnVlIjsKICB0cnVlIApAQCAtMTE1OCw2ICsxMTgyLDE4IEBAIFNFTEVDVCAnaV9k
aW8nIE5PVCBMSUtFICdpJF9kJW8nIEVTQ0FQRSAnJCcgQVMgImZhbHNlIjsKICBmCiAoMSBy
b3cpCiAKK1NFTEVDVCAnYV9jJzo6Ynl0ZWEgTElLRSAnYSRfXyc6OmJ5dGVhIEVTQ0FQRSAn
JCc6OmJ5dGVhIEFTICJ0cnVlIjsKKyB0cnVlIAorLS0tLS0tCisgdAorKDEgcm93KQorCitT
RUxFQ1QgJ2FfYyc6OmJ5dGVhIE5PVCBMSUtFICdhJF9fJzo6Ynl0ZWEgRVNDQVBFICckJzo6
Ynl0ZWEgQVMgImZhbHNlIjsKKyBmYWxzZSAKKy0tLS0tLS0KKyBmCisoMSByb3cpCisKIC0t
IGVzY2FwZSBjaGFyYWN0ZXIgc2FtZSBhcyBwYXR0ZXJuIGNoYXJhY3RlcgogU0VMRUNUICdt
YWNhJyBMSUtFICdtJWFjYScgRVNDQVBFICclJyBBUyAidHJ1ZSI7CiAgdHJ1ZSAKQEAgLTEy
NzEsNiArMTMwNywxOCBAQCBTRUxFQ1QgJ0hhd2tleWUnIE5PVCBJTElLRSAnaCUnIEFTICJm
YWxzZSI7CiAgZgogKDEgcm93KQogCitTRUxFQ1QgJ0FCQyc6Om5hbWUgSUxJS0UgJ19iXycg
QVMgInRydWUiOworIHRydWUgCistLS0tLS0KKyB0CisoMSByb3cpCisKK1NFTEVDVCAnQUJD
Jzo6bmFtZSBOT1QgSUxJS0UgJ19iXycgQVMgImZhbHNlIjsKKyBmYWxzZSAKKy0tLS0tLS0K
KyBmCisoMSByb3cpCisKIC0tCiAtLSB0ZXN0ICUvXyBjb21iaW5hdGlvbiBjYXNlcywgY2Yg
YnVncyAjNDgyMSBhbmQgIzU0NzgKIC0tCmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdyZXNz
L3NxbC9zdHJpbmdzLnNxbCBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3N0cmluZ3Muc3FsCmlu
ZGV4IGVmNGJmYjAwOGEuLjU3YTQ4YzlkMGIgMTAwNjQ0Ci0tLSBhL3NyYy90ZXN0L3JlZ3Jl
c3Mvc3FsL3N0cmluZ3Muc3FsCisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3N0cmluZ3Mu
c3FsCkBAIC0zMDAsNiArMzAwLDEyIEBACiBTRUxFQ1QgJ2luZGlvJyBMSUtFICdpbl9vJyBB
UyAiZmFsc2UiOwogU0VMRUNUICdpbmRpbycgTk9UIExJS0UgJ2luX28nIEFTICJ0cnVlIjsK
IAorU0VMRUNUICdhYmMnOjpuYW1lIExJS0UgJ19iXycgQVMgInRydWUiOworU0VMRUNUICdh
YmMnOjpuYW1lIE5PVCBMSUtFICdfYl8nIEFTICJmYWxzZSI7CisKK1NFTEVDVCAnYWJjJzo6
Ynl0ZWEgTElLRSAnX2JfJzo6Ynl0ZWEgQVMgInRydWUiOworU0VMRUNUICdhYmMnOjpieXRl
YSBOT1QgTElLRSAnX2JfJzo6Ynl0ZWEgQVMgImZhbHNlIjsKKwogLS0gdW51c2VkIGVzY2Fw
ZSBjaGFyYWN0ZXIKIFNFTEVDVCAnaGF3a2V5ZScgTElLRSAnaCUnIEVTQ0FQRSAnIycgQVMg
InRydWUiOwogU0VMRUNUICdoYXdrZXllJyBOT1QgTElLRSAnaCUnIEVTQ0FQRSAnIycgQVMg
ImZhbHNlIjsKQEAgLTMzMyw2ICszMzksOSBAQAogU0VMRUNUICdpX2RpbycgTElLRSAnaSRf
ZCVvJyBFU0NBUEUgJyQnIEFTICJ0cnVlIjsKIFNFTEVDVCAnaV9kaW8nIE5PVCBMSUtFICdp
JF9kJW8nIEVTQ0FQRSAnJCcgQVMgImZhbHNlIjsKIAorU0VMRUNUICdhX2MnOjpieXRlYSBM
SUtFICdhJF9fJzo6Ynl0ZWEgRVNDQVBFICckJzo6Ynl0ZWEgQVMgInRydWUiOworU0VMRUNU
ICdhX2MnOjpieXRlYSBOT1QgTElLRSAnYSRfXyc6OmJ5dGVhIEVTQ0FQRSAnJCc6OmJ5dGVh
IEFTICJmYWxzZSI7CisKIC0tIGVzY2FwZSBjaGFyYWN0ZXIgc2FtZSBhcyBwYXR0ZXJuIGNo
YXJhY3RlcgogU0VMRUNUICdtYWNhJyBMSUtFICdtJWFjYScgRVNDQVBFICclJyBBUyAidHJ1
ZSI7CiBTRUxFQ1QgJ21hY2EnIE5PVCBMSUtFICdtJWFjYScgRVNDQVBFICclJyBBUyAiZmFs
c2UiOwpAQCAtMzY3LDYgKzM3Niw5IEBACiBTRUxFQ1QgJ0hhd2tleWUnIElMSUtFICdoJScg
QVMgInRydWUiOwogU0VMRUNUICdIYXdrZXllJyBOT1QgSUxJS0UgJ2glJyBBUyAiZmFsc2Ui
OwogCitTRUxFQ1QgJ0FCQyc6Om5hbWUgSUxJS0UgJ19iXycgQVMgInRydWUiOworU0VMRUNU
ICdBQkMnOjpuYW1lIE5PVCBJTElLRSAnX2JfJyBBUyAiZmFsc2UiOworCiAtLQogLS0gdGVz
dCAlL18gY29tYmluYXRpb24gY2FzZXMsIGNmIGJ1Z3MgIzQ4MjEgYW5kICM1NDc4CiAtLQot
LSAKMi4zMC4wCgo=
--------------509AA672EEDD60201FD36B6F--