CTXCAT index problem: SUBSTRING_INDEX parameter doesn't work
I need a help with ctxcat index on Oracle 10g. I need to improve searching using CTXCAT index. All is working quite well except SUBSTRING_INDEX parameter. I thought that following was necessary and sufficient:
EXEC ctx_ddl.create_preference('KEVFT_WL', 'BASIC_WORDLIST');
EXEC ctx_ddl.set_attribute('KEVFT_WL', 'substring_index', 'YES');
EXEC ctx_ddl.set_attribute('KEVFT_WL', 'prefix_index', 'YES');
EXEC ctx_ddl.set_attribute('KEVFT_WL', 'prefix_min_length', 1);
EXEC ctx_ddl.set_attribute('KEVFT_WL', 'prefix_max_length', 6);
This BASIC_WORDLIST preference set is used for index creation. But the problem is, that when I try to search using query:
SELECT * FROM TMP_FULLTEXT
WHERE CATSEARCH(fulltext, '%abc', null)> 0;
then I get no rows in results. Despite the fact that row with the text 'aabc' exists in the table.
Can anyone tell me what the problem is?
I would appreciate ANY idea or help
So, It seems like my problem is not solvable :(
Please if someone has any idea, any question or any help, please write it down.
I am still searching for the solution, but I am getting crazy :(
Thanx a lot for ANY help.
I am not to sure but how could you give null in the where condition when null is a system generated value
Click Here to Expand Forum to Full Width