Re: SQL-Error -294 in IDS 7.30

Peter Kolmhofer wrote: > <big snip> > select makurzz, zeit_char(zeit) from test; -- works fine > select makurzz, zeit_char(sum(zeit)) from test;> returns 1): Peter 01:15 (on 7.23) > returns 2): sqlcode -294: The column ((expression)) must be in the > GROUP BY list. > > Of course there is no way to put (expression) into the GROUP BY. > And, as stated abouve: it works fine on version < 7.30. > > Is this a bug? I think it's a bug if it says "(expression)" must be in the group by list. Actually I think makurzz should be in the group by list. I don't see how 7.23 could possibly have worked without a group by clause. I have IDS-PE (7.22.TB5) and I just ran your test, and got what I expected: "The column (makurzz) must be in the GROUP BY list." Your 7.23 must be flaky. Anyway, it doesn't apply in this case, but you can put expressions in your group by list by using the column number: GROUP BY 1,2 June -- june_t@hotmail.com Grounded in Palo Alto, living on those tube-shaped cookies, whatever they're called...