Executing a query with a PARTITION BY clause is returning error
-392, and the error is repeatable.
For example, running a query of the following syntax:
select ...,
(select ... from ... where ...),
ROW_NUMBER() OVER(PARTITION BY xxx ORDER BY xxx) as y
from ...,
outer(),
outer(,
outer(),
outer ())
where ...
(select ... from ... where ...);
Can result in the following error:
392: System error - unexpected null pointer encountered. |
****************************************************************
* USERS AFFECTED: *
* Users of 12.10.xC1 through 12.10.xC7. *
****************************************************************
* PROBLEM DESCRIPTION: *
* A query may return -392 error under the following *
* conditions: *
* - query contains an OLAP function in its projection list *
* - query contains a correlated subquery in its projection *
* list *
* - the correlation variable of the correlated subquery *
* refers to a column in the main query that's also in the *
* projection list of the main query *
* - the referenced column in projection list has an alias *
* defined, e.g., col1 as alias_column *
****************************************************************
* RECOMMENDATION: *
* Update to IBM Informix Server 12.10.xC8 *
**************************************************************** |
