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

Problem with full text search and bind variable

    XMLWordPrintable

Details

    Description

      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).

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: