Oracle Text Missing Words
925224Mar 21 2012 — edited Mar 21 2012I performed the following searches and recieved a different number of results. Can anyone explain why?
select * from table where upper(clobField) like '%AN%'
select * from table where contains(clobField, '%AN%', 1) > 0
When I perform the following search, i can see obvious clobs that contain the requested text but are not returned in the oracle text search.
select * from table where upper(clobField) like '%AN%' and not contains(clobField, '%AN%', 1) > 0
I am using a basic lexer with all default settings. Also, i can search on other words in the rejected clobs that will return them just fine. The words i have found so far that i cannot search on are "an" and "which", and that's when i stopped in frustration. Thank you for any help!