Details

      Description

      Search indexer command ezplatform:create_sql_search_index creates database entries with `dot` (.) at the end of a word (table ezsearch_word, field word). see screenshot

        Activity

        Hide
        Andrzej Longosz added a comment -
        Show
        Andrzej Longosz added a comment - Kernel PR ( 6.5 backport): https://github.com/ezsystems/ezpublish-kernel/pull/1814
        Show
        André Rømcke added a comment - Merged:; https://github.com/ezsystems/ezpublish-kernel/commit/ba75da6fd3329fa70a34d66e435a96899cef1d7d
        Hide
        Paulo Nunes added a comment - - edited

        QA Approved

        Show
        Paulo Nunes added a comment - - edited QA Approved
        Hide
        Andrzej Longosz added a comment - - edited
        Show
        Andrzej Longosz added a comment - - edited New PR: https://github.com/ezsystems/ezpublish-kernel/pull/1823
        Hide
        Andrzej Longosz added a comment -
        Show
        Andrzej Longosz added a comment - Merged Kernel PR #1823 at 6.5@2e48a5b
        Hide
        Yannick Roger (Inactive) added a comment -

        Is the follow up needed or you fixed it all ?

        Show
        Yannick Roger (Inactive) added a comment - Is the follow up needed or you fixed it all ?
        Hide
        Andrzej Longosz added a comment -

        All is fixed here

        Show
        Andrzej Longosz added a comment - All is fixed here
        Hide
        Paulo Nunes added a comment -

        Creating the following objects
        Folder1
        Folder1.
        Folder*
        Folder1.test
        Image1 with attached "picture.jpg"

        When doing the following searches, I obtained the following results (Solr results as well for comparison)

        Search Criteria Results without the fix Results with the fix Results with Solr
        Folder1 Folder1 Folder1.; Folder1.test; Folder1* Folder1.; Folder1.test; Folder1*
        Folder1. Folder. Folder1.; Folder1.test; Folder1* Folder1.; Folder1.test; Folder1*
        Folder1* Folder1; Folder1.; Folder1.test; Folder1* Folder1.; Folder1.test; Folder1* Folder1.; Folder1.test; Folder1*
        Folder1.test Folder1.test Folder1.; Folder1.test; Folder1* Folder1.; Folder1.test; Folder1*
        Test No Result Folder1.Test Folder1.test
        Folder No Result No Result No Result
        Image1 Image1 Image1 Image1
        picture.jpg No result No result No result

        And with the fix, there is no "." as suffix in the "word" field on "ezsearch_word" table.

        Being so, this last fix seems to solve the issue

        Show
        Paulo Nunes added a comment - Creating the following objects Folder1 Folder1. Folder* Folder1.test Image1 with attached "picture.jpg" When doing the following searches, I obtained the following results (Solr results as well for comparison) Search Criteria Results without the fix Results with the fix Results with Solr Folder1 Folder1 Folder1.; Folder1.test; Folder1* Folder1.; Folder1.test; Folder1* Folder1. Folder. Folder1.; Folder1.test; Folder1* Folder1.; Folder1.test; Folder1* Folder1 * Folder1; Folder1.; Folder1.test; Folder1* Folder1.; Folder1.test; Folder1* Folder1.; Folder1.test; Folder1* Folder1.test Folder1.test Folder1.; Folder1.test; Folder1* Folder1.; Folder1.test; Folder1* Test No Result Folder1.Test Folder1.test Folder No Result No Result No Result Image1 Image1 Image1 Image1 picture.jpg No result No result No result And with the fix, there is no "." as suffix in the "word" field on "ezsearch_word" table. Being so, this last fix seems to solve the issue
        Hide
        Paulo Nunes added a comment -

        QA Approved

        Show
        Paulo Nunes added a comment - QA Approved

          People

          • Assignee:
            Unassigned
            Reporter:
            Damian Zabawa
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Time Tracking

              Estimated:
              Original Estimate - Not Specified
              Not Specified
              Remaining:
              Remaining Estimate - 0 minutes
              0m
              Logged:
              Time Spent - 4 hours
              4h