Hi
Most properties are tokenised.
Dates and Numerical fields will behave as you expect in SQL queries.
Text, content and mltext fields will give matches against tokens (and for mltext matches for tokens in other locales by default)
cm:name is special.
It is alanysed twice - one for the FTS and once "as is".
So for name CMIS queries will do an exact match. Other properties can do this if you change then to tokenised "both" in the model and reindex.
CMIS will do an exact match if the model says it is supported - otherwise it will fall back to using FTS style matching.
If you use name in CONTAINS() you can treat it as tokens by default or an an identifier using the the = prefix.
Andy