If that’s the very specific case, then they should be clear about it. But my int... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		jbverschoor on April 14, 2023 \| parent \| context \| favorite \| on: SQL:2023 is finished: Here is what's new If that’s the very specific case, then they should be clear about it. But my interpretation was that our order by ungrouped column If it’s about preferring by non selected columns, that’d be fine. Something is wrong somewhere imo

amluto on April 14, 2023 [–]

I assume that query optimizers are able to detect a GROUP BY of a primary key and other columns in the same table and optimize accordingly. But using this trick to change the set of valid queries seems odd. I think I'd rather see special syntax for it:

    GROUP BY table.*

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact