RE: Oracle Context index returning inconsistent results
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Mon, 26 Jan 2009 12:51:00 -0600 (CST)
Message-ID: <66b098b6a20072dccb16ea6d166ad468.squirrel_at_society.servebeer.com>
Is there a difference in the SCORE returned in your tests? See:
Date: Mon, 26 Jan 2009 12:51:00 -0600 (CST)
Message-ID: <66b098b6a20072dccb16ea6d166ad468.squirrel_at_society.servebeer.com>
Is there a difference in the SCORE returned in your tests? See:
http://download.oracle.com/docs/cd/A57673_01/DOC/server/doc/CO20APP/ch08.htm
It may be an indicator of where to look.
Rich
> Does not work:
> where contains (title,'5:1254C')
> where contains (title,'%05:1254C')
>
> Works
> where contains (title,'%5:1254C')
> where contains (title,'05:1254C%')
> where contains (title,'%05:1254C%')
>
> So it works when I put a wildcard at the beginning only if it replaces the
> zero. However, it always works when I put a wildcard at the end, even if I
> start the string with the zero. Another inconsistency.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 26 2009 - 12:51:00 CST