Hi! You can't use H2 to check whether your SQL is valid for other database system.
The SQL Standard has optional feature T301, “Functional dependencies”. H2 supports this feature (with minor limitations) and such support cannot be disabled. Database systems with this feature allow neither aggregated nor grouped columns as long as their values aren't distinct between all rows within every group. That means the same query will fail or not depending on actual data. It isn't related to your question, but if you use H2 in unit tests with Spring Boot, you also need to disable automatic configuration of testing databases, otherwise your custom JDBC URL with compatibility mode and other settings will be ignored. -- 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/0d28962a-92bf-46b2-8485-04c10dbf2120n%40googlegroups.com.
