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
OSP-DB-OTHER-INCORROUT INCORRECT RESULTS MAY RESULT WITH OFFSET
Error Description
Incorrect output may result with OFFSET in a SQL statement.
Problem Summary
Please see the ERROR DESCRIPTION section.
Problem Conclusion
A plan specific incorrect output, which occurred when the
optimizer chose a plan node directly below the LIMIT/OFFSET
node as a (re)populated QDS sorted list. There was a need for
the optimizer to indicate to the runtime engine to reset
positioning in this case when repopulating the QDS and that
attribute was not set accordingly. This oversight has been
fixed.
Temporary Fix
Comments
Circumvention
PTFs Available
R720 MF66702 0114
R730 MF66658 0128
R740 MF66701 0121
Affected Modules
Affected Publications
Summary Information
Status............................................ | CLOSED PER |
HIPER........................................... | No |
Component.................................. | 9400DG3DB |
Failing Module.......................... | RCHMGR |
Reported Release................... | R730 |
Duplicate Of.............................. |
IBM 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, 2019, 2020 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:
15 May 2020