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 | thomasmueller | 9 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    GitHub comment 321#233844005

    GitHub | 9 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]
  2. 0

    Unable to use prepared statement + case + group By

    GitHub | 9 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]
  3. 0

    H2 Oracle decode function

    Stack Overflow | 6 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

    Ebean/idIn Parameter not set

    Stack Overflow | 4 years ago | Janus Troelsen
    javax.persistence.PersistenceException: Query threw SQLException:Parameter "#1" is not set; SQL statement: select t0.virtuelle_adresse c0, t0.reale_adresse c1, t0.betr_nr c2, t0.bemerkung c3, t0.inbetriebnahme c4, t0.dekoder_typ_id c5, t0.model_tfz_typ_id c6, t0.eigentuemer_id c7 from tfz t0 where t0.virtuelle_adresse in (?) [90012-168] Bind values:[] Query was: select t0.virtuelle_adresse c0, t0.reale_adresse c1, t0.betr_nr c2, t0.bemerkung c3, t0.inbetriebnahme c4, t0.dekoder_typ_id c5, t0.model_tfz_typ_id c6, t0.eigentuemer_id c7 from tfz t0 where t0.virtuelle_adresse in (?)

  1. kjhdofjosvs 1 times, last 5 months 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