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

Lucene indexes do not handle UPPER and LOWER case operands together with LIKE constraints correctly

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 5.4.1.Final
    • 5.4.0.Final
    • Indexing
    • None

    Description

      When running a query like SELECT * FROM [mix:title] WHERE UPPER([jcr:title]) LIKE '%TITLE%' against a Lucene index, this will not return the correct results even if it has the correct indexed data.

      Attachments

        Activity

          People

            hchiorean Horia Chiorean (Inactive)
            hchiorean Horia Chiorean (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: