Hello. There is an optional feature T301, “Functional dependencies” in the SQL Standard. H2 and some other DBMS support this feature.
Only DBMS without its support may throw an exception immediately. In DBMS with its support select expressions and where cause may reference non-aggregated columns when each such column is functionally dependent on grouping columns (has the same value for each row in the group). In these DBMS, including the H2, validity of your query depends on the data in the table. This feature can't be disabled. -- 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 on the web visit https://groups.google.com/d/msgid/h2-database/4beb93c5-28d2-461a-babc-7795c4d1d558o%40googlegroups.com.
