4 ms·
Use of that group by behavior is a bug, nearly every time I've seen it. (Though usually I'm seeing it in MySQL.) Columns that are not part of the group, an agg
by deathanatos 4y ago
Use of that group by behavior is a bug, nearly every time I've seen it. (Though usually I'm seeing it in MySQL.)
Columns that are not part of the group, an aggregate of the group, or a functional dependency of the group aren't stable — there are multiple rows that could supply the value, and they needn't have the same value.
- kwoff 4y agoYeah, I've seen that bug in a monitoring graph that was showing data for say every 5 minutes but the (MySQL) database table had data per minute; so you'd see a spike in the graph, but refresh a minute later and voila no spike anymore.