Hi, I will not implement it currently (no time) but will add it to the roadmap. I thought it's invalid SQL, but according to my test it's supported by at least PostgreSQL and SQLite. It's not supported by Apache Derby and HSQLDB according to my test.
I suggest to use the following syntax. It is supported by PostgreSQL, H2, HSQLDB, SQLite (and I guess MySQL, but didn't test). It's also not supported by Apache Derby (I wonder why): drop table test ; create table test(a int, b int); insert into test values(1, 1); insert into test values(1, 2); insert into test values(2, 1); select a x, sum(b) from test group by x; 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.
