Inconsistent behaviour in group by and order by

sebasv
New Contributor II

Consider this minimal example:

with t as (select explode(sequence(1,10,1)) as id)
select (id%2) as id from t
group by id
order by id

I would expect an ambiguous column name exception, since the grouping and sorting could apply to 2 different `id` columns. Instead the grouping is applied to t.id and the order is applied to (t.id%2).

Is there a setting we can apply to trigger an error when there is ambiguity? Can this be escalated?