Subscribe to this APAR
By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.
| APAR (Authorized Program Analysis Report) |
Abstract
LIC-DB-INCORROUT OLAP WITH ORDER BY OF LOB
Error Description
The following query returns the wrong data for the OLAP
function.
select rank() over(order by b.qq1000l), b.qq1000l from
plancache b
where b.qqrid=5005
and b.qqjfld in (select qqjfld from plancache
where qqrid = 1000 and qq1000 like
'%BVCUR05L%')
order by b.qq1000l ;
Problem Summary
The following query returns the wrong data for the OLAP
function.
select rank() over(order by b.qq1000l), b.qq1000l from
plancache b
where b.qqrid=5005
and b.qqjfld in (select qqjfld from plancache
where qqrid = 1000 and qq1000 like
'%BVCUR05L%')
order by b.qq1000l ;
Problem Conclusion
The query optimizer was incorrectly handling the LOB field when
it was specified in the ORDER BY of a RANK or DENSE_RANK OLAP
expression. The problem has been corrected.
Temporary Fix
Comments
Circumvention
PTFs Available
R710 MF64403 
1000
R720 MF62740 
7068
R730 MF62577 
7061
Affected Modules
Affected Publications
Summary Information
| Status............................................ | CLOSED PER |
| HIPER........................................... | No |
| Component.................................. | 9400DG3DB |
| Failing Module.......................... | RCHMGR |
| Reported Release................... | R730 |
| Duplicate Of.............................. |
System i Support
IBM disclaims all warranties, whether express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. By furnishing this document, IBM grants no licenses to any related patents or copyrights. Copyright © 1996,1997,1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017, 2018 IBM Corporation. Any trademarks and product or brand names referenced in this document are the property of their respective owners. Consult the Terms of use link for trademark information
Document Information
Modified date:
09 January 2018