fixes #7540 rework how we account for field present in SELECT when filtering (via HAVING); do not make fields required