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 IT07804 Status: Geschlossen

SETTING IFX_FOLDVIEW TO 1 RETURNS WRONG RESULTS FOR SELECT COUNT(DISTINCT)

Produkt:
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10
Problembeschreibung:
With IFX_FOLDVIEW set to 1, wrong results are returned for a 
select count(distinct) statement.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Users of 12.10.xC1 through 12.10.xC5.                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A query involving a UNION ALL view may return incorrect      * 
* results under the following conditions:                      * 
*   - a simple UNION ALL view, with each arm of the view       * 
* having a single table, and no group by, aggregation          * 
*   - main query is selecting form the UNION ALL view, with no * 
* group by                                                     * 
*   - an aggregate with DISTINCT (e.g. count(distinct column)) * 
* in the main query                                            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to IBM Informix Server 12.10.xC6.                     * 
****************************************************************
Local-Fix:
Lösung
Problem Fixed In IBM Informix Server 12.10.xC6.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
19.03.2015
30.12.2015
30.12.2015
Problem behoben ab folgender Versionen (IBM BugInfos)
12.10.xC6
Problem behoben lt. FixList in der Version
12.10.xC5.W1 FixList
12.10.xC6 FixList