Yes, this is applicable to the latest version of the Drupal - i.e. 8.7
I am working on taxonomy term reference field "status" attached to a node, I have created a view and applied 2 filters on this field. Out of which one is Non - exposed and other is exposed.
The view works properly when I don't use the exposed filter but as soon as I use the exposed filter it works weirdly. check out the query below for more understanding.
LEFT JOIN {node__field_status} node__field_status2 ON node_field_data.nid = node__field_status2.entity_id AND INNER JOIN {node__field_status} node__field_status ON node_field_data.nid = node__field_status.entity_id AND node__field_status.deleted = '0'
LEFT JOIN {node__field_status} node__field_status2 ON node_field_data.nid = node__field_status2.entity_id AND node__field_status2.field_status_target_id != '5'
The first join is for the Non-exposed filter and the second join is for the exposed filter if you look at the condition of the second join it indicates node__field_status2.field_status_target_id != '5', which is exactly opposite of what i am trying to do.