ONLY_FULL_GROUP_BY wrong behaviour


When ONLY_FULL_GROUP_BY is set of course you are not allowed to to specify columns in select statement that are not in the group by. But there is an exception: when grouping by id which is a primary key (i.e. unique by definition) all other columns in the same table are functionally dependent upon it. That’s why the following query does not (should not) raise any error: SELECT id, title, genre FROM films GROUP BY id; This acts as expected in MySql, but in mariaDB raises the famous error nonaggregated incompatible with sql_mode=only_full_group_by. Why this happens? There is NOT any possibility to have 2 or more equal records in the same result set since id is a unique primary key. Is this a mariaDB bug or what?


Comments loading...