DB2 - Problembeschreibung
Problem IC69009 | Status: Geschlossen |
STATISTICAL AND REGRESSION AGGREGATE FUNCTIONS SHOULD RETURN DECFLOAT IN NUMBER COMPATIBILITY MODE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
In NUMBER compatibility mode, the following statistical and regression functions incorrectly return INTEGER, BIGINT or DOUBLE where they should return DECFLOAT. 'integer' below means SMALLINT, INTEGER or BIGINT: AVG( SMALLINT or INTEGER ) returns INTEGER AVG( BIGINT ) returns BIGINT CORRELATION ( either argument is integer ) returns DOUBLE COVARIANCE( either argument is integer ) returns DOUBLE STDDEV( integer ) returns DOUBLE VARIANCE( integer ) returns DOUBLE REGR_SLOPE( either argument is integer ) returns DOUBLE REGR_ICPT( either argument is integer ) returns DOUBLE REGR_INTERCEPT( either argument is integer ) returns DOUBLE REGR_R2( either argument is integer ) returns DOUBLE REGR_AVGX( ..., integer ) returns DOUBLE REGR_AVGY( integer, ... ) returns DOUBLE REGR_SXX( ..., integer ) returns DOUBLE REGR_SYY( integer, ... ) returns DOUBLE REGR_SXY( either argument is integer ) returns DOUBLE | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * NUMBER compatibility mode * **************************************************************** * PROBLEM DESCRIPTION: * * In NUMBER compatibility mode, the following statistical and * * * * regression functions incorrectly return INTEGER, BIGINT or * * * * DOUBLE where they should return DECFLOAT. 'integer' below * * means * * SMALLINT, INTEGER or BIGINT: * * * * * * * * AVG( SMALLINT or INTEGER ) returns INTEGER * * * * AVG( BIGINT ) returns BIGINT * * * * CORRELATION ( either argument is integer ) returns DOUBLE * * * * COVARIANCE( either argument is integer ) returns DOUBLE * * * * STDDEV( integer ) returns DOUBLE * * * * VARIANCE( integer ) returns DOUBLE * * * * REGR_SLOPE( either argument is integer ) returns DOUBLE * * * * REGR_ICPT( either argument is integer ) returns DOUBLE * * * * REGR_INTERCEPT( either argument is integer ) returns * * DOUBLE * * REGR_R2( either argument is integer ) returns DOUBLE * * * * REGR_AVGX( ..., integer ) returns DOUBLE * * * * REGR_AVGY( integer, ... ) returns DOUBLE * * * * REGR_SXX( ..., integer ) returns DOUBLE * * * * REGR_SYY( integer, ... ) returns DOUBLE * * * * REGR_SXY( either argument is integer ) returns DOUBLE * * * * Migration notes: * * * * Any application that depends on the wrong column type may * * have to be altered to support the new DECFLOAT return type. * * * * Any view created prior to installing this fix that has a * * result column that depends on one of the above functions * * will continue to return the wrong type until the view is * * regenerated or dropped and recreated. A view is regenerated * * when an underlying table is altered. * * * * Any materialized query table (MQT) created prior to * * installing this fix that has a result column that depends on * * one of the above functions will no longer be used for query * * optimization until the MQT is dropped and recreated. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.5.6 * **************************************************************** | |
Local-Fix: | |
Cast the function argument(s) to DECFLOAT. | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
Problem was first fixed in DB2 version 9.5 Fix Pack 6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC69031 IC69032 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 03.06.2010 22.06.2010 22.06.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.6, 9.5.FP6 | |
Problem behoben lt. FixList in der Version |