Re:One Giant Leap for SQL: MySQL 8.0 Released
by cpburns2009 on Wednesday April 25, 2018 @12:46PM
(#16923384)
That part of the article doesn't make much sense. It sounds like MySQL finally enabled rational GROUP BYs instead of randomly choosing a row when the grouped rows aren't distinct. This is something at least PostgreSQL has done for ages.
[ Parent
| on HN ]
Re:One Giant Leap for SQL: MySQL 8.0 Released
by irishsultan on Wednesday April 25, 2018 @12:55PM
(#16923492)
Nope, the old mysql was extremely stupid, but the postgres behaviour wasn't that smart because it refused anything not in the group by clause (even when constraints on the table ensure that everything in your select clause can in fact be determined from the columns used to group).