I have detected a strange behaviour in CMIS queries using CONTAINS() and wildcards.
For example, I have a folder named "Someco" and I want to find it by part of its name using wildcards:
SELECT * from cmis:folder WHERE CONTAINS('cmis:name:"*Some*"')
This query find the the folder as is expected, but if I add a 'o' or an 'a' to the query as:
SELECT * from cmis:folder WHERE CONTAINS('cmis:name:"*Someo*"')
The modified query find my folder too, wich is incorrect as my folder does not contains "Someo" in its name.
¿Is there any way to correct this behaviour with the syntaxis of the query?