CMIS Query - contains with * wildcard

[iv0id]

Hello,

I've been using cmis query lately and i'm facing a problem using the CONTAINS() predicate function.
So, lets say we have the following documents that are all of the same type :

<ul>
<li>doc_test_100_25-09-2014 </li>
<li>doc_test_public_100_25-09-2014</li>
<li>doc_test_private30-09-2014</li>
</ul>

<strong>Query 1 : </strong>
When i execute this query :

SELECT D.cmis:name FROM cmis:document D WHERE CONTAINS(D,'cmis:name:test')‍

i get "doc_test_public_100_25-09-2014" and "doc_test_private30-09-2014" as results

<strong>Query 2 : </strong>
But when append "*" to the query

SELECT D.cmis:name FROM cmis:document D WHERE CONTAINS(D,'cmis:name:test*')‍

i get all the documents as a results

Why in the "Query 1" i get only the last two documents (even the first document contains also the word "test") and in the "Query 2" i get all the documents.

in the same logic if i use the word "doc_test" in the contains function it returns the last two documents but if is use "doc_test*" it doesn't return any results.

[kaynezhang]

Upgrade to a newer alfresco version ,both of the two queries(including using doc_test keyword) will return all of the three nodes

[iv0id]

thank you kaynezhang for your reply, will the 4.2.f version do the work ?

[kaynezhang]

It should work,you can download 4.2.f and give it a test.

[iv0id]

So i upgraded to 4.2.f and here is the results : for both keywords if i use only "keyword" it returns the last two nodes (doc_test_public_100_25-09-2014 and doc_test_private30-09-2014) but if i include the * it returns all the nodes. i'll keep this version for now since it respond to my needs

[kaynezhang]

OK good luck