SAP Knowledge Base Article - Preview

2304071 - SAP IQ use of a special value or a user SQL function generate the incorrect query plan

Symptom

When a CURRENT USER special value and a user SQL function are used combining a sub query, the incorrect query plan is generated

Performance reduces this issue in order to generate the incorrect plan.
And the incorrect query plan will write out two or more divided HTML query plans.

For example, when the following SQL is run by iqdemo, IQ outputs two HTML query plans.

sap>: dbisql -c 'uid=dba;pwd=sql' -host xxxxxxx -port 2638 -nogui test.sql

ID LineID ProductID Quantity ShipDate CURRENT USER
--------------------------------------------------------------
2082 1 401 48 2001-07-09 DBA  <----- 1 row

sap>: ls -al *.html

-rw-r--r-- 1 sapuser sap 31952 Nov 14 15:02 DBA_L_0__20121114-150244_96.html
-rw-r--r-- 1 sapuser sap 29040 Nov 14 15:02 DBA_L_0__20121114-150244_97.html

For example, if the SELECT result is 10,000, the query plan will be created 10,000.


Read more...

Environment

  • SAP IQ 15.1 and later
  • SAP IQ 16.x

Product

SAP IQ 16.0

Keywords

function , sub query , query plan, plan, CIS_Option, 2048, CIS, UDF , KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.