PTF Cover Letter
PTF ( Program Temporary Fixes ) Cover letter
LIC-DB-INCORROUT AN SQL SELECT USING WHERE XXX = '' RETURNS
Pre/Co-Requisite PTF / Fix List
REQ LICENSED PTF/FIX LEVEL
TYPE PROGRAM RELEASE NUMBER MIN/MAX OPTION
---- -------- --------- ------- ------- ------
PRE 5770999 V7R3M0 MF64485 00/00 0000
PRE 5770999 V7R3M0 MF62600 00/00 0000
CO 5770999 V7R3M0 MF66536 00/00 0000
CO 5770999 V7R3M0 MF66441 00/00 0000
CO 5770999 V7R3M0 MF66442 00/00 0000
CO 5770999 V7R3M0 MF65717 00/00 0000
CO 5770999 V7R3M0 MF65670 00/00 0000
CO 5770999 V7R3M0 MF65488 00/00 0000
CO 5770999 V7R3M0 MF65370 00/00 0000
CO 5770999 V7R3M0 MF65270 00/00 0000
CO 5770999 V7R3M0 MF65143 00/00 0000
CO 5770999 V7R3M0 MF63758 00/00 0000
CO 5770999 V7R3M0 MF63468 00/00 0000
CO 5770999 V7R3M0 MF61339 00/00 0000
DIST 5770SS1 V7R3M0 SI59580 00/00 0000
NOTICE:
-------
Application of this PTF may disable or render ineffective programs that
use system memory addresses not generated by the IBM translator,
including programs that circumvent control technology designed to limit
interactive capacity to purchased levels. This PTF may be a prerequisite
for future PTFs. By applying this PTF you authorize and agree to the
foregoing.
This PTF is subject to the terms of the 'IBM License Agreement for Machine
Code', the terms of which were provided in a printed document that was
delivered with the machine.
SUBJECT TO ANY WARRANTIES WHICH CAN NOT BE EXCLUDED OR EXCEPT AS EXPLICITLY
AGREED TO IN THE APPLICABLE LICENSE AGREEMENT OR AN APPLICABLE SUPPORT
AGREEMENT, IBM MAKES NO WARRANTIES OR CONDITIONS EITHER EXPRESS OR IMPLIED,
INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OR CONDITIONS OF
MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND NON INFRINGEMENT,
REGARDING THE PTF.
APAR Error Description / Circumvention
-----------------------------------------------
An SQL Select using a CHAR(0) field (WHERE xxx = '') in a WHERE
clause returns an incorrect result whereas using the complete
field length (WHERE xxx = ' ' returns the correct result.
CORRECTION FOR APAR MA47900 :
-----------------------------
The query was implemented using an Index Scan plan with an index
that had a sort sequence table applied to it. The single byte
blank was weighted to a different weight and that weighting was
not applied correctly when padding the empty string to the
length of the column. This problem could appear unpredictable
depending on the implementation and the order in which the
optimizer initially processed available indexes containing
Select/Omit criteria. The problem has been corrected.
CIRCUMVENTION FOR APAR MA47900 :
--------------------------------
None.
Activation Instructions
None.
Special Instructions
None.
Default Instructions
THIS PTF CAN BE APPLIED IMMEDIATE OR DELAYED.
Supersedes
PTF/FIX NO(S). APAR TITLE LINE
-------------- ------------------------------------------------------------
MF66535 OSP-UNPRED PLAN CACHE GATING
MF66445 OSP-PERFM OPNQRYF PERFORMANCE PROBLEM WHEN USING PHYSICAL FI
MF66440 OSP-DB-OTHER-MSGSQL0901 AFTER PTFS INSTALLED, JOB STARTED TO
MF66417 OSP-DB-OTHER-INCORROUT SELECT STMT WITH FIELDPROC RETURNS IN
MF66370 OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 MSGMCH3203 F
MF66295 OSP-DB-OTHER-F/DBOPEXPRPREDMISC-RCX/5094-MSGMCH3203 QUERY/40
MF66175 OSP-UNPRED NAVIGATOR FOR I MTIS DELETED COUNT IS INCORRECT
MF66023 LIC-DB-OTHER-INCORROUT Possible data corruption with MIN/MAX
MF65716 OSP-DB-OTHER-PERFM PERFORMANCE IMPROVEMENT TO QDS IO COSTING
MF65671 OSP-DB-OTHER-F/DBPMTRAP-T/QDBGETMQO-MSGMCH3203 MSGMCH3203 F/
MF65602 OSP-INCORROUT GETTING NULL BACK FROM THE COALESCE/REGEXP_REP
MF65547 OSP-DB-OTHER-F/DBOPACCESSPLANINDEXRANDOMIOX/5108-MSGMCH3601
MF65521 SQL-RUN COMPLEX SQL QUERY FAILS INTERMITTENTLY
MF65515 LIC-DB-OTHER Internal maintenance
MF65487 LIC-DB-INCORROUT Recursive Query
MF65441 OSP-MSGCPF4204 INTERNAL QUERY FAILURE RELATED TO LOOK-AHEAD
MF65434 OSP-DB-OTHER-F/DBPMHASH-T/QDBGETMQO-MSGMCH3402 DRDA APPLICAT
MF65421 OSP-OTHER-PERFM QUERY IS BEING RE-OPTIMIZED UNNECESSARILY
MF65409 LIC-DB-OTHER change to Visual Explain for Workload Group
MF65369 LIC-DB-OTHER Internal Database Maintenance.
MF65352 OSP-DB-OTHER THE SYSTEM IS CREATING DUPLICATE MTI'S (TEMPORA
MF65299 LIC-DB-OTHER-F/DBOPEXPRVALMISC-T/QQQOOODBOP-MSGMCH3203 RCAC
MF65298 Corrects LIMIT/OFFSET precedence for prepared attributes.
MF65266 LIC-DB-OTHER-PERFM SQL OPTIMIZATION TIME PERFORMANCE ISSUE W
MF65223 DATAPARTITIONNUM update lock fence and constant fixes.
MF65225 OSP-LOOP OPNQRYF WITH MANY WITH MANY LOGICAL XORS (&&) CAN R
MF65216 LIC-DB-OTHER-PERFM COMPLEX CONNECT BY QUERY RUNS POORLY AFTE
MF65202 OSP-DB-OTHER-PERFM GATE CONTENTION ON HEAP ALLOCATIONS DURIN
MF65183 OSP-DB-OTHER-PERFM INTERMITTENT POOR QUERY PLANS FOR INSERT
MF65144 LIC-DB-OTHER Allow duplicate keys in JSON_OBJECT and JSON_OB
MF65089 LIC-DB-MSGMCH3203 Affinity Error on complex query
MF65071 OSP-DB-OTHER-INCORROUT UDTF - 'NO EXTERNAL ACTION'
MF65041 OSP-PAR-940XMISC PLANS THAT MAY BE IN USE FROM JOBS IN ONE P
MF65024 LIC-DB-PERFM Poor query performance due to plan choice
MF64970 OSP-DB-OTHER-F/DBPMTRAP-T/QDBGETM-RC1720-MSGMCH3203 MSGMCH32
MF64958 OSP-DB-OTHER-INCORROUT A RPG CHAIN MAY NOT FIND CORRECT VALU
MF64926 LIC-DB-OTHER-PERF COMPLEX OLAP QUERY CONSUMES EXCESSIVE SEGM
MF64895 OSP-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203 A MSGMCH
MF64877 LIC-DB-OTHER-INCORROUT UDTF - 'NO EXTERNAL ACTION' with LOB
MF64846 OSP-OTHER-PERFM QUERY OPTIMIZATION TIME
MF64812 LIC-DB-OTHER-F/HMDERIVEDHEAP-T/QQQOOODBOP-RCX/5094-MSGMCH320
MF64766 LIC-DB-OTHER Internal Maintenance
MF64740 PERFM-HLIC-94XXBASE NON OPTIMAL JOIN ORDER SELECTED DUE TO I
MF64721 LIC-DB-OTHER-PERFM CACHED STRATEGIES WITH QDSPOPULATES USED
MF64666 OSP-DB-OTHER-F/DBPMTRAP-T/QDBGETMQO-MSGMCH3203 RUNNING AN SQ
MF64588 LIC-DB-OTHER-PERFM QUERY PERFORMANCE WITH PARTITIONED TABLE
MF64543 LIC-DB-OTHER-PERF POOR PERFORMING SQL USING SMP
MF64532 LIC-DB-OTHER Internal Database Maintenance.
MF64526 LIC-DB-OTHER-PERFM SYNCHRONIZE MTI ACCESS IN AN TRACING OR E
MF64511 OSP-OTHER-PERFM QUERY PERFORMS POORLY WHEN SKEWED DATA IS PR
MF64511 OSP-OTHER-PERFM QUERY PERFORMS POORLY WHEN SKEWED DATA IS PR
MF64406 OSP-DB-OTHER-F/QSQRUN3X/32832-T/SAME-MSGSQ20478 UPDATE ON A
MF64405 OSP-F/DBPMTRAP-T/QQQOOODBOP-RC1720-MSGMCH3203 MCH3203 F/DBPM
MF64405 OSP-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203 SQL0901
MF63435 LIC-DB-OTHER-PERFM Optimization time improvements for comple
MF64348 LIC-DB-MSGMCH3203 F/T DbpmTrap/QDBGETM vlog
MF64343 LIC-DB-OTHER Query with grouping sets and table function fai
MF64292 LIC-DB-F/QQQOOODBOP-MSGCPF427F-MOD/QQQOOOINV CPF427F, SQL066
MF64282 OSP-DB-OTHER-SAP400-THREADS-INCORROUT SELECT STMT WITH '=' ,
MF64243 F/OPTIMIZER-UDFINCORROUTAFTERCLEARINGPLANCACHE UDF INCORRECT
MF64226 OSP-OTHER PERFORMANCE OF A USER DEFINED FUNCTION (UDF)
MF64141 LIC-DB-OTHER Internal Database Maintenance.
MF64067 LIC-DB-OTHER Internal Database Maintenance.
MF64013 LIC-DB Internal Maintenance
MF64008 LIC-DB-OTHER Internal Database Maintenance.
MF62513 OSP-DB-OTHER-T/QQQOOODBOPX/4720-MSGMCH3203 A LEFT OUTER JOIN
MF62513 OSP-DB-OTHER-T/QQQOOODBOPX/4720-MSGMCH3203 A LEFT OUTER JOIN
MF63978 LIC-DB-OTHER Potential incorrect output with EVI only access
MF63976 LIC-DB-INCORROUT MTI with LOB column
MF63944 LIC-DB-PERFM reorder predicates based on selectivity
MF63944 LIC-DB-PERFM reduce data copies for SQL query
MF62773 LIC-DB Query fails over table with an EVI with INCLUDE and w
MF63899 LIC-DB Internal Maintenance
MF63844 LIC-DB_OTHER Support displaying more than 1TB in Visual Expl
MF63837 OSP-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203 UNION
MF63761 LIC-DB-PERFM Database Monitor 3010 record
MF63746 OSP-DB-OTHER-F/DBPMTRAP-MSGMCH3203 QRYDFN FAILS W/ MCH3203 F
MF63713 OSP-UNPRED QUERY ESTIMATED RUNTIME WITH XMLELEMENT FIELD SEL
MF63629 LIC-DB-OTHER Database temporary storage usage increases
MF63603 LIC-DB Internal Maintenance
MF63582 LIC-DB-OTHER-PERFM COMPLEX QUERY IS BEING RE-OPTIMIZED UNEXP
MF63548 LIC-DB-OTHER Internal Database Maintenance.
MF63513 OSP-DB-OTHER-F/DBOPRELTABLEMISC-T/QQQOOODBOPX/5000 SELECT ST
MF63470 LIC-DB-PERFM SMP and OLAP windowing Expressions
MF63469 SLIC-DB-OTHER Internal Maintenance
MF63452 LIC-DB-PERFM FETCH FIRST ROW query over partitioned table ru
MF63451 LIC-DB-OTHER-PERFM Queries over partition tables with a non-
MF63419 OSP-PAR-940XBASE HASH TABLE POPULATION IO COSTS ARE TOO LOW.
MF63378 LIC-DB-OTHER MCH3203 F/T DbopAffinity/QQQOOODBOP complex OR
MF63328 OSP-DB-OTHER-F/DBOPAFFINITY-T/QQQOOODBOP-MSGMCH3203 RUNNING
MF63299 LIC-DB Internal Maintenance
MF63280 LIC-DB-OTHER-PERM Improve query performance by removing extr
MF63212 LIC-DB-OTHER Internal maintenance.
MF63166 OSP-OTHER-PERFM OPNQRYF USE OF TEMPORARY INDEXES
MF63157 OSP-OTHER-PERFM QUERY RE-OPTIMIZATIONS OCCURRING
MF63118 LIC-DB-PERFM Long optimization time for OLAP and SMP queries
MF63116 LIC-DB-MSGMCH3203 Correlated Union set expression
MF63086 LIC-DB Internal Maintenance
MF63068 LIC-DB-OTHER-INCORROUT SQLRPGLE USING XML FAILS WITH SQLSTAT
MF62884 LIC-DB-PERFM Improve re-use of temporary results with Concur
MF62863 LIC-DB-PERFM Index Merge Ordering
MF62438 LIC-DB-OTHER-PERFM Improve query optimization for partitione
MF62851 LIC-DB-PERFM Excessive optimization time when MQTs enabled
MF62754 LIC-DB-OTHER-PERM Improve query performance by removing extr
MF62713 LIC-DB-MSGMCH3203 DbopNOde-getComplicatedExprs__8DbopNodeCFR
MF62667 SLIC-DB-MSGMCH3203 DbopAffinity During Partitioned Table Pro
MF62644 OSP-OTHER-PERFM WORKLOAD CAPPING IN ENVIRONMENTS THAT USE DB
MF62644 OSP-DB-OTHER-F/DBPMTRAP-T/QDBGETM-MSGMCH3203 MSGMCH3203 F/DB
MF62634 LIC-DB Internal Maintenance
MF62624 LIC-DB-OTHER Internal Database Maintenance.
MF62622 LIC-DB-OTHER Internal database maintenance
MF62489 LIC-DB-INCORROUT ORDER BY and Partitioned Table and RRN Prob
MF62433 LIC-DB-OTHER Internal Database Maintenance.
MF62372 LIC-DB-PERFM Not using EVI Only Access
MF62369 LIC-DB-OTHER-PERFM IMPROVE PERFORMANCE OF COMPLEX SQL QUERIE
MF62367 LIC-DB-OTHER record buffer not initialized with default valu
MF62343 LIC-DB-OTHER Optimizer support for PERCENTILE_DISC and PERCE
MF62304 LIC-DB-PERFM SMP support for OLAP queries
MF62244 LIC-DB-OTHER Internal Maintenance
MF62227 LIC-DB-MSGMCH3203-UNPRED Regression functions implemented wi
MF62196 LIC-DB-OTHER-INCORROUT WRKQRY OUTPUT IS NOT IN THE SPECIFIED
MF62118 LIC-DB-OTHER Optimizer support for PERCENTILE_CONT and PERCE
MF62079 LIC-DB Internal Maintenance
MF62056 LIC-DB-OTHER-T/QQQOOODBOP-MSGMCH3601 MSGMCH3601 T/QQQOOODBOP
MF62056 F/DBOPEXPRVALMISC-MSGMCH3203 R720 MCH3203 T/QQQOOOUPCL F/DBO
MF62041 LIC-DB-MSGMCH3203 Partitioned table query with SMP and LPG
MF61958 LIC-DB-OTHER-F/DBPMFORMAT-T/QDBGETMQO-MSGMCH3402 MSGCPF5257
MF61901 LIC-DB-OTHER Internal database maintenance
MF61855 OSP-DB-OTHER-INCORROUT INCORRECT RESULTS MAY OCCUR WITH REPL
MF61855 LIC-DB-OTHER-F/DBOPEXPRVALMISC-T/QQQOOODBOP-MSGMCH3203 FILE
MF61843 OSP-DB-OTHER-MSGCPF4204 ON A QUERY OVER A VIEW
MF61831 LIC-DB-PERFM Improve re-use of temporary results with Concur
MF61825 LIC-DB-INCORROUT WHEN BOTH REGR_COUNT AND COUNT
MF61788 OSP-DB-OTHER OUTPUT QRO HASH OF QUERY INITIATING MTI IN TRAC
MF61693 LIC-DB-MSGMCH3203 OLAP Aggregate query
MF61685 LIC-DB Internal Database Maintenance
MF61672 LIC-DB-OTHER-INCORROUT Left outer join query returns wrong r
MF61633 LIC-DB-OTHER-MSGMCH3203-F/DBOPAFFINITY-T/QQQOOODBOP followed
MF61587 LIC-DB-PERFM bad plan when running commit *ALL
MF61576 OSP-DB-OTHER-SAP400 INDEX ADVISER IS SETTING SORT TABLE TO *
MF61571 OSP-PAR-940XMISC AFTER UPGRADE TO R720 POOR QUERY PERFORMANC
MF61507 LIC-DB-PERFM SQL Improve column elimination in union queries
MF61432 LIC-DB Internal Database Maintenance
MF61332 LIC-DB Internal Maintenance
MF61301 LIC-DB Offload long EKR estimates found during optimization
MF61155 LIC-DB-PERFM - EAO with Partitioned Tables
MF61155 LIC-DB-PERFM Partitioned Table Index preload IO cost too hig
MF61149 LIC-PERFM-PAR-940XMISC Bad Query Plan
MF61126 LIC-DB-OTHER-F/QDBSIGEX-MSGCPF5149 MAY OCCUR WHEN USING USIN
MF60927 LIC-DB Plan Cache Property Number of created MTIs is zero
MF60927 LIC-DB-INCORROUT SMP XML INCORRECT OUTPUT AFTER UPGRADE
MF60927 LIC-DB-OTHER-INCORROUT SQL LOCATE with VARCHAR columns and t
MF60927 LIC-DB-PERFM SQL Honor KEEPINMEM MEMORY_POOL_PREFERENCE for
MF61255 OSP-DB-OTHER-F/DBPMTRAP-T/QQQOOODBOP-MSGMCH3203 VL0600BADD V
MF61492 LIC-DB-OTHER Add key range estimate information to Visual Ex
Summary Information
System.............................. i
Models..............................
Release............................. V7R3M0
Licensed Program.................... 5770999
APAR Fixed.......................... View details for APAR MA47900
Superseded by:...................... View fix details for PTF MF70707
Recompile........................... N
Library............................. QSYS
MRI Feature ........................ NONE
Cum Level........................... C0128730
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, 2021, 2022, 2023 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.
Was this topic helpful?
Document Information
Modified date:
05 June 2023