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
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.