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]> 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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[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.
