Oracle Intermedia Text

From: <rick_stephenson_at_ovid.com>
Date: Thu, 20 Dec 2001 12:54:03 -0800
Message-ID: <F001.003E1359.20011220124145@fatcity.com>

I am using Oracle 8.1.7.2 on Solaris 2.8

Here is the script I am running:

create table testtext ( searchfield varchar(100));

insert into testtext values ('rstephenVb03R/o2Vi7Iwomigod/o/r/rstephen'); insert into testtext values ('gar001wuHkq2GP3o3O.rstephen/o/g/gar001');

create index testtext_idx on testtext(searchfield) indextype is ctxsys.context;

column searchfield format a50

PROMPT
PROMPT select score(1), searchfield from testtable2 where contains(searchfield,'
rstephen' ,1) > 0;
select score(1), searchfield from testtable2 where contains(searchfield,'rstephe
n' ,1) > 0;

PROMPT
PROMPT select score(1), searchfield from testtable2 where contains(searchfield,'
stephen' ,1) > 0;
select score(1), searchfield from testtable2 where contains(searchfield,'stephen
' ,1) > 0;

Here are the results:

Table created.

1 row created.

Index created.

select score(1), searchfield from testtable2 where contains(searchfield,'rstephen' ,1) > 0

SCORE(1) SEARCHFIELD

---------- --------------------------------------------------
         3 rstephenVb03R/o2Vi7Iwomigod/o/r/rstephen
         3 gar001wuHkq2GP3o3O.rstephen/o/g/gar001

2 rows selected.

select score(1), searchfield from testtable2 where contains(searchfield,'stephen' ,1) > 0

no rows selected

So, why does the first query work and not the second one? 'stephen' exists in the searchfield as well.

Oracle Intermedia text is new to me, so any help would be appreciated,

Thanks,

Rick Stephenson

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: rick_stephenson_at_ovid.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Dec 20 2001 - 14:54:03 CST