Thank you very much, Thomas! Am Montag, 22. September 2014 20:40:22 UTC+2 schrieb Thomas Mueller: > > Hi, > > You are right, this is a bug. I will try to fix it. > > Regards, > Thomas > > On Monday, September 22, 2014, Lukas Eder <[email protected] > <javascript:>> wrote: > >> Hello folks, >> >> I've just analysed this jOOQ support request on Stack Overflow here and >> suspect that it is really a bug in H2: >> http://stackoverflow.com/q/25975401/521799 >> >> This query works in H2: >> >> select 1 abc, count(*) from dual group by abc order by abc asc >> >> >> So does this one: >> >> select 1 "ABC", count(*) from dual group by "ABC" order by "ABC" asc >> >> >> but this one doesn't: >> >> select 1 "abc", count(*) from dual group by "abc" order by "abc" asc >> >> >> I'm getting this exception: >> >> org.jooq.exception.DataAccessException: SQL [select 1 "abc", count(*) >> from dual group by "abc" order by "abc" asc]; Feld "abc" nicht gefunden >> Column "abc" not found; SQL statement: >> select 1 "abc", count(*) from dual group by "abc" order by "abc" asc >> [42122-177] >> >> >> I suspect that quotes are not properly evaluated in GROUP BY clauses, at >> least when they surround an alias declared in the SELECT clause. >> >> Cheers, >> Lukas >> >> -- >> 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 post to this group, send email to [email protected]. >> Visit this group at http://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> >
-- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
