home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
15.0.xC1.2 FixList
14.10.xC13.3 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

Informix - Problembeschreibung

Problem IT02608 Status: Geschlossen

SOME SELECTS REPORT AN ERROR 294 (NEED A GROUP BY) BUT THE QUERY ASSERT
FAILS IF GROUP BY IS ADDED

Produkt:
IBM IDS EXPRESS / 5724L2305 / C10 - IDS 12.10
Problembeschreibung:
The following query used to work in 11.50, 11.70 and in 
12.10.FC2, but fails in 12.10.FC3. 
 
SELECT A.tabid, (SELECT SUM(B.collength * A.rowsize) FROM 
syscolumns B WHERE B.tabid = A.tabid) 
FROM systables A 
WHERE A.tabid = 1; 
  294: The column (tabid) must be in the GROUP BY list. 
 
with the GROUP BY 
SELECT A.tabid, (SELECT SUM(B.collength * A.rowsize) FROM 
syscolumns B WHERE B.tabid = A.tabid) 
FROM systables A 
WHERE A.tabid = 1 GROUP BY 1; 
 
the AF has the following stack: 
(oninit) afstack 
(oninit) mt_ex_throw_sig 
(oninit) afsig_handler 
(Linux) <signal frame> 
(oninit) rdatavalSmint 
(oninit) ev_column 
(oninit) new_eval 
(oninit) next_row 
(oninit) get_first_row_from_producer 
(oninit) ordered_group_by_next 
(oninit) getrow 
(oninit) fetchrow 
(oninit) exfetch 
(oninit) sql_nfetch 
(oninit) sq_nfetch 
(oninit) sqmain 
(oninit) spawn_thread 
(oninit) th_init_initgls 
(oninit) startup
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* users using correlated agrregates in subqueries              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 12.10.xC5 or 12.10.xC4W1                          * 
****************************************************************
Local-Fix:
If the order of the columns in the SUM() function is changed, 
the query completes correctly. 
SELECT A.tabid, (SELECT SUM(A.rowsize * B.collength) FROM 
syscolumns B WHERE B.tabid = A.tabid) 
FROM systables A 
WHERE A.tabid = 1;
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
17.06.2014
16.10.2015
16.10.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.xC4W1,
12.10.xC5
Problem behoben lt. FixList in der Version
12.10.xC4.W1 FixList
12.10.xC5 FixList
12.10.xC5.W1 FixList