Hi there, We are using version of H2 db: h2-2.3.232 with mode: DB2. Here is our config file from Spring Boot Project:
driverClassName: org.h2.Driver password: <pwd_here> username: <usr_name_here> url: jdbc:h2:mem:testdb0;DB_CLOSE_DELAY=-1;MODE=DB2 As the result of such config, we were able to detect weird behaviour. When we are doing queries using Hibernate + Spring Data JPA where we are having columns in select which are neither added to group by nor wrapped by aggregation function with other columns which are wrapped by aggregation function - they are executed successfully, while on each modern SQL DB this should fail. e.g: SELECT COLUMN1, SUM(COLUMN2) FROM TABLE; this should fail as COLUMN1 is not neither aggregated nor in GROUP BY clause, however it passed successfully, however while running such query in real DB2, it fails as expected, what causes misleading test results. Could someone confirm that such issue exists for someone else? Thanks in advance, Volodymyr -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/h2-database/67d01f4f-f893-4555-8846-797b74a69217n%40googlegroups.com.
