Hi,
The SQL statement
> SELECT COUNT(NAME) as C FROM TEST HAVING COUNT(NAME) = 1;
is valid, and all databases I tested with returned 0 rows. The problem
is that there is no GROUP BY, so the group is actually the complete
table ('test'), which has more than one name.
> ORDER BY CAT1.CAT2;
This is an invalid statement. H2 doesn't detect this, which is a bug,
but it's actually quite hard to fix... I will try but can't promise.
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
