Hi Thomas, Yeah, it works on MySQL and it fails on our H2 unit testing database. Looking at the query now, I don't know how it would ever have worked! I'm going to have to do something like "SELECT date, sum(t) FROM ex_data GROUP BY date"
Thanks for responding. ct On Friday, November 2, 2012 3:54:41 PM UTC, Thomas Mueller wrote: > > Hi, > > This is normal for a relational database, your test case will not work > with most databases (PostgreSQL for example, and most others). It might > work with MySQL because this database is a bit weird in this respect. For > example the following test case will give a similar error message for most > databases: > > drop table if exists test; > create table test(id int, name varchar(255)); > insert into test values(1, 'hello'); > insert into test values(1, 'world'); > select * from test group by id; > > Regards, > Thomas > >> >>> -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/0rWJZCzUJuwJ. 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.
