RE: Oracle Context index returning inconsistent results

>Is there any danger that 05 is being indexed as 5? in which case you could
try
 
>> SQL> select *
>>   2  from inventory
>>   3  where contains (title,'5:1254C') > 0


>Regards Nigel

I tried the suggestion above and did a bit more testing:

Remember, the actual value in the db is 05:1254C

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.


Bob



--
http://www.freelists.org/webpage/oracle-l

Other related posts: