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

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.

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

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