Filtering by label with an AND condition does not work as expected

[datenspast]

Describe the issue

I guess this is a bug and it worked in previous versions, but I`m not 100 % sure.

We have several strings which are tagged with several labels.
For example one source string is labled with "ABC" and "XYZ".

If I search for "label:ABC", the search works.
If I search for "label:XYZ", the search works.
If I search for "label:ABC OR label:XYZ", the search works as expected.
If I search for "label:ABC AND label:XYZ", no results are shown, although there are strings which have both labels.

On the other hand searching for something like "changed:>='7 days ago' AND changed:<='2 days ago'" works as expected.

Thanks for your help!

I already tried

• I've read and searched the documentation.
• I've searched for similar filed issues in this repository.

Steps to reproduce the behavior

1. Add two labels to one string.
2. Try to search for this with the query "label:ABC AND label:XYZ".

Expected behavior

I would expect to see all strings which match the condition, e.g. which have both labels.

Screenshots

No response

Exception traceback

How do you run Weblate?

Docker container

Weblate versions

[Weblate 5.15]

Weblate deploy checks

Additional context

No response

[nijel]

Confirmed, it wrongly translates to:

SELECT "trans_unit"."id", "trans_unit"."translation_id", "trans_unit"."id_hash", "trans_unit"."location", "trans_unit"."context", "trans_unit"."note", "trans_unit"."flags", "trans_unit"."source", "trans_unit"."previous_source", "trans_unit"."target", "trans_unit"."state", "trans_unit"."original_state", "trans_unit"."details", "trans_unit"."position", "trans_unit"."num_words", "trans_unit"."priority", "trans_unit"."timestamp", "trans_unit"."last_updated", "trans_unit"."extra_flags", "trans_unit"."explanation", "trans_unit"."variant_id", "trans_unit"."automatically_translated", "trans_unit"."source_unit_id" 
FROM "trans_unit" 
INNER JOIN "trans_unit" T2 ON ("trans_unit"."source_unit_id" = T2."id") 
INNER JOIN "trans_unit_labels" ON (T2."id" = "trans_unit_labels"."unit_id") 
INNER JOIN "trans_label" ON ("trans_unit_labels"."label_id" = "trans_label"."id")
WHERE (UPPER("trans_label"."name"::text) = UPPER(ABC) AND UPPER("trans_label"."name"::text) = UPPER(XYZ))

We need to explain Django ORM to use separate joins here. It probably worked before 51a654b because of a more complex query being used.

[github-actions]

Thank you for your report — the issue has now been resolved.

The fix has been merged into the repository and will be included in the upcoming Weblate 5.16 release.

• If you encounter any issues with the fix, please comment in this thread.
• If you experience a similar but separate issue, open a new report so we can track it properly.
• If you find Weblate helpful, consider supporting its development.

[nijel]

Reopening based on #17767 (comment), we need to add a similar fix for screenshots and checks.