Re: DRG-50901 and escape characters

From: neo <nelsounet_NO_SPAM__at_free.fr_NO_SPAM>
Date: Fri, 21 Sep 2007 16:40:06 +0200
Message-ID: <46f3d82e$0$9020$426a74cc@news.free.fr>

"Jerome Vitalis" <vitalis..._at_gmail.com> a écrit dans le message de news: 46f3d262$0$11307$426a74cc_at_news.free.fr...
> neo wrote:
>
>> I'm sorry there's ")" which shouldn't be here.
>> You may read :
>
>> 1st One :
>> SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting(%' ) > 0)
>> 2nd One :
>> SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting%' ) > 0)
>> 3rd One :
>> SELECT COL1 FROM TABLE1 WHERE (CONTAINS(COL1, 'someting(' ) > 0)
>
> No problem for me with the first one:
>
> SQL> select * from t where contains(x,'printf\(%')>0;
>
> X
> --------------------------------------------------------------------------------
>
> then printf($foo);
>
>
> Post the actual output from sqlplus along with your Oracle version.
>
> Is your context index up-to-date?
> -----
> échangez opinions et commentaires dans les forums de discussion.
> http://www.usenetgratuit.com/
>

Here is the Output :

SQL*Plus: Release 9.2.0.8.0 - Production on Ve Sep 21 16:34:22 2007

Connecté.
SELECT * FROM SE_VALUES WHERE (CONTAINS(ALL_FIELD_VALUE, 'someting\(%' ) > 0)
*
ERREUR à la ligne 1 :

ORA-29902: erreur d'exécution de la routine ODCIIndexStart()
ORA-20000: Oracle Text error:
DRG-51030: wildcard query expansion resulted in too many terms

Oracle Version is a : 9.2.0.7.0. I have the same problem on a 10g.

Hum I'm thinking about something, can it be linked with the stoplist - which has been set to : CTXSYS.EMPTY_STOPLIST ?

Nelson Received on Fri Sep 21 2007 - 09:40:06 CDT