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]

GitHub | velo | 5 months ago
  1. 0

    Unable to use prepared statement + case + group By

    GitHub | 5 months ago | velo
    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]
  2. 0

    GitHub comment 321#233844005

    GitHub | 5 months ago | thomasmueller
    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]
  3. 0

    H2 Oracle decode function

    Stack Overflow | 5 years ago | SvRekaa
    org.h2.jdbc.JdbcSQLException: Hexadecimal string with odd number of characters: "6.0"; SQL statement: select 6.0 - decode(1.0,2.0,3.0,4.0) from dual ; [90003-157]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Failover @Type for h2?

    Stack Overflow | 2 years ago | xenoterracide
    org.h2.jdbc.JdbcSQLException: Hexadecimal string contains non-hex character: "aced0005-7372-000e-74c2-aa3c957d4f00"; SQL statement: select character0_.task_id as task_id1_0_0_, character0_.name as name2_0_0_ from characters character0_ where character0_.task_id=? [90004-176]
  6. 0

    Strange error when using /p group create

    GitHub | 4 years ago | HaoSs07
    org.h2.jdbc.JdbcSQLException: Parameter "#1" is not set; SQ statement: SELECT groups.groupName, groups.priority, groups.prefix, groups.suffix, groups.parent FROM groupConnectors INNER JOIN groups ON groupConnectors.groupID=groups.groupID WHERE groupConnectors.playerID=? AND groupConnectors.zoneID=? [90012-170

  1. kjhdofjosvs 1 times, last 1 month ago
6 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. H2 Database Engine
    JdbcPreparedStatement.executeQuery
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)
    2. org.h2.message.DbException.get(DbException.java:179)
    3. org.h2.message.DbException.get(DbException.java:155)
    4. org.h2.expression.ExpressionColumn.updateAggregate(ExpressionColumn.java:169)
    5. org.h2.expression.Comparison.updateAggregate(Comparison.java:461)
    6. org.h2.expression.Function.updateAggregate(Function.java:2607)
    7. org.h2.command.dml.Select.queryGroup(Select.java:364)
    8. org.h2.command.dml.Select.queryWithoutCache(Select.java:649)
    9. org.h2.command.dml.Query.query(Query.java:341)
    10. org.h2.command.dml.Query.query(Query.java:309)
    11. org.h2.command.dml.Query.query(Query.java:36)
    12. org.h2.command.CommandContainer.query(CommandContainer.java:110)
    13. org.h2.command.Command.executeQuery(Command.java:201)
    14. org.h2.jdbc.JdbcPreparedStatement.executeQuery(JdbcPreparedStatement.java:110)
    14 frames