Views Filter group "Or" operator not working

Thanks #2 works for me as well (this is in the case of workbench)

Observed the same problem 10.0.9 with a Content based View using the following Filters
Is published AND ( content field OR taxonomy term)

and of those only the 'content field' has the Reduce duplicates option, and if i do set that then i start seeing items that were not included but am now seeing duplicates (as some content has both the filtered field and the filtered term). I already have it set to Distinct.

I wondered if getting rid of 'is published' might help, ie the filter is now a simple one level OR - but same problem, i either miss out on lots of results, or i get them but get them twice.

So for me the workaround in #2 does not suffice.

I have this issue as well. It should be noted that the issue can be seen in the UI as well. Even when using the workaround and having "Reduce duplicates" checked for the OR-able filters, the UI still shows "AND":

The workaround in #2 helped get the query working. However, the UI still shows an incorrect result.

This is completely counter intuitive.

Something like (A AND B) or (A AND C) adds a left join on A table with "! A", which obviously returns an empty set as you end with A AND !A.