[ASTERIXDB-2170][SQL] Fix resolution order of implicit field access - user model changes: yes - storage format changes: no - interface changes: no
Details: - Improved name resolution rules - Resolve field access to the nearest variable in scope instead of raising compile-time error - Do not rely on type information when resolving names - Cleanup group variable handling in GroupBy clause, no longer use ‘with’ map for it - Fix ByNameToByIndexFieldAccessRule to use type environment of its input operator when analyzing its expression - Fix ExternalGroupByPOperator to use input schema of its aggregate function when generating runtime for that function - Fix invalid free variable computation for GroupBy clause
[ASTERIXDB-1753][SQL] Disable auto-plural for group-by. - user model changes: do not perform auto-scalar-to-plural transition for variables that are defined prior to a group-by group clause after the group-by clause. - storage format changes: no - interface changes: no
details: - migrated existing test queries that use auto-plural; - added a negative test query.