Uploaded image for project: 'Solr'
  1. Solr
  2. SOLR-15463

Solr SQL predicate with wildcard doesn't match, needs the complex phrase query parser

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 9.0, 8.10
    • Parallel SQL

    Description

      I have a query:

      SELECT a_s, count(*) as cnt FROM $ALIAS WHERE a_s='hello*' GROUP BY a_s ORDER BY count(*) desc LIMIT 10

      This fails to match documents that should match. The problem is the query that gets generated is q=a_s:"hello*".
      Query should get generated like:

      {!complexphrase}a_s:"hello*"

      which matches ...

      Attachments

        Issue Links

          is fixed by

          Improvement - An improvement or enhancement to an existing feature or task. SOLR-15460 Solr SQL doesn't support LIKE operator

          • Major - Major loss of function.
          • Closed

          Activity

            People

              thelabdude Timothy Potter
              thelabdude Timothy Potter
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: