Hello.
Unfortunately, H2 detects such problems with GROUP BY only when more than
one distinct value for a column was selected. It's an old known limitation
that is not fixed yet.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe
Hi there
I think the group by clause is only enforced when more than one result is
returned. Surely this is a grammar issue, regardless of the data returned?
For this (malformed) query, the group by is missing, but still the query
runs returning one result:
*select state, count(state) from
