DB2 - Problembeschreibung
Problem IT07992 | Status: Geschlossen |
SQL0901N WHEN A COLUMN MASK ON A NULLABLE COLUMN RETURNS A RESULT THAT IS ALWAYS NOT NULL | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
An SQL0901N error may be returned when a column mask is defined on a column which is nullable, and the column mask CASE expression always returns a non-null result. For example, assume null values can be assigned to column c1. The following mask is guaranteed to return a non-null result (the integer constant 0 or 1): create mask m1 on t1 for column c1 return case when c1 is not null then 1 else 0 end enable A query which contains the masked column in the final result table can fail with SQL0901N. The only known occurrence is in DPF environments, and is demonstrated in the scenario below. create table t1 (c1 varchar(10)) DB20000I The SQL command completed successfully. insert into t1 values null, 0, 1, 2 DB20000I The SQL command completed successfully. create mask m1 on t1 for column c1 return case when c1 is not null then 1 else 0 end enable DB20000I The SQL command completed successfully. alter table t1 activate column access control DB20000I The SQL command completed successfully. select c1 from t1 C1 ---------- SQL0901N The SQL statement or command failed because of a database system error. (Reason "probe 030 in sqlkt_pack_tuple(), msg=cold=NULLABLE zvalue=NONULLS col(".) SQLSTATE=58004 | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All DB2 for LUW users in a DPF environment * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 10.1 Fix Pack 5 * **************************************************************** | |
Local-Fix: | |
Lösung | |
First fixed in Version 10.1 Fix Pack 5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 27.03.2015 15.07.2015 15.07.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |