DB2 - Problembeschreibung
Problem IT04367 | Status: Geschlossen |
AVOID TO DIVISION BY ZERO SQL0801N | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
The following example show the scenario: create table t1 ( c1 char(2) , c2 int , c3 int ) DB20000I The SQL command completed successfully. insert into t1 values('a',20,5) DB20000I The SQL command completed successfully. insert into t1 values('b',20,18) DB20000I The SQL command completed successfully. insert into t1 values('c',20,10) DB20000I The SQL command completed successfully. insert into t1 values('d',20,0) DB20000I The SQL command completed successfully. select c1,c2,c3,(c2/c3) as ratio from t1 where c3 > 0 and (c2/c3) > 3 c1 c2 c3 RATIO ---- ----------- ----------- ----------- a 20 5 4 SQL0801N Division by zero was attempted. SQLSTATE=22012 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All DB2 V10.5 users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V10.5 Fix Pack 5 or higher. * **************************************************************** | |
Local-Fix: | |
NA | |
Lösung | |
Fixed in DB2 V10.5 Fix Pack 5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 12.09.2014 29.04.2015 29.04.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.5 |