Block list filter including [word] filters everything

[ghtesting2020]

Checklist

• I have used the search function for OPEN issues to see if someone else has already submitted the same bug report.
• I have also used the search function for CLOSED issues to see if the problem is already solved and just waiting to be released.
• I will describe the problem with as much detail as possible.
• If the bug only to occurs with a certain feed, I will include the URL of that feed.

App version

2.6.33

Where did you get the app from

F-Droid

Android version

15

Device model

No response

First occurred

No response

Steps to reproduce

1. create block list word like: [review]

Expected behaviour

only items with the matching word in this case "[review]" should be filtered like an item with the title
"[review] samsung galaxy" should be blocked. it does not seem to be because of the word review, you can put anything. Something do with the open and close square bracket breaks filter.

Current behaviour

everything gets filtered whether it has "[review]" in the title or not

Logs

No response

[spacecowboy]

Working as designed. The brackets are special. See https://www.sqlitetutorial.net/sqlite-glob/

feeder will add * to start and end as well

[ghtesting2020]

Working as designed. The brackets are special. See https://www.sqlitetutorial.net/sqlite-glob/

feeder will add * to start and end as well

Is there a workaround? Titles having square brackets are not that uncommon. I still am not understanding how for example
"[Review]" even if it had a * at begin and end would block the world "politics"? In sql.* just means anything/all BUT it would also include what comes after?
So [review] should not block "engine"?

[spacecowboy]

Because [review] means: any of the letters r-e-v-i-w. And politics has an i in it.
And engine contains an e and an i so would also be blocked.

To match literal brackets, my local AI friend suggested:

[[]review[]]