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

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

      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.

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

                Created:
                Updated:
                Resolved: