Hello everyone,
I am performing full-text-search on a table containing word documents
in it's column. The search  results fair when a single word is
searched. i.e. when I fire the following query:

     select * from docs where contains(document, '"java"');

but if I try to search the a full line or give multiple words in the
text to be searched, then it shows no results, even if there is same
text present in the document stored in the database.
      select * from docs where contains(document, '"this text is in
database"');
what could be the possible cause of the problem. Shouldn't the FTS
return the records which contains even a single word in the queried
text.
Please help me with the issue.
Thanks & Regards,
Varun Narang.