title: Why Oracle Text Stemming doesn't work?
body: <p>I'm using Oracle Text on Oracle 10g. I have created a multicolumn CONTEXT index as below:</p>
  
  <p>My table is </p>
  
  <pre><code>CREATE TABLE WEB_RES
  (   
      "ID" NUMBER(10,0), 
      "TITLE" VARCHAR2(256 BYTE), 
      "DESCRIPTION" VARCHAR2(1024 BYTE), 
      "CONTENT" BLOB, 
      "CATEGORY" VARCHAR2(64 BYTE), 
      ...
      CONSTRAINT "PK_WEB_RES" PRIMARY KEY ("ID")
  }
  </code></pre>
  
  <p>My preference and index are:</p>
  
  <pre><code>execute ctx_ddl.create_preference('my_multi', 'MULTI_COLUMN_DATASTORE');
  execute ctx_ddl.set_attribute('my_multi', 'columns', 'title, description, category');
  execute ctx_ddl.create_preference( 'my_lexer', 'BASIC_LEXER' );
  execute ctx_ddl.set_attribute('my_lexer', 'index_stems', '1');
  
  create index myTitleIndex on web_res(title)
  indextype is ctxsys.context
  parameters ('DATASTORE my_multi lexer my_lexer SYNC(ON COMMIT)');
  </code></pre>
  
  <p>I have a row in my table as following:</p>
  
  <pre><code>ID            Title                                Description      Category
  ---        -----------                           --------------   ------------
  1       Superannuation Contributions Splitting      Test            Test
  </code></pre>
  
  <p>English is not my native language but shouldn't this query return a result? </p>
  
  <pre><code>SELECT * FROM web_res WHERE CONTAINS(title, '$contribute', 1) &gt; 0;
  </code></pre>
  
  <p>I expect to find a title with 'Contribution' when searching for '$Contribute' or find a title with 'approval' when searching for '$approve'. Isn't this what stemming is about?</p>
  
  <p><strong>Edit:</strong>
  I also tried the Basic_Wordlist as below, but still got no rows back for my query:</p>
  
  <pre><code>execute ctx_ddl.create_preference( 'my_wordlist', 'BASIC_WORDLIST' );
  execute ctx_ddl.set_attribute('my_wordlist', 'stemmer', 'ENGLISH');
  
  create index myTitleIndex on web_res(title)
  indextype is ctxsys.context
  parameters ('DATASTORE my_multi wordlist my_wordlist SYNC(ON COMMIT)');
  </code></pre>