Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-26447

Inconsistent behavior between index and database when performing phrase searches (using quotes)

    Details

      Description

      CustomSQLUtil does not recognize quoted phrases as phrases and instead treats them as separate words with quotes included.

      For example, if you search for "short blue", CustomSQLUtil will parse that as one term "short and another term blue". This results in no results even if something contains the phrase "short blue".

      To reproduce this issue -

      1. Create an organization named Short Blue.
      2. In the keyword search, search for "short blue" (with quotes). You will see one result.
      3. Shut down the server and set organizations.search.with.index=false
      4. Startup the server and search for "short blue" (with quotes). You will see no results.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  5 years, 47 weeks, 2 days ago

                  Packages

                  Version Package
                  6.1.X EE
                  --Sprint 11/12
                  6.2.0 CE M2