org.h2.jdbc.JdbcSQLException: Column "VALUE" must be in the GROUP BY list; SQL statement: select case when value >= ? then ? else 'Other' end, count(1) from my_data group by case when value >= ? then ? else 'Other' end [90016-192]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Check if you're not creating unused SQL entities, as it might cause this exception.

Solutions on the web

via GitHub by thomasmueller
, 1 year ago
Column "VALUE" must be in the GROUP BY list; SQL statement: select case when value >= ? then ? else 'Other' end, count(1) from my_data group by case when value >= ? then ? else 'Other' end [90016-192]
via GitHub by velo
, 1 year ago
Column "VALUE" must be in the GROUP BY list; SQL statement: select case when value >= ? then ? else 'Other' end, count(1) from my_data group by case when value >= ? then ? else 'Other' end [90016-192]
via Google Groups by Victor Shcherb, 2 months ago
Column "N.ID" must be in the GROUP BY list; > SQL statement: > select count(*) from node n inner join tags t on n.id = t.id and t.type = > 0 order by n.id [90016-158]
via Stack Overflow by gabriel angelos
, 2 years ago
Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-169]
via GitHub by marcellodesales
, 2 years ago
Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-176]
via GitHub by marcellodesales
, 2 years ago
Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s); use the server mode [90020-176]
org.h2.jdbc.JdbcSQLException: Column "VALUE" must be in the GROUP BY list; SQL statement: select case when value >= ? then ? else 'Other' end, count(1) from my_data group by case when value >= ? then ? else 'Other' end [90016-192]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
at org.h2.message.DbException.get(DbException.java:179)
at org.h2.message.DbException.get(DbException.java:155)
at org.h2.expression.ExpressionColumn.updateAggregate(ExpressionColumn.java:169)
at org.h2.expression.Comparison.updateAggregate(Comparison.java:461)
at org.h2.expression.Function.updateAggregate(Function.java:2607)
at org.h2.command.dml.Select.queryGroup(Select.java:364)
at org.h2.command.dml.Select.queryWithoutCache(Select.java:649)
at org.h2.command.dml.Query.query(Query.java:341)
at org.h2.command.dml.Query.query(Query.java:309)
at org.h2.command.dml.Query.query(Query.java:36)
at org.h2.command.CommandContainer.query(CommandContainer.java:110)
at org.h2.command.Command.executeQuery(Command.java:201)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:110)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 2 years ago
Once, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago
151 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.