Hi Erik, fulltext index is a very basic implementation of a full text search (probably it will be discontinued in next releases), it just splits sentences in words based on blank spaces and then performs search on single words, so if you use more than a word in a "containstext" constraint, it will not return any results. I suggest you to use a Lucene index to have better indexing, more flexibility and much better performance
http://www.orientechnologies.com/docs/last/orientdb-lucene.wiki/Full-Text-Index.html Luigi 2015-01-07 5:12 GMT+01:00 Erik Peterson <[email protected]>: > Correction. Works without fulltext index. Fails with fulltext index. > > > On Tuesday, January 6, 2015 8:54:52 PM UTC-7, Erik Peterson wrote: >> >> I have a simple class geo with location property with string items like >> "united states" >> "houston, texas, united states" >> ... >> >> select geo where location containstext "united" >> Returns records as expected >> >> However... >> >> select geo where location containstext "united " >> select geo where location containstext "united s" >> select geo where location containstext "united states" >> etc. >> Does not return records as expected. No records are returned. >> >> Why? >> >> Same behavior with and without index. >> >> >> >> -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
