Oracle Index hint with UniScript.ScriptText

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for universal data access
Post Reply
Rickybibi
Posts: 2
Joined: Wed 26 Feb 2020 04:33

Oracle Index hint with UniScript.ScriptText

Post by Rickybibi » Wed 26 Feb 2020 04:45

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

Rickybibi
Posts: 2
Joined: Wed 26 Feb 2020 04:33

Re: Oracle Index hint with UniScript.ScriptText

Post by Rickybibi » Wed 26 Feb 2020 17:40

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 ?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Oracle Index hint with UniScript.ScriptText

Post by Shalex » Thu 05 Mar 2020 18:06

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Oracle Index hint with UniScript.ScriptText

Post by Shalex » Sat 04 Apr 2020 11:43

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

Post Reply