Intermedia Text 8.1.7.2 Generating Incorrect Highlights

From: Craig Christman <res00mae_at_gte.net>
Date: Sat, 15 Sep 2001 13:45:59 GMT
Message-ID: <rYIo7.488$Is4.120276@paloalto-snr1.gtei.net>

We're using CTX_DOC.HIGHLIGHT to generate highlight offsets for full-text query results. For the first few pages the highlight offsets are correct but begin to creep down the page after about the 10th hit (the offset returned by Oracle is at position 700, for example, but should be 698). Interestingly, CTX_DOC.MARKUP works correctly.

Oracle support hasn't been helpful so far. The support tech references bug number 1846487, but I can't find it on Metalink.

Database version is 8.1.7.2 running under Solaris 8.

Any help is appreciated.

Here's our script:

Main table create table doc_main( ads_udi varchar(11) primary key
,text char(1)
);
Detail create table ocr( ads_udi varchar(11) references doc_main
,ads_page number(4)
,text clob
,constraint ocr_pk primary key(ads_udi,ads_page)
);

begin

ctx_ddl.create_preference('tob_doc_md','DETAIL_DATASTORE');
ctx_ddl.set_attribute('tob_doc_md','detail_table','OCR');
ctx_ddl.set_attribute('tob_doc_md','detail_key','ADS_UDI');
ctx_ddl.set_attribute('tob_doc_md','detail_lineno','ADS_PAGE');
ctx_ddl.set_attribute('tob_doc_md','detail_text','TEXT');

end;

create index doc_main_idx on doc_main(text) indextype is ctxsys.context parameters('datastore tob_doc_md'); Received on Sat Sep 15 2001 - 08:45:59 CDT