diff options
| author |  Alexandre Alapetite <alexandre@alapetite.fr>
| 2025-10-22 21:21:17 +0200 |
|---|---|---|
| committer |  GitHub <noreply@github.com>
| 2025-10-22 21:21:17 +0200 |
| commit | 1282d3a2709064cb847b8757409a7153449faa9d (patch) | |
| tree | 862c46df5306b2254ff299c3ef9952623e38caa7 /tests | |
| parent | 6edb658dfb1586b9a290e2d8a5ce2f31d9bbb85d (diff) | |
PostgreSQL: compatibility with PCRE word boundary (#8141)
Allow the use of regex `\b` for word boundary (and `\B` for the opposite) even when using PostgreSQL.
Follow up of:
* https://github.com/FreshRSS/FreshRSS/pull/6706
For instance, `intitle:/\bnew\B/` will find *newest* but not *new* nor *renewal*.
Useful in particular to minimise the differences between PHP and database in:
* https://github.com/FreshRSS/FreshRSS/pull/7959
Diffstat (limited to 'tests')
| -rw-r--r-- | tests/app/Models/SearchTest.php | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/tests/app/Models/SearchTest.php b/tests/app/Models/SearchTest.php index 90aca6a24..b7cb43f8f 100644 --- a/tests/app/Models/SearchTest.php +++ b/tests/app/Models/SearchTest.php @@ -752,6 +752,11 @@ final class SearchTest extends \PHPUnit\Framework\TestCase { ['^ab\\M'] ], [ + 'intitle:/\\b\\d+/', + '(e.title ~ ? )', + ['\\y\\d+'] + ], + [ 'author:/^ab$/', "(REPLACE(e.author, ';', '\n') ~ ? )", ['^ab$'] @@ -820,6 +825,11 @@ final class SearchTest extends \PHPUnit\Framework\TestCase { ['(?-i)(?m)^ab$'] ], [ + 'intitle:/\\b\\d+/', + "(e.title REGEXP ? )", + ['(?-i)\\b\\d+'] + ], + [ 'intext:/^ab$/m', '(UNCOMPRESS(e.content_bin) REGEXP ?) )', ['(?-i)(?m)^ab$'] |