|
Problem IT24301
|
Status: Closed |
QUERY COMPILATION RETURNS SQLCODE -901 "PULLDOWN ATTEMPTED ON A COLUMN WITH NO HXP"
|
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
Query compilation may fail with SQLCODE -901, reason "Pulldown
attempted on a column with no hxp". This can happen when the
query has the following characteristics:
- multiple scalar-fullselects with the same source table
- the ROWNUM pseudocolumn is referenced in a predicate
or FETCH FIRST n ROWS ONLY
For example:
SELECT
( SELECT T1.C1 FROM T1 ),
( SELECT T1.C2 FROM T1 )
FROM T2
where ROWNUM = 1
order by T2.C1;
SQL0901N The SQL statement or command failed because of a
database system
error. (Reason "Pulldown attempted on a column with no hxp".)
SQLSTATE=58004 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL DB2 LUW Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* Query compilation may fail with SQLCODE -901, reason *
* "Pulldown *
* attempted on a column with no hxp". This can happen when *
* the *
* query has the following characteristics: *
* *
* - multiple scalar-fullselects with the same source table *
* - the ROWNUM pseudocolumn is referenced in a predicate *
* *
* For example: *
* *
* SELECT *
* ( SELECT T1.C1 FROM T1 ), *
* ( SELECT T1.C2 FROM T1 ) *
* FROM T2 *
* where ROWNUM = 1 *
* order by T2.C1; *
* *
* SQL0901N The SQL statement or command failed because of a *
* database system *
* error. (Reason "Pulldown attempted on a column with no *
* hxp".) *
* SQLSTATE=58004 *
****************************************************************
* RECOMMENDATION: *
* Will be fixed in future fixpacks *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
Replace the ROWNUM predicate with an equivalent
fetch-first-clause, e.g.:
SELECT
( SELECT T1.C1 FROM T1 ),
( SELECT T1.C2 FROM T1 )
FROM T2
order by T2.C1
FETCH FIRST 1 ROW ONLY; |
| BUG-Tracking |
forerunner :
follow-up : IT30741 IT30742 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.03.2018
17.12.2019
22.04.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
