Using "row_number" or "rownum" in views or derived tables had unexpected results if the outer query contained constraints for the given view.