When monitoring Oracle database traffic, the SQL statement which contains keywords "CASE WHEN EXISTS" is not recorded in FULL SQL report.
For example, if following SQL statement is issued on Oracle DB side:
SELECT * FROM TEST1 WHERE C1=1 AND (CASE WHEN EXISTS (SELECT 1 FROM TEST2 WHERE C2=1 ) THEN '1' ELSE '0' END)='1';
In Full SQL report, this SQL statement doesn't appear.
This is a bug fixed in V9 next GPU.
Resolving The Problem
This issue was identified after GPU 9.0p200 was released, and will be fixed in the next GPU. If you hit this issue and need an ad-hoc patch, please contact IBM Support.
Was this topic helpful?
16 June 2018