Re: SQL-Error -294 in IDS 7.30

This is a bug. We have reported this bug (as well as others) to Informix. I believe it is fixed in IDS v7.3 UC5. This version was scheduled to be released around Thanksgiving. Steve Romankiw June Tong wrote: > 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...