Gotcha. Thanks for a quick response. сб, 25 жовт. 2025 р., 03:43 користувач Evgenij Ryazanov <[email protected]> пише:
> 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 > <https://groups.google.com/d/msgid/h2-database/0d28962a-92bf-46b2-8485-04c10dbf2120n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CACxs%3DasFounwfSh2gcf9-A4E8e-Sg4q0-Ly_j%3Du63uidufLr4g%40mail.gmail.com.
