Kbase P129785: SQL-92: "Describe Column All" function returns wrong column NULLABILITY
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/06/2008 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1B
SYMPTOM(s):
SQL-92: "Describe Column All" function returns wrong column NULLABILITY
The ODBC API "Describe Column All" function fails to correctly return the NULLABILITY attribute of some result set columns.
Executing the ODBC "Describe Column All" function against the following SELECT statement returns SQL_NO_NULLS=0 when it should have returned SQL_NO_NULLS=1. That is it fails to identify C3 as NULLABLE:
CREATE TABLE PUB.L (C1 INT NOT NULL)
CREATE TABLE PUB.R (C1 INT NOT NULL, C2 INT, C3 INT NOT NULL)
SELECT L.C1, R.C2, R.C3 FROM PUB.L LEFT OUTER JOIN PUB.R ON L.C1 = R.C1
CAUSE:
Bug# OE00166071
FIX:
Upgrade to OpenEdge 10.1C01 or later