I'm using dotConnect Universal 3.80.2038.
Why UniScript.ScriptText changing the /*+ to /**+
Exemple:
SELECT /*+ INDEX(EH IDX_HOR_EMPL_DATE) */ ID_R_EMPLHORAIRE
FROM R_EMPLHORAIRE EH
to this
SELECT /**+ INDEX(EH IDX_HOR_EMPL_DATE) */ ID_R_EMPLHORAIRE
FROM R_EMPLHORAIRE EH
This causing that Oracle doesn't use the index hint
Thanks
Oracle Index hint with UniScript.ScriptText
Re: Oracle Index hint with UniScript.ScriptText
Update
I'm found that UniScript.ScriptText replace EVERY /* by /** !!!!!
Why ?
I tried with a simple UniCommand ExecuteNonQuery() and it does the same.
There is a way to prevent this ?
I'm found that UniScript.ScriptText replace EVERY /* by /** !!!!!
Why ?
I tried with a simple UniCommand ExecuteNonQuery() and it does the same.
There is a way to prevent this ?
Re: Oracle Index hint with UniScript.ScriptText
Thank you for your report. We will notify you when the issue is fixed.
Re: Oracle Index hint with UniScript.ScriptText
The bug with replacing /* by /** in UniCommand.CommandText is fixed in v3.80.2109: viewtopic.php?f=4&t=40460.