Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-2062

Problem with full text search and bind variable

XMLWordPrintable

      Hi.

      I'm trying full text search with query:

      SELECT s.*  
      FROM [service:Service] as s  
      WHERE contains(s.*, $text)  
      

      bind $text variable with 'wow' value, execute query and result is empty. Repository contains document with property 'wow'.

      when executing query lucene query looks like:
      +(::wks:system ::wks:default) +::fts:"text" +jcr:primaryType:service:Service
      but proper query is:
      +(::wks:system ::wks:default) +::fts:"wow" +jcr:primaryType:service:Service

      probably problem is here:
      PlanUtil.java

      here is new FullTextSearch object, but without field StaticOperand expression
      and when call getFullTextSearchExpression FullTextSearch.java expression replaced by Literal (proper expression is BindVariableName).

              Unassigned Unassigned
              ybrig Yury Brigadirenko (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: