Thank you Thomas
On Aug 20, 9:48 pm, Thomas Mueller <[email protected]> wrote: > 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.
