Currently NOT cannot be used inside 'scripting contexts' (such as `HAVING`) or against native negateable operators. Clearly this needs to be fixed. Relates #34558 #34680
