We ran into a strange case where TransformExpandOneOf doesn't appear to get applied properly.
Consider the following query:
Which produces the following algebra:
Note that the NOT IN was left in the expression form rather than being expanded to the equivalent != expressions.
If the first FILTER line is commented out then the following algebra is produced:
So it looks like there is something going on that somehow blocks TransformExpandOneOf from working when another filter is present in the outer query. Possibly this is something related to filter placement?
This problem occurs as far back as 2.11.1 and can be reproduced with 2.11.2, 2.12.0 and current trunk. It does not appear in 2.11.0 so must have been introduced in 2.11.1