Devart Forums

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

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 ?

Thank you for your report. We will notify you when the issue is fixed.

The bug with replacing /* by /** in UniCommand.CommandText is fixed in v3.80.2109: viewtopic.php?f=4&t=40460.