Re: SQL-Error -294 in IDS 7.30

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? Hi again, of course, in my weird SQL makurzz should have been in the GROUP BY; however, if it is, -294 still occurs in 7.30.TC5, which is known as bug #92478 (fixed in 7.30.TC6 as Informix-Hotline told me). Thanks, Peter > > 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... -- _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ _/_/ Mag. Peter Kolmhofer __ _ _____ _/ _/_/ Informix & DB2 DBA __ --/_|___\\______ _/ _/_/ Porsche Informatik (Austria) _ _ ( _ _ \\) _/ _/_/ A-5101 Bergheim, Handelszentrum 7 -(_)-------(_)- _/ _/_/ +43 662 4670-6258 fax: -6501 email:kop@porsche.co.at _/ _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/