Uploaded image for project: 'Search and Discovery'
  1. Search and Discovery
  2. SEARCH-2461

Exact term queries behave differently against the DB and Solr

    Details

    • Type: Bug
    • Status: Open
    • Resolution: Unresolved
    • Affects Version/s: Search Services 2.0
    • Fix Version/s: None
    • Labels:
      None
    • Bug Priority:
      Category 1

      Description

      Steps to reproduce

      1. Index a document with cm:name set to Taxi Driver.
      2. Send an AFTS query to Solr for =cm:name:Driver and check that the document is returned.
      3. Send an AFTS query via the v1 REST API for =cm:name:Driver

      Expected result
      4. The document is returned.

      Actual result
      4. The document is not returned.

      Investigation

      This is caused by a difference in behaviour of queries handled by the DB and queries handled by SS 2.0.

      If we modify the query slightly, e.g. to =cm:name:Driver AND cm:name:* then the query is redirected to Solr and the document is returned.

      Notes

      This issue was raised by Axel here: https://hub.alfresco.com/t5/alfresco-content-services-blog/exact-term-queries-in-search-services-2-0/bc-p/302201/highlight/true#M2474

      This could either be seen as a regression (queries behave differently depending on where they are handled) or as an existing issue (DB queries have never handled exact term searches as documented).

        Attachments

        1. JustSettingCmName.png
          JustSettingCmName.png
          47 kB
        2. name_name_field.png
          name_name_field.png
          21 kB
        3. name_title_field.png
          name_title_field.png
          57 kB
        4. search_title_field.png
          search_title_field.png
          22 kB

          Structure

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                tpage Tom Page
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Structure Helper Panel