Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uIDJT-000Jxk-Gz for pgsql-bugs@arkaria.postgresql.org; Thu, 22 May 2025 21:18:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uIDJS-008wcP-5Y for pgsql-bugs@arkaria.postgresql.org; Thu, 22 May 2025 21:18:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uIDJR-008wW7-Nv for pgsql-bugs@lists.postgresql.org; Thu, 22 May 2025 21:18:49 +0000 Received: from mail-ej1-x634.google.com ([2a00:1450:4864:20::634]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uIDJP-000NM5-1C for pgsql-bugs@lists.postgresql.org; Thu, 22 May 2025 21:18:48 +0000 Received: by mail-ej1-x634.google.com with SMTP id a640c23a62f3a-ac34257295dso1385511666b.2 for ; Thu, 22 May 2025 14:18:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1747948725; x=1748553525; darn=lists.postgresql.org; h=mime-version:user-agent:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=lCC0BEmTaHvJ2CPmzhM0VSssP7rFStb1vbDIkNa3Ikk=; b=UFr/AmRgHfdF6PyJEHTxIKhZR/juArrmLnIsbgP44pfR+3ALV2bA2aNWDK8hKnyRr+ GTR4UTVxldC1RqPpRg1YbL3KakfOJ25pQumO6a9HDZ5MdshLTPQ49O+Voe37N750wRNI uZvldbEzatmig+JmTjH1x4uaxFO/Zy237f0gV6dewa6I+lHzWvNfpdHnLTCXq71AbAER EuOSe90k8FfZ3Bp4YsrCPEJDfbV2Q1yAUgSpIaAcJvyc9NrdTSY0kJfd4vH9dRxGO/+W RUNzK5HJrYZ5wgU9MwaSM7QyXuxnLJOKfqdDO7F0BNdjdbXNGRBf9ZHEpk/e+T6oDwNH w4SA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1747948725; x=1748553525; h=mime-version:user-agent:date:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=lCC0BEmTaHvJ2CPmzhM0VSssP7rFStb1vbDIkNa3Ikk=; b=BiuJlwfPz4tFQhmwUx+BrFhfyPmgrc2Bjb8GViGHfutLeu03lPMpHBhHyatXL+JgMT E4iBkM2y7bWM1/QEIx4nyBIkqVsmzTAaXg2gcikIzN/NCu3MxJvgMTtOHlJNbKMrdrq9 QgwnXaGkFravqE8xscKOzFIbjnlGBIVwekgLTjMMfV8bh9l+Ptvjo4SHw6ijpoxNcY4o utCSpOvvv3SmYD3yY3R+ODAtvvi36hz0b8he46HJvY+BhXHdpfr4cVqKfNHcQwpktiS+ YSkDXRj37MSvUo8b/enfF4HQSibbDIUwUCP0aBxVeJP/A18orB8Fy4XNt08ontYR4OH4 qD4Q== X-Gm-Message-State: AOJu0Yx6awMm8ERZ7gHD8UTERB7h84s6Lo+Ge9HzKGLW05FSiFKG+uDg /sgRMI57plCEBi/hta7eGp1X/T5O5bBmOdOklYgDRvhyfvb02qKlBI5wIn9Zz8hb2qRBcV1QDOP tmcVNvDw= X-Gm-Gg: ASbGncsivxp8u5W4giPcYF6mMKKqwaiwlO92EL1lJvWWDSv8y7///hNE4rLCdecRo0w ZzukxTQBG1w6K6tF4L1Wtj2U6rRgfBBAWAuYJtgvgVdyH4IMLXo2MnhDU+VT9cLENfepo/oDLEm /ESF+kxg5LO/YjcQfdhhPm10Nn8NFeGvG+2JbT1ue/bJCVIhYKzxRi1HQ/0z2FNinNpb/FzXf1i EcLIOOw1EfBX428LTXXumUhJ0/tmGjSxea1nUerurnxODg0BXWcsenPcip4+KKYdkG05d8EDyH+ 2aOrufy1DY5wGXj7aiDg+nWPn4qDGxgtOix/3GmjjLyX3bCHWhTp6I2391jKijPXc4G9afN1La5 vkg2EfA== X-Google-Smtp-Source: AGHT+IFHmEPe9k34vTHgdSC0Kfu+8AFZayOZfPG8a5jVQYA+GF0emzLCBUTAF+ZO+Zuj/fxLP+yzWQ== X-Received: by 2002:a17:907:3f9d:b0:ad4:dd32:cfd0 with SMTP id a640c23a62f3a-ad70838ff31mr43971366b.5.1747948725506; Thu, 22 May 2025 14:18:45 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:255:52d3:3ac8:61ab:b634:342]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-ad52d278247sm1118617566b.76.2025.05.22.14.18.44 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 22 May 2025 14:18:45 -0700 (PDT) Message-ID: <16ab039d1af455652bdf4173402ddda145f2c73b.camel@cybertec.at> Subject: SIMILAR TO expressions translate wildcards where they shouldn't From: Laurenz Albe To: pgsql-bugs@lists.postgresql.org Date: Thu, 22 May 2025 23:18:44 +0200 Content-Type: multipart/mixed; boundary="=-oS/C8xXo98OpHd6w2vNl" User-Agent: Evolution 3.56.1 (3.56.1-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-oS/C8xXo98OpHd6w2vNl Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBzdXJwcmlzaW5nIHJlc3VsdAoKICBTRUxFQ1QgJ2FfYicgU0lNSUxBUiBU TyAnW19bOmFscGhhOl1dKicsCiAgICAgICAgICdhX2InIFNJTUlMQVIgVE8gJ1tbOmFscGhhOl1f XSonOwoKICAgP2NvbHVtbj8g4pSCID9jb2x1bW4/IAogIOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKV kOKVkOKVkOKVquKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkAogICB0ICAgICAgICDilIIg ZgogICgxIHJvdykKCmJlY29tZXMgY2xlYXIgd2hlbiB3ZSBsb29rIGhvdyB0aGUgZXhwcmVzc2lv bnMgYXJlIHRyYW5zbGF0ZWQgdG8KcmVndWxhciBleHByZXNzaW9uczoKCiAgRVhQTEFJTiAoVkVS Qk9TRSwgR0VORVJJQ19QTEFOLCBDT1NUUyBPRkYpCiAgU0VMRUNUICQxIFNJTUlMQVIgVE8gJ1tf WzphbHBoYTpdXSonLAogICAgICAgICAkMSBTSU1JTEFSIFRPICdbWzphbHBoYTpdX10qJzsKCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIAogIOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKV kOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKV kOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKV kOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKV kOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkOKVkAogICBSZXN1bHQK ICAgICBPdXRwdXQ6ICgkMSB+ICdeKD86W19bOmFscGhhOl1dKikkJzo6dGV4dCksICgkMSB+ICde KD86W1s6YWxwaGE6XS5dKikkJzo6dGV4dCkKICAoMiByb3dzKQoKVGhlIHVuZGVyc2NvcmUgYmVm b3JlIHRoZSBbOmFscGhhOl0gaXMgbGVmdCBhbG9uZSwgYnV0IHRoZSBvbmUgYWZ0ZXIKaXQgZ2V0 cyB0cmFuc2xhdGVkIHRvIGEgcGVyaW9kLiAgTm93IHRoZSB1bmRlcnNjb3JlIGlzIGEgd2lsZGNh cmQKdGhhdCBjb3JyZXNwb25kcyB0byB0aGUgcGVyaW9kIGluIHJlZ3VsYXIgZXhwcmVzc2lvbnMs IGJ1dCBjaGFyYWN0ZXJzCmluIHNxdWFyZSBicmFja2V0cyBzaG91bGQgbG9zZSB0aGVpciBzcGVj aWFsIG1lYW5pbmcuICBUaGUgY29kZSBpbgp1dGlscy9hZHQvcmVnZXhwLmMgZG9lc24ndCBleHBl Y3QgdGhhdCBzcXVhcmUgYnJhY2tldHMgY2FuIGJlIG5lc3RlZC4KClRoZSBhdHRhY2hlZCBwYXRj aCBmaXhlcyB0aGUgYnVnLgoKWW91cnMsCkxhdXJlbnogQWxiZQo= --=-oS/C8xXo98OpHd6w2vNl Content-Disposition: attachment; filename="v1-0001-Fix-SIMILAR-TO-regex-translation.patch" Content-Transfer-Encoding: base64 Content-Type: text/x-patch; name="v1-0001-Fix-SIMILAR-TO-regex-translation.patch"; charset="UTF-8" RnJvbSBkZjNmMGM3NmVlYzIzMTRhYjdhMjNlZjk5ZDRlMzkwZDI0NTZhMWNlIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5h dD4KRGF0ZTogVGh1LCAyMiBNYXkgMjAyNSAyMzowNTozMCArMDIwMApTdWJqZWN0OiBbUEFUQ0gg djFdIEZpeCBTSU1JTEFSIFRPIHJlZ2V4IHRyYW5zbGF0aW9uCgpUaGUgY29kZSB0aGF0IHRyYW5z bGF0ZXMgU0lNSUxBUiBUTyBwYXR0ZXJuIG1hdGNoaW5nIGV4cHJlc3Npb25zCnRvIHJlZ3VsYXIg ZXhwcmVzc2lvbnMgZGlkbid0IGNvbnNpZGVyIHRoYXQgYnJhY2tldHMgY2FuIGJlIG5lc3RlZCwK YXMgaW4gWy9fWzphbHBoYTpdQCVdLCBhbmQgcmVwbGFjZWQgcGxhY2Vob2xkZXJzIGxpa2UgXyBh bmQgJSB3aGVyZQppdCBzaG91bGRuJ3QuCi0tLQogc3JjL2JhY2tlbmQvdXRpbHMvYWR0L3JlZ2V4 cC5jICAgICAgICB8IDE5ICsrKysrKysrKysrKystLS0tLS0KIHNyYy90ZXN0L3JlZ3Jlc3MvZXhw ZWN0ZWQvc3RyaW5ncy5vdXQgfCAxMiArKysrKysrKysrKysKIHNyYy90ZXN0L3JlZ3Jlc3Mvc3Fs L3N0cmluZ3Muc3FsICAgICAgfCAgMyArKysKIDMgZmlsZXMgY2hhbmdlZCwgMjggaW5zZXJ0aW9u cygrKSwgNiBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9zcmMvYmFja2VuZC91dGlscy9hZHQv cmVnZXhwLmMgYi9zcmMvYmFja2VuZC91dGlscy9hZHQvcmVnZXhwLmMKaW5kZXggZWRlZTFmNzg4 MGIuLmEyM2M0Yzk1OWU0IDEwMDY0NAotLS0gYS9zcmMvYmFja2VuZC91dGlscy9hZHQvcmVnZXhw LmMKKysrIGIvc3JjL2JhY2tlbmQvdXRpbHMvYWR0L3JlZ2V4cC5jCkBAIC03NzMsNyArNzczLDgg QEAgc2ltaWxhcl9lc2NhcGVfaW50ZXJuYWwodGV4dCAqcGF0X3RleHQsIHRleHQgKmVzY190ZXh0 KQogCWludAkJCXBsZW4sCiAJCQkJZWxlbjsKIAlib29sCQlhZnRlcmVzY2FwZSA9IGZhbHNlOwot CWJvb2wJCWluY2hhcmNsYXNzID0gZmFsc2U7CisJaW50CQkJaW5jaGFyY2xhc3MgPSAwOworCWJv b2wJCWNoYXJjbGFzc19zdGFydCA9IGZhbHNlOwogCWludAkJCW5xdW90ZXMgPSAwOwogCiAJcCA9 IFZBUkRBVEFfQU5ZKHBhdF90ZXh0KTsKQEAgLTkwNCw3ICs5MDUsNyBAQCBzaW1pbGFyX2VzY2Fw ZV9pbnRlcm5hbCh0ZXh0ICpwYXRfdGV4dCwgdGV4dCAqZXNjX3RleHQpCiAJCS8qIGZhc3QgcGF0 aCAqLwogCQlpZiAoYWZ0ZXJlc2NhcGUpCiAJCXsKLQkJCWlmIChwY2hhciA9PSAnIicgJiYgIWlu Y2hhcmNsYXNzKQkvKiBlc2NhcGUtZG91YmxlLXF1b3RlPyAqLworCQkJaWYgKHBjaGFyID09ICci JyAmJiBpbmNoYXJjbGFzcyA8IDEpCS8qIGVzY2FwZS1kb3VibGUtcXVvdGU/ICovCiAJCQl7CiAJ CQkJLyogZW1pdCBhcHByb3ByaWF0ZSBwYXJ0IHNlcGFyYXRvciwgcGVyIG5vdGVzIGFib3ZlICov CiAJCQkJaWYgKG5xdW90ZXMgPT0gMCkKQEAgLTk1MywxOCArOTU0LDI0IEBAIHNpbWlsYXJfZXNj YXBlX2ludGVybmFsKHRleHQgKnBhdF90ZXh0LCB0ZXh0ICplc2NfdGV4dCkKIAkJCS8qIFNRTCBl c2NhcGUgY2hhcmFjdGVyOyBkbyBub3Qgc2VuZCB0byBvdXRwdXQgKi8KIAkJCWFmdGVyZXNjYXBl ID0gdHJ1ZTsKIAkJfQotCQllbHNlIGlmIChpbmNoYXJjbGFzcykKKwkJZWxzZSBpZiAoaW5jaGFy Y2xhc3MgPiAwKQogCQl7CiAJCQlpZiAocGNoYXIgPT0gJ1xcJykKIAkJCQkqcisrID0gJ1xcJzsK IAkJCSpyKysgPSBwY2hhcjsKLQkJCWlmIChwY2hhciA9PSAnXScpCi0JCQkJaW5jaGFyY2xhc3Mg PSBmYWxzZTsKKwkJCWlmIChwY2hhciA9PSAnWycpCisJCQkJaW5jaGFyY2xhc3MrKzsKKwkJCWVs c2UgaWYgKHBjaGFyID09ICddJyAmJiAhY2hhcmNsYXNzX3N0YXJ0KQorCQkJCWluY2hhcmNsYXNz LS07CisKKwkJCWlmIChwY2hhciAhPSAnXicgJiYgY2hhcmNsYXNzX3N0YXJ0KQorCQkJCWNoYXJj bGFzc19zdGFydCA9IGZhbHNlOwogCQl9CiAJCWVsc2UgaWYgKHBjaGFyID09ICdbJykKIAkJewog CQkJKnIrKyA9IHBjaGFyOwotCQkJaW5jaGFyY2xhc3MgPSB0cnVlOworCQkJaW5jaGFyY2xhc3Mr KzsKKwkJCWNoYXJjbGFzc19zdGFydCA9IHRydWU7CiAJCX0KIAkJZWxzZSBpZiAocGNoYXIgPT0g JyUnKQogCQl7CmRpZmYgLS1naXQgYS9zcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3N0cmluZ3Mu b3V0IGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zdHJpbmdzLm91dAppbmRleCAxNzRmMGE2 ODMzMS4uYWEwYmRkZDY4MmMgMTAwNjQ0Ci0tLSBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQv c3RyaW5ncy5vdXQKKysrIGIvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zdHJpbmdzLm91dApA QCAtNjE0LDYgKzYxNCwxOCBAQCBTRUxFQ1QgJ2FiY2RlZmcnIFNJTUlMQVIgVE8gJ19iY2QlJyBF U0NBUEUgTlVMTCBBUyBudWxsOwogU0VMRUNUICdhYmNkZWZnJyBTSU1JTEFSIFRPICdfYmNkIyUn IEVTQ0FQRSAnIyMnIEFTIGVycm9yOwogRVJST1I6ICBpbnZhbGlkIGVzY2FwZSBzdHJpbmcKIEhJ TlQ6ICBFc2NhcGUgc3RyaW5nIG11c3QgYmUgZW1wdHkgb3Igb25lIGNoYXJhY3Rlci4KKy0tICIu IiwgIl8iIGFuZCAiJSIgc2hvdWxkIGJlIGxlZnQgYWxvbmUgaW4gY2hhcmFjdGVyIGNsYXNzZXMK K0VYUExBSU4gKFZFUkJPU0UsIENPU1RTIE9GRikKK1NFTEVDVCAoU0VMRUNUICcnKSBTSU1JTEFS IFRPICcuX1suX1s6YWxudW06XS5fXSouX1tdLl9dLl9bXl0uJV0uJSc7CisgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgCistLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCisgUmVz dWx0CisgICBPdXRwdXQ6ICgoSW5pdFBsYW4gMSkuY29sMSB+ICdeKD86XC4uWy5fWzphbG51bTpd Ll9dKlwuLltdLl9dXC4uW15dLiVdXC4uKikkJzo6dGV4dCkKKyAgIEluaXRQbGFuIDEKKyAgICAg LT4gIFJlc3VsdAorICAgICAgICAgICBPdXRwdXQ6ICcnOjp0ZXh0CisoNSByb3dzKQorCiAtLSBU ZXN0IGJhY2tzbGFzaCBlc2NhcGVzIGluIHJlZ2V4cF9yZXBsYWNlJ3MgcmVwbGFjZW1lbnQgc3Ry aW5nCiBTRUxFQ1QgcmVnZXhwX3JlcGxhY2UoJzExMTIyMjMzMzMnLCBFJyhcXGR7M30pKFxcZHsz fSkoXFxkezR9KScsIEUnKFxcMSkgXFwyLVxcMycpOwogIHJlZ2V4cF9yZXBsYWNlIApkaWZmIC0t Z2l0IGEvc3JjL3Rlc3QvcmVncmVzcy9zcWwvc3RyaW5ncy5zcWwgYi9zcmMvdGVzdC9yZWdyZXNz L3NxbC9zdHJpbmdzLnNxbAppbmRleCBmN2IzMjViYWFkZi4uZWI3NDNkOWUzYWYgMTAwNjQ0Ci0t LSBhL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL3N0cmluZ3Muc3FsCisrKyBiL3NyYy90ZXN0L3JlZ3Jl c3Mvc3FsL3N0cmluZ3Muc3FsCkBAIC0xOTYsNiArMTk2LDkgQEAgU0VMRUNUICdhYmNkXGVmZycg U0lNSUxBUiBUTyAnX2JjZFwlJyBFU0NBUEUgJycgQVMgdHJ1ZTsKIC0tIHRoZXNlIGJlaGF2aW9y cyBhcmUgcGVyIHNwZWMsIHRob3VnaDoKIFNFTEVDVCAnYWJjZGVmZycgU0lNSUxBUiBUTyAnX2Jj ZCUnIEVTQ0FQRSBOVUxMIEFTIG51bGw7CiBTRUxFQ1QgJ2FiY2RlZmcnIFNJTUlMQVIgVE8gJ19i Y2QjJScgRVNDQVBFICcjIycgQVMgZXJyb3I7CistLSAiLiIsICJfIiBhbmQgIiUiIHNob3VsZCBi ZSBsZWZ0IGFsb25lIGluIGNoYXJhY3RlciBjbGFzc2VzCitFWFBMQUlOIChWRVJCT1NFLCBDT1NU UyBPRkYpCitTRUxFQ1QgKFNFTEVDVCAnJykgU0lNSUxBUiBUTyAnLl9bLl9bOmFsbnVtOl0uX10q Ll9bXS5fXS5fW15dLiVdLiUnOwogCiAtLSBUZXN0IGJhY2tzbGFzaCBlc2NhcGVzIGluIHJlZ2V4 cF9yZXBsYWNlJ3MgcmVwbGFjZW1lbnQgc3RyaW5nCiBTRUxFQ1QgcmVnZXhwX3JlcGxhY2UoJzEx MTIyMjMzMzMnLCBFJyhcXGR7M30pKFxcZHszfSkoXFxkezR9KScsIEUnKFxcMSkgXFwyLVxcMycp OwotLSAKMi40OS4wCgo= --=-oS/C8xXo98OpHd6w2vNl--