Surprising filtering result in collection

[wadouk]

Describe the bug

I make the following filtering on keywords :
"noiretblanc" OR "book*" AND "saal|2"

the result should include only images with tags saal|2 and noiretblanc or book like it's an AND

Steps to reproduce

Filter collections by keyword with a combinatorics that include an OR or a NOT, you will see that the AND condition is not applied.

Expected behavior

keep images that match the AND condition, drop others images that doesn't match

Logfile | Screenshot | Screencast

Have'nt succeed to find the correct sql query : all I found are count queries
Tried with -d lighttable -d sql

Commit

No response

Where did you obtain darktable from?

downloaded from www.darktable.org

darktable version

4.8.1

What OS are you using?

Windows

What is the version of your OS?

Windows 10

Describe your system?

No response

Are you using OpenCL GPU in darktable?

None

If yes, what is the GPU card and driver?

No response

Please provide additional context if applicable. You can attach files too, but might need to rename to .txt or .zip

No response

[TurboGit]

the result should include...

And what is the result you see?

Maybe you are seeing all image with noiretblanc and images having book* AND saal|2, so the following non ambiguous query:

"noiretblanc" OR ( "book*" AND "saal|2" )

Is that it?

[wadouk]

hum. have'nt checked all result but year, seem so

so the order is relevant ? doesn't understand the logic behind. try to add other stuff to exclude and there are not excluded. maybe it's only a misunderstanding from me about how the filters are done .

[wadouk]

PS ; that's what my screenshot show : filter applied. i had expect noiretblanc picture to have saal|2 tag or book and it doesn't filter like it is shown in screenshot